Checking Whether the Source Database Binlog Is Row-Based

Failure Cause

Handling Suggestion

• If the source database is an on-premises MySQL database, perform the following operations to change the binlog format of the source database:
  • Method 1: You can modify the my.cnf or my.ini configuration file and restart the database.

    binlog_format=row
    
    

  • Method 2: Stop all service connections.

    set global binlog_format='ROW'
    
    

    Modify the my.cnf or my.ini configuration file.

    binlog_format=row
    
    

  In the ROW format, the log growth rate increases, which may occupy more disk space.

• If the source database is an RDS for MySQL DB instance, change the value of binlog_format of the source database to row by following the instructions provided in Modifying Parameters of an RDS for MySQL Instance. Restart the database to apply the change.