tencent cloud

Feedback

Databases Supported by Data Sync

Last updated: 2024-04-01 15:42:08

    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.
    Scenario
    Description
    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

    Data sync tasks of complex topologies are supported, such as one-to-many, many-to-one, two-way, and ring sync. For information about how to construct complex topologies, see the configuration guides: Creating Two-Way Sync Data Structure, Creating Many-to-One Sync Data Structure, and Creating Multi-Site Active-Active IDC Architecture.

    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database
    Target Database
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Two-Way Sync
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Reference Documentation
    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

    Source Database and Version
    Target Database and Version
    Reference Documentation
    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
    Contact Us

    Contact our sales team or business advisors to help your business.

    Technical Support

    Open a ticket if you're looking for further assistance. Our Ticket is 7x24 avaliable.

    7x24 Phone Support