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

Checking Whether GTID Is Enabled for the Source Database

MySQL

Table 1 Checking whether GTID is enabled for the source database

Check Item

Whether GTID is enabled for the source database

Description

During disaster recovery, GTID should be enabled for the source database. Otherwise, the migration fails.

Item to Be Confirmed and Handling Suggestion

Failure cause: GTID is disabled for the source database

Handling suggestion: In the configuration file of the source database, set parameters as followings. Then, restart the source 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