Help Center/ Data Replication Service/ FAQs/ General Operations/ How Do I Set binlog_row_image=FULL to Take Effect Immediately?
Updated on 2024-01-23 GMT+08:00
View PDF
Share

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.

    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