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

Checking Whether the Source Database GTID Is Enabled

MySQL

Table 1 Checking whether the source database GTID is enabled

Check Item

Whether the source database GTID is enabled

Description

The source database GTID must be enabled.

Item to Be Confirmed and Handling Suggestion

Item to be confirmed: The source database GTID is disabled. To recover faulty migration tasks and destination databases more securely and efficiently, you are advised to enable GTID. Note that switching primary and standby DB instances may lead to the failure of the migration task.

Handling suggestion:

  • If the source database version is MySQL 5.5, ignore this alarm.
  • 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
Parent topic: Database Parameters