Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the binlog_row_image Value is FULL
Updated on 2024-09-25 GMT+08:00
View PDF
Share

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