DLL Ring Sync Check for Single Database/Table Object

Last updated: 2021-11-16 16:14:00

    Check Details

    In scenarios where multiple sync tasks need to be configured, such as two-way sync, many-to-one sync, and active-active sync, DDL configuration should not form a ring; otherwise, DDL statements will loop in the system, causing errors.

    For example, among the three sync tasks (1, 3, and 5) marked by blue lines in the following figure, you can select DDL in up to two of them, and if you select three, a ring will be formed.

    Fix

    Modify the sync task configuration. In Set sync options and objects > Data Sync Option > SQL Type, modify the DDL parameter configuration to avoid rings.