Checking Whether GTID Is Enabled for the Source Database
During data migration, GTID must be enabled for the source database. If GTID is disabled for the source database and a primary/standby switchover is performed on the source database, the task may fail.
Failure Cause
GTID is disabled on the source database.
Handling Suggestion
- If the source database is an RDS for MySQL DB instance, GTID is enabled by default and cannot be disabled. If GTID is disabled, contact RDS for MySQL O&M personnel.
- If the source database version is MySQL 5.5, GTID cannot be set, and DRS cannot be used for synchronization and DR tasks. Create a migration task.
- If the source database version is MySQL 5.6 and later, set the following parameters to enable GTID in the database configuration file. Then, restart the database for the modifications to take effect.
gtid_mode = on log_slave_updates = true enforce_gtid_consistency = on
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.