On this page

Show all

Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether GTID Is Enabled for the Source Database

Checking Whether GTID Is Enabled for the Source Database

Updated on 2022-09-21 GMT+08:00

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;
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback