Checking Whether GTID Is Enabled for the Destination Database
MySQL Disaster Recovery
Check Item |
Whether GTID is enabled for the destination database |
---|---|
Description |
During disaster recovery, GTID should be enabled for the destination database. Otherwise, the migration fails. |
Failure Cause and Handling Suggestion |
Failure cause: GTID is disabled for the destination database. Handling suggestion: Check that the destination database binlog is enabled. Modify the parameter settings configuration file as follows to enable the destination database GTID, and then restart the database Sample command: gtid_mode = on log_slave_updates = true enforce_gtid_consistency = on Sample command: log-bin = mysql-bin binlog_gtid_simple_recovery = on |
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