Checking Whether Implicit Primary Key Check Is Enabled for the Primary and Standby Databases
MySQL Disaster Recovery
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. |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.