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

Checking Whether GTID Is Enabled for the Destination Database

MySQL Disaster Recovery

Table 1 Checking whether GTID is enabled for the destination database

Check Item

Whether GTID is enabled for the destination database

Description

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

Item to Be Confirmed and Handling Suggestion

Failure cause: GTID is disabled for the destination database

Handling suggestion: Check that the destination database binlog is enabled. Modify the parameter settings configuration file as follows to enable the destination database GTID, and then restart the database

Sample command:

gtid_mode = on;
log_slave_updates = true; 
enforce_gtid_consistency = on;

Sample command:

log-bin = mysql-bin
binlog_gtid_simple_recovery = on.
Parent topic: Database Parameters