Help Center> Data Replication Service> Troubleshooting> Solutions to Failed Check Items> Database Objects> Checking Whether the Source Database Tables Contain Primary Keys
Updated on 2022-09-21 GMT+08:00

Checking Whether the Source Database Tables Contain Primary Keys

MySQL Migration and Disaster Recovery

Table 1 Checking whether the source database tables contain primary keys

Check Item

Whether the source database tables contain primary keys

Description

If tables to be migrated in the source database do not contain primary keys, the migration may fail.

Item to Be Confirmed and Handling Suggestion

Item to be confirmed: The tables to be migrated in the source database do not contain primary keys.

Handling suggestion: Create a primary key for the table. If the table does not have a primary key to uniquely identify every row and the network connection is unstable, the data in the destination database may be inconsistent with that in the source database.

MySQL Synchronization

Table 2 Checking whether the source database tables contain primary keys

Check Item

Whether the source database tables contain primary keys

Description

If tables to be synchronized in the source database do not contain primary keys, the synchronization may fail.

Failure Cause and Handling Suggestion

Failure cause: The tables to be synchronized in the source database do not contain primary keys.

Handling suggestion: Create primary keys for the tables to improve performance.

Failure cause: In a many-to-one task, tables with no primary key that have the same name as those in the destination database are not allowed in the source database.

Handling suggestion: Modify tables without primary keys, delete tables with no primary key from the destination database, or do not migrate tables without primary keys.

Item to Be Confirmed and Handling Suggestion

Item to be confirmed: The tables to be synchronized in the source database do not contain primary keys.

Handling suggestion: Create a primary key for the table. If the table does not have a primary key to uniquely identify every row and the network connection is unstable, the data in the destination database may be inconsistent with that in the source database.