Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the Source Database Binlog Is Enabled
Updated on 2024-09-25 GMT+08:00
View PDF
Share

Checking Whether the Source Database Binlog Is Enabled

Check whether Binlog is enabled for the source database. During an incremental MySQL migration, Binlog of the source database must be enabled.

Failure Cause

Binlog is not enabled for the source database.

Handling Suggestion

  • If the source is an on-premises MySQL database, perform the following operations to enable Binlog.
    1. Run the following command to check whether Binlog is enabled: 
      show variables like "log_bin";

    2. If Binlog is disabled, add log-bin = mysql-bin followed by [mysqld] in the MySQL configuration file my.cnf or my.ini.

    3. Restart the database.

  • If the source is an RDS for MySQL DB instance, Binlog is enabled by default and no additional configuration is required. binlog_format is set to row..
  • If the source is a TiDB database, add enable=true followed by [binlog] in the database configuration file and restart the database to apply the settings.
Parent topic: Database Parameters