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.
- If the source database is an on-premises database, perform the following steps:
- Log in to the server where the MySQL source database is located.
- Manually change the value of binlog_row_image in the my.cnf configuration file to FULL and save the file.
binlog_row_image=full
- To close old sessions, restart the source database and reset the task during a non-service period.
General Operations FAQs
- What Can I Do When Information Overlaps on the DRS Console?
- Is the Destination Instance Set to Read-only or Read/Write?
- How Do I Set Global binlog_format=ROW to Take Effect Immediately?
- How Do I Set binlog_row_image=FULL to Take Effect Immediately?
- How Do I Change the Destination Database Password to Meet the Password Policy?
- How Do I Configure the Shard Key for a MongoDB Sharded Cluster?
- Does Bandwidth Expansion Affect the Running DRS Tasks?
- Why Data in MariaDB and SysDB Cannot Be Migrated or Synchronized?
- Constraints and Operation Suggestions on Many-to-One Scenario
- Constraints and Operation Suggestions on One-to-Many Scenario
- Where Can I View DRS Operation Logs?
- Why Is a DRS Task Automatically Stopped?
- How Can I Export a DRS Task List?
- Can a Completed Task Be Restarted?
- What Are the Differences Between Resetting a Task and Recreating a Task?
- Does DRS Support Backward Migration/Synchronization?
- Why Cannot I Select an Existing SMN Topic?
- Can I Change an SMN Topic After a Task Is Created?
- Will Data of DRS Tasks Be Lost After a Primary/Standby Switchover Occurs on the Source MySQL Database?
- What Are the Differences Between All, Tables, and Databases During DRS Object Selection?
- What Do I Do After Changing the Password of the Source or Destination Database?
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.
more