Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether the log_slave_updates Value in the Source Database Is Correct
Updated on 2024-11-30 GMT+08:00
View PDF
Share

Checking Whether the log_slave_updates Value in the Source Database Is Correct

To ensure that DRS can obtain all binlogs during MySQL migration, enable the log_slave_updates parameter.

Failure Cause

The log_slave_updates parameter of the source database is set to OFF.

Handling Suggestion

  1. Log in to the server where the MySQL source database is located.
  2. Run the following SQL statement to check whether the value of log_slave_updates is ON: 

    show variables like '%log_slave_updates%';

  3. Add the following content followed by [mysqld] in the MySQL configuration file my.cnf: 

    log_slave_updates=1

  4. After the modification, restart the source database during a non-service period.
Parent topic: Database Parameters