tencent cloud

Data Transfer Service

DokumentasiData Transfer ServiceData MigrationMigration to MySQL SeriesProcessing for MySQL Series Pre-Check FailureDDL Ring Linkage Synchronization Detection for Same Database and Table Objects

DDL Ring Linkage Synchronization Detection for Same Database and Table Objects

Download
Mode fokus
Ukuran font
Terakhir diperbarui: 2024-07-11 15:09:18

Check Details

In scenes requiring configuring multiple synchronization tasks such as bidirectional synchronization, many-to-one synchronization, and active-active, DDL configurations can not form a ring linkage; otherwise, DDL statements may loop in the system, causing errors.
Example: In the following figure, you can select DDL in up to two of the three synchronization tasks (1, 3, and 5) marked by blue lines. Selecting DDL in three tasks would form a ring linkage.


Fixing Solution

To modify synchronization task configurations, in Sync Options and Synchronization Objects > Data Synchronization Options > Synchronization Operation Type, adjust DDL parameter configurations to avoid forming a ring linkage.
Topik sebelumnya: TDSQL Kernel CheckTopik selanjutnya: DDL Synchronization Conflict Detection for the Same Target and Same Database and Table Object

Bantuan dan Dukungan

Apakah halaman ini membantu?

masukan