Major Feature Category | Feature Subitem or Description | Supporting Capability |
Sync Objects | - | Ordinary object table, index, view |
Sync Type | - | Structure sync Full sync (automatically continue with incremental after full completion) Incremental sync |
Breakpoint Resume | - | Partial support for full export (structure export, no primary key table export; stage does not support resume); Full import, incremental support. |
Task Channel Key Operation | Retry | Supported |
| Pause, recover | Supported |
| Modify sync configuration (dynamically add or remove table objects) | Not supported |
| Create similar task | Supported |
| Speed limit | Supported |
Sync Direction | Forward/Reverse | Not involved |
| Many-to-one (multiple instances merged into one/multiple tables merged into one) | Supported |
| One-to-many | Supported |
| Two-way sync | Not supported |
Structure Sync | Database table filtering | Supported |
| Column filtering | Not supported |
| Database table name mapping | Supported |
| Column name mapping | Not supported |
| Custom partitioning (specify the partition type, partition key) | MySQL/MariaDB/Percona sync to TDSQL for MySQL, source's partition table is converted into a single table at the destination |
| Skip sync table and correction | Not supported |
Full Sync | Where condition filtering | Supported |
Incremental Sync | Primary key conflict resolution policy | Conflict overwrite only |
| DML sync (INSERT/UPDATE/DELETE) | Supported |
| DML filtering | Supported |
| DDL sync | CREATE DATABASE, DROP DATABASE, ALTER DATABASE CREATE TABLE, ALTER TABLE, DROP TABLE, TRUNCATE TABLE, RENAME TABLE CREATE VIEW, DROP VIEW CREATE INDEX, DROP INDEX CREATE TABLE table name AS SELECT statement is not supported |
| DDL filtering | Supported |
| Where condition filtering | Supported |
| Scheduled sync | Not supported |
| Online DDL | Supported |
Data Consistency Check | Whole instance verification | Supported |
| Row count check | Supported |
| Sampling verification | Supported |
| Supports consistency check after Where condition filtering | Not supported |
Was this page helpful?