Help Center/ Data Replication Service/ Troubleshooting/ Solutions to Failed Check Items/ Database Parameters/ Checking Whether Implicit Primary Key Check Is Enabled for the Primary and Standby Databases
Updated on 2022-09-21 GMT+08:00

Checking Whether Implicit Primary Key Check Is Enabled for the Primary and Standby Databases

MySQL Disaster Recovery

Table 1 Checking whether implicit primary key check is enabled for the primary and standby databases

Check Item

Whether implicit primary key check is enabled for the primary and standby databases

Description

Check whether create_default_primary_key is enabled for the source or destination database.

Item to Be Confirmed and Handling Suggestion

Item to be confirmed: The create_default_primary_key parameter of the source or destination database is enabled. As a result, the primary/standby switchover may fail or data may be inconsistent. You are advised to disable create_default_primary_key. If this parameter is disabled, the task may still fail after a primary/standby switchover. The possible cause is that a table without a primary key is created when this parameter is enabled.

Handling suggestion: This parameter was discarded, but in some DB instances of earlier versions, this parameter may be enabled. As a result, an error may occur during the primary/standby switchover, which may cause the task to fail or data inconsistency, you are advised to disable this parameter or ensure that the source database does not contain tables that do not have primary keys.