Whether There Are Foreign Keys Containing Unsupported Reference Operations in the Source Database
MySQL and GaussDB(for MySQL) Serving as the Source in Full+Incremental or Incremental Migration and Synchronization, MySQL and GaussDB(for MySQL) Serving as the Source in DR
|
Check Item |
Whether there are foreign keys containing unsupported reference operations in the source database |
|---|---|
|
Description |
In a synchronization object, there are foreign keys that contain reference operations such as CASCADE, SET NULL, and SET DEFAULT. These operations will cause the update or deletion of rows in parent tables and affect records in child tables. Also, operations related to child tables are not recorded in binlogs. The DRS cannot synchronize data, and data in child tables is inconsistent. |
|
Failure Cause and Handling Suggestion |
Failure cause: In a synchronization object, there are foreign keys that contain reference operations such as CASCADE, SET NULL, and SET DEFAULT. These operations will cause the update or deletion of rows in parent tables and affect records in child tables. Also, operations related to child tables are not recorded in binlogs. The DRS cannot synchronize data, and data in child tables is inconsistent. Handling suggestion: Delete foreign keys that contain reference operations such as CASCADE, SET NULL, and SET DEFAULT from child tables, or do not synchronize these child tables. Reference statement for deleting a foreign key: ALTER TABLE table_name DROP FOREIGN KEY foreign_key_name |
Feedback
Was this page helpful?
Provide feedbackThank you very much for your feedback. We will continue working to improve the documentation.See the reply and handling status in My Cloud VOC.
For any further questions, feel free to contact us through the chatbot.
Chatbot
