Checking Whether the binlog_row_image Value is FULL

During MySQL migration and synchronization, the binlog_row_image parameter of the source database must be set to FULL. Otherwise, the migration fails.

Failure Cause

The binlog_row_image value of the source database is not FULL.

Handling Suggestion

If the source database is an RDS DB instance on the cloud, change the value of binlog_row_image to FULL on the RDS console, and then restart the source database.
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 ensure a successful task, restart the source database during off-peak hours.

Parent topic: Database Parameters

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

Checking Whether the BLOCK_SIZE Value of the Source Database Is the Same as That of the Destination Database

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

Checking Whether the Transaction Isolation Levels are Consistent

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

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