Tencent Cloud

Recent Pages

DDL and DML Filtering

Last updated: 2024-12-25 15:00:38

Overview
When configuring synchronization tasks, you can select DDL and DML synchronization policies. Once the policies are set, only the SQL data that is checked will be synchronized to the target database. This allows users to flexibly set up synchronization schemes among multiple databases or split data tables based on the scenario.
Application Scope
The DDL and DML filtering feature currently supports synchronization linkages between MySQL/MariaDB/Percona/TDSQL-C MySQL/TDSQL TDStore/TDSQL MySQL/Kafka.
Directions
1. In the Sync Task settings, select different SQL policies on the Set sync options and objects page.
DML: Supports types such as Insert, Update, and Delete.
DDL:
Check DDL without enabling the Custom DDL switch to synchronize all DDLs from the source database to the target database.
Check DDL and enable the Custom DDL switch to customize and choose specific DDL policies. Only the selected policies will be synchronized to the target database.
If DDL is not checked, no DDLs will be synchronized to the target database.
﻿
2. Once the settings are completed, click Save and Next to proceed with the next steps in the synchronization task process.