Checking Whether the log_slave_updates Value of the Source Database Is Correctly Configured
MySQL Migration
|
Check Item |
Whether the log_slave_updates value of the source database is correctly configured |
|---|---|
|
Description |
The migration will fail if the log_slave_updates parameter of the source database is disabled. |
|
Failure Cause and Handling Suggestion |
Failure cause: The slave_updates_check parameter of the source database must be enabled. Handling suggestion: In the MySQL configuration file my.cnf, add the "log_slave_updates=1" line under [mysqld] and restart the database for the modification to take effect. |
|
Failure cause: The source database is a standby database and the log_slave_updates value is OFF. Handling suggestion: On the source database, set log_slave_updates to ON. Then, restart the database for the modification to take effect. |
|
|
Item to Be Confirmed and Handling Suggestion |
Item to be confirmed: The source database is a standby database and the log_slave_updates value is OFF. Handling suggestion: On the source database, set log_slave_updates to ON. Then, restart the database for the modification to take effect. If no switchover or failover will occur, no operation is required. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
