Checking Whether the Source Database Binlog Is Row-Based

Check whether the source database binlog format is correct. The binlog of the source database must be enabled and the row-based format must be used during incremental MySQL migration.

Failure Cause

The source database binlog is not row-based.

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.