Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether GTID Is Enabled for the Source Database
Updated on 2024-05-09 GMT+08:00
View PDF
Share

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 or contact O&M personnel.
  • 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.

    Parameters to be configured:

    gtid_mode = on
log_slave_updates = true
enforce_gtid_consistency = on
Parent topic: Database Parameters