On this page

Show all

Checking Whether the Source Database GTID Is Enabled

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

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
Feedback

Feedback

Feedback

0/500

Selected Content

Submit selected content with the feedback