Scenario Overview
Data Sync refers to the real-time sync of data between two data sources. A sync task is performed continuously. After a task is created, the data will be continuously synchronized (almost in real time) to keep consistency between the source and target databases.
Data Sync and Data Migration share basic features. Data Sync supports simultaneous data writing to both source and target databases and features such as data conflict resolution, dynamic task configuration adjustments, and the construction of complex topologies, making it more convenient for users to manage long-term tasks.
Tencent Cloud DTS supports data sync tasks with self-built databases, TencentDB databases, and third-party cloud databases as the source or target databases. Typical scenarios are described as follows.
|
Cloud-Local Sync | Synchronize databases such as self-built databases in local IDCs, self-built databases on CVM. Reverse synchronization is supported to achieve two-way synchronization between cloud and local databases. |
Cross-Cloud Sync | DTS can sync a third-party cloud database to TencentDB instances to achieve dual-cloud sync. |
Cross-TencentDB Instance Sync | DTS can perform cross-region and cross-border database sync, and sync between database instances under different Tencent Cloud accounts. |
Sync Between IDC Databases | DTS supports two-way sync between self-built databases in local IDCs to achieve data integration and aggregation. |
Feature Overview
Sync Data Types
Supports structure sync, full sync, and incremental sync.
Structure sync: In sync task configuration, set Initialization Type to Structure Initialization.
Full sync: In sync task configuration, set Initialization Type to Structure Initialization and Full data initialization.
Incremental sync: In sync task configuration, do not select any option in Initialization Type. Select DML and DDL in Synchronization Operation Type.
Access Type
DTS supports the following access types: Public Network, Self-Build on CVM, Direct Connect, VPN Access, Database, CCN, and VPC. Based on the deployment type of the database, different access types can be selected. Each access type requires specific network conditions. For more details, see Overview. For self-built IDC databases and third-party cloud databases, you can select the following access types: Public Network, Direct Connect, VPN Access, and CCN.
For self-built databases on CVM, select Self-Build on CVM as the access type.
For TencentDB instances, select Database as the access type.
Topology
Sync to MySQL
Note：
If you need to use the following link for synchronization, you must submit a ticket. Synchronize data from MySQL/MariaDB/Percona to MariaDB.
Synchronize data from MariaDB/Percona to MySQL.
Synchronize data from or to TDSQL for MySQL.
Synchronize data from MySQL to TDSQL for PostgreSQL.
MySQL > MySQL
|
Self-Built Databases Self-built MySQL 5.5, 5.6, 5.7 and 8.0 databases in IDCs Self-built MySQL 5.5, 5.6, 5.7 and 8.0 databases on CVM | Self-Built Databases Self-built MySQL 5.5, 5.6, 5.7 and 8.0 databases in IDCs or on CVM Third-Party Cloud Providers Alibaba Cloud ApsaraDB for RDS 5.6, 5.7 and 8.0 Alibaba Cloud PolarDB 5.6, 5.7 and 8.0 Amazon RDS for MySQL 5.6, 5.7 and 8.0 Amazon Aurora MySQL 5.6 and 5.7 TencentDB for MySQL 5.5, 5.6, 5.7 and 8.0 | Supported | |
Third-Party Cloud Providers Alibaba Cloud ApsaraDB for RDS 5.6, 5.7 and 8.0 Alibaba Cloud PolarDB 5.6, 5.7 and 8.0 Amazon RDS for MySQL 5.6, 5.7 and 8.0 Amazon Aurora MySQL 5.6 and 5.7 | Self-Built Databases ++Self-built MySQL 5.5, 5.6, 5.7 and 8.0 databases in IDCs or on CVM Third-Party Cloud Providers Alibaba Cloud ApsaraDB for RDS 5.6, 5.7 and 8.0 Alibaba Cloud PolarDB 5.6, 5.7 and 8.0 Amazon RDS for MySQL 5.6, 5.7 and 8.0 Amazon Aurora MySQL 5.6 and 5.7 TencentDB for MySQL 5.5, 5.6, 5.7 and 8.0 |
|
|
TencentDB for MySQL 5.5, 5.6, 5.7 and 8.0 Sync between databases under the same Tencent Cloud root account Sync between databases under different Tencent Cloud root accounts | Self-Built Databases
Self-built MySQL 5.5, 5.6, 5.7 and 8.0 databases in IDCs or on CVM Third-Party Cloud Providers Alibaba Cloud ApsaraDB for RDS 5.6, 5.7 and 8.0 Alibaba Cloud PolarDB 5.6, 5.7 and 8.0 Amazon RDS for MySQL 5.6, 5.7 and 8.0 Amazon Aurora MySQL 5.6 and 5.7 TencentDB for MySQL 5.5, 5.6, 5.7 and 8.0 |
|
|
MariaDB > MySQL
|
Self-Built Databases Self-built MariaDB 5.5, 10.0-10.6 databases in IDCs Self-built MariaDB 5.5, 10.0-10.6 databases on CVM | Self-Built Databases Self-built MySQL 5.5, 5.6, 5.7 and 8.0 databases in IDCs or on CVM TencentDB for MySQL 5.5, 5.6, 5.7 and 8.0 | Supported | |
TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, and MariaDB 10.4) Sync between databases under the same Tencent Cloud root account Sync between databases under different Tencent Cloud root accounts
| Self-Built Databases
Self-built MySQL 5.5, 5.6, 5.7 and 8.0 databases in IDCs or on CVM TencentDB for MySQL 5.5, 5.6, 5.7 and 8.0 |
|
|
Percona > MySQL
|
Self-Built Databases Self-built Percona 5.5, 5.6, 5.7 and 8.0 databases in IDCs Self-built Percona 5.5, 5.6, 5.7 and 8.0 databases on CVM | Self-Built Databases Self-built MySQL 5.5, 5.6, 5.7 and 8.0 databases in IDCs or on CVM TencentDB for MySQL 5.5, 5.6, 5.7 and 8.0 | Supported | |
TDSQL-C MySQL > MySQL
|
TDSQL-C for MySQL 5.7 and 8.0 Sync between databases under the same root account Sync between databases under different root accounts | Self-Built Databases Self-built MySQL 5.5, 5.6, 5.7 and 8.0 databases in IDCs or on CVM TencentDB for MySQL 5.5, 5.6, 5.7 and 8.0 | Supported | |
TDSQL MySQL > MySQL
|
TencentDB for MySQL (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1) Sync between databases under the same root account Sync between databases under different root accounts | Self-Built Databases
Self-built MySQL 5.5, 5.6, 5.7 and 8.0 databases in IDCs or on CVM TencentDB for MySQL | Not supported | |
Sync to MariaDB
MySQL > MariaDB
|
Self-Built Databases Self-built MySQL 5.5, 5.6, 5.7 and 8.0 databases in IDCs Self-built MySQL 5.5, 5.6, 5.7 and 8.0 databases on CVM | Self-Built Databases Self-built MariaDB 5.5, 10.0-10.6 databases in IDCs Self-built MariaDB 5.5, 10.0-10.6 databases on CVM TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, and MariaDB 10.4) | Supported | |
TencentDB for MySQL 5.5, 5.6, 5.7 and 8.0 Sync between databases under the same root account Sync between databases under different root accounts | Self-Built Databases Self-built MariaDB 5.5, 10.0-10.6 databases in IDCs Self-built MariaDB 5.5, 10.0-10.6 databases on CVM TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, MariaDB 10.4) |
|
|
MariaDB > MariaDB
|
Self-Built Databases Self-built MariaDB 5.5, 10.0-10.6 databases in IDCs Self-built MariaDB 5.5, 10.0-10.6 databases on CVM | Self-Built Databases Self-built MariaDB 5.5, 10.0-10.6 databases in IDCs Self-built MariaDB 5.5, 10.0-10.6 databases on CVM TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, and MariaDB 10.4) | Supported | |
TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, and MariaDB 10.4) Sync between databases under the same root account Sync between databases under different root accounts | Self-Built Databases Self-built MariaDB 5.5, 10.0-10.6 databases in IDCs Self-built MariaDB 5.5, 10.0-10.6 databases on CVM TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, and MariaDB 10.4) |
|
|
Percona > MariaDB
|
Self-Built Databases Self-built Percona 5.5, 5.6, 5.7 and 8.0 databases in IDCs Self-built Percona 5.5, 5.6, 5.7 and 8.0 databases on CVM | Self-Built Databases Self-built MariaDB 5.5, 10.0-10.6 databases in IDCs Self-built MariaDB 5.5, 10.0-10.6 databases on CVM TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, and MariaDB 10.4) | Supported | |
TDSQL-C MySQL > MariaDB
|
TDSQL-C for MySQL 5.7 and 8.0 Sync between databases under the same root account Sync between databases under different root accounts | Self-Built Databases Self-built MariaDB 5.5, 10.0-10.6 databases in IDCs Self-built MariaDB 5.5, 10.0-10.6 databases on CVM TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, and MariaDB 10.4) | Supported | |
TDSQL MySQL > MariaDB
|
TencentDB for MySQL (Database versions: MySQL 8.0, Percona 5.7, and MariaDB 10.1) Sync between databases under the same root account Sync between databases under different root accounts | Self-Built Databases Self-built MariaDB 5.5, 10.0-10.6 databases in IDCs Self-built MariaDB 5.5, 10.0-10.6 databases on CVM TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, and MariaDB 10.4) | Not supported | |
Sync to TDSQL-C for MySQL
MySQL > TDSQL-C MySQL
|
Self-Built Databases Self-built MySQL 5.5, 5.6, 5.7 and 8.0 databases in IDCs Self-built MySQL 5.5, 5.6, 5.7 and 8.0 databases on CVM |
TDSQL-C for MySQL 5.7 and 8.0 | Supported | |
Third-Party Cloud Providers Alibaba Cloud ApsaraDB for RDS 5.6, 5.7 and 8.0 Alibaba Cloud PolarDB 5.6, 5.7 and 8.0 Amazon RDS for MySQL 5.6, 5.7 and 8.0 Amazon Aurora MySQL 5.6 and 5.7 | TDSQL-C for MySQL 5.7 and 8.0 |
|
|
TencentDB for MySQL 5.5, 5.6, 5.7 and 8.0 Sync between databases under the same root account Sync between databases under different root accounts | TDSQL-C for MySQL 5.7 and 8.0 |
|
|
MariaDB > TDSQL-C MySQL
|
Self-Built Databases Self-built MariaDB 5.5, 10.0-10.6 databases in IDCs Self-built MariaDB 5.5, 10.0-10.6 databases on CVM | TDSQL-C for MySQL 5.7 and 8.0 | Supported | |
TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, and MariaDB 10.4) Sync between databases under the same root account Sync between databases under different root accounts | TDSQL-C for MySQL 5.7 and 8.0 |
|
|
Percona > TDSQL-C MySQL
|
Self-Built Databases Self-built Percona 5.5, 5.6, 5.7 and 8.0 databases in IDCs Self-built Percona 5.5, 5.6, 5.7 and 8.0 databases on CVM | TDSQL-C for MySQL 5.7 and 8.0 | Supported | |
TDSQL-C MySQL > TDSQL-C MySQL
|
TDSQL-C for MySQL 5.7 and 8.0 Sync between databases under the same root account Sync between databases under different root accounts | TDSQL-C for MySQL 5.7 and 8.0 | Supported | |
TDSQL MySQL > TDSQL-C MySQL
|
TencentDB for MySQL (Database versions: MySQL 8.0, Percona 5.7, and MariaDB 10.1) Sync between databases under the same root account Sync between databases under different root accounts | TDSQL-C for MySQL 5.7 and 8.0 | Not supported | |
Sync to TDSQL for MySQL
MySQL > TDSQL MySQL
|
Self-Built Databases Self-built MySQL 5.6, 5.7 and 8.0 databases in IDCs Self-built MySQL 5.6, 5.7 and 8.0 databases on CVM |
TencentDB for MySQL (Database versions: MySQL 8.0, Percona 5.7, and MariaDB 10.1) | Not supported | |
TencentDB for MySQL 5.6, 5.7 and 8.0 Sync between databases under the same root account Sync between databases under different root accounts | TencentDB for MySQL (Database versions: MySQL 8.0, Percona 5.7, and MariaDB 10.1) |
|
|
MariaDB > TDSQL MySQL
|
Self-Built Databases Self-built MariaDB 5.5, 10.0-10.6 databases in IDCs Self-built MariaDB 5.5, 10.0-10.6 databases on CVM | TencentDB for MySQL (Database versions: MySQL 8.0, Percona 5.7, and MariaDB 10.1) | Not supported | |
TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, and MariaDB 10.4) Sync between databases under the same root account Sync between databases under different root accounts | TencentDB for MySQL (Database versions: MySQL 8.0, Percona 5.7, and MariaDB 10.1) |
|
|
Percona > TDSQL MySQL
|
Self-Built Databases Self-built Percona 5.5, 5.6, 5.7 and 8.0 databases in IDCs Self-built Percona 5.5, 5.6, 5.7 and 8.0 databases on CVM | TencentDB for MySQL (Database versions: MySQL 8.0, Percona 5.7, and MariaDB 10.1) | Not supported | |
TDSQL-C MySQL > TDSQL MySQL
|
TDSQL-C for MySQL 5.7 and 8.0 Sync between databases under the same root account Sync between databases under different root accounts | TencentDB for MySQL (Database versions: MySQL 8.0, Percona 5.7, and MariaDB 10.1) | Not supported | |
TDSQL MySQL > TDSQL MySQL
|
TencentDB for MySQL (Database versions: MySQL 8.0, Percona 5.7, and MariaDB 10.1) Sync between databases under the same root account Sync between databases under different root accounts | Self-built TDSQL for MySQL TencentDB for MySQL (Database versions: MySQL 8.0, Percona 5.7, and MariaDB 10.1) | Not supported | |
Self-built TDSQL for MySQL | TencentDB for MySQL (Database versions: MySQL 8.0, Percona 5.7, and MariaDB 10.1) |
|
|
MySQL > TDSQL TDStore
|
Self-Built Databases Self-built MySQL 5.5, 5.6, 5.7 and 8.0 databases in IDCs Self-built MySQL 5.5, 5.6, 5.7 and 8.0 databases on CVM | TDSQL for MySQL TDStore | Not supported | |
TencentDB for MySQL 5.5, 5.6, 5.7 and 8.0 Sync between databases under the same root account Sync between databases under different root accounts | TDSQL for MySQL TDStore |
|
|
MariaDB > TDSQL TDStore
|
Self-Built Databases Self-built MariaDB 5.5, 10.0-10.6 databases in IDCs Self-built MariaDB 5.5, 10.0-10.6 databases on CVM | TDSQL for TDStore | Not supported | |
TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, and MariaDB 10.4) Sync between databases under the same root account Sync between databases under different root accounts | TDSQL for MySQL TDStore |
|
|
Percona > TDSQL TDStore
|
Self-Built Databases Self-built Percona 5.5, 5.6, 5.7 and 8.0 databases in IDCs Self-built Percona 5.5, 5.6, 5.7 and 8.0 databases on CVM | TDSQL for MySQL TDStore | Not supported | |
Sync to TDSQL for PostgreSQL
MySQL > TDSQL PostgreSQL
|
TencentDB for MySQL 5.5, 5.6, 5.7 and 8.0 Sync between databases under the same root account Sync between databases under different root accounts | TencentDB for TDSQL PostgreSQL | Not supported | Sync from TencentDB for MySQL to TDSQL for PostgreSQL |
Sync to Kafka
MySQL > Kafka
|
Self-Built Databases Self-built MySQL 5.5, 5.6, 5.7 and 8.0 databases in IDCs Self-built MySQL 5.5, 5.6, 5.7 and 8.0 databases on CVM | Message Queue CKafka 1.1.1 and later | |
Third-Party Cloud Providers Alibaba Cloud ApsaraDB for RDS 5.6, 5.7 and 8.0 Alibaba Cloud PolarDB 5.6, 5.7 and 8.0 Amazon RDS for MySQL 5.6, 5.7 and 8.0 Amazon Aurora MySQL 5.6 and 5.7 | Message Queue CKafka 1.1.1 and later |
|
TencentDB for MySQL 5.5, 5.6, 5.7 and 8.0 Sync between databases under the same root account Sync between databases under different root accounts | Message Queue CKafka 1.1.1 and later |
|
MariaDB > Kafka
|
Self-Built Databases Self-built MariaDB 5.5, 10.0-10.6 databases in IDCs Self-built MariaDB 5.5, 10.0-10.6 databases on CVM | Message Queue CKafka 1.1.1 and later | |
TencentDB for MariaDB (Database versions: MySQL 8.0, Percona 5.7, MariaDB 10.1, and MariaDB 10.4) Sync between databases under the same root account Sync between databases under different root accounts | Message Queue CKafka 1.1.1 and later |
|
Percona > Kafka
|
Self-Built Databases Self-built Percona 5.5, 5.6, 5.7 and 8.0 databases in IDCs Self-built Percona 5.5, 5.6, 5.7 and 8.0 databases on CVM | Message Queue CKafka 1.1.1 and later | |
TDSQL-C MySQL > Kafka
|
TDSQL-C for MySQL 5.7 and 8.0 Sync between databases under the same root account Sync between databases under different root accounts | Message Queue CKafka 1.1.1 and later | |
TDSQL MySQL > Kafka
|
TencentDB for MySQL (Database versions: MySQL 8.0, Percona 5.7, and MariaDB 10.1) Sync between databases under the same root account Sync between databases under different root accounts | Message Queue CKafka 1.1.1 and later | Sync from TDSQL for MySQL to Kafka |
