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
- Log in to the server where the MySQL source database is located.
- Run the following SQL statement to check whether the value of log_slave_updates is ON:show variables like '%log_slave_updates%';
- Add the following content followed by [mysqld] in the MySQL configuration file my.cnf:log_slave_updates=1
- After the modification, restart the source database during a non-service period.
Parent topic: Database Parameters
- Failure Cause
- Handling Suggestion