How Do I Set binlog_row_image=FULL to Take Effect Immediately?

When migrating MySQL databases, ensure that the binlog_row_image parameter of the source database is set to FULL. Otherwise, the migration task will fail. After binlog_row_image is set to FULL in the source database, the setting takes effect only for new sessions. To close old sessions, restart the source database and reset the task during a non-service period.

Setting binlog_row_image to FULL

If the source is an RDS instance on the cloud, change binlog_row_image to FULL on the RDS console, and then restart the source database and reset the task.
Note
The default value of binlog_row_image of RDS for MySQL 8.0 is FULL.
If the source database is an on-premises database, perform the following steps:
1. Log in to the server where the MySQL source database is located.
2. Manually change the value of binlog_row_image in the my.cnf configuration file to FULL and save the file.
```
binlog_row_image=full
```
3. To close old sessions, restart the source database and reset the task during a non-service period.

Parent topic: General Operations

Предыдущая статья

How Do I Set Global binlog_format=ROW to Take Effect Immediately?

Следующая статья

How Do I Change the Destination Database Password to Meet the Password Policy?

Была ли эта статья полезна?

Поддержка Юридические документы