Help Center/ Data Replication Service/ User Guide (Kuala Lumpur Region)/ FAQs/ General Operations/ How Do I Set binlog_row_image=FULL to Take Effect Immediately?
Updated on 2022-08-16 GMT+08:00
View PDF
Share

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

When using DRS to migrate 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 on the source database, restart the source database and reset the task during off-peak hours. Otherwise the task may fail due to the generation of non-full image logs.

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.
  • 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 and reset the task during off-peak hours.
Parent topic: General Operations