tencent cloud

Feedback

Databases Supported by Data Sync

Last updated: 2022-10-12 11:44:38

    Data sync refers to the real-time sync of data between two data sources in the form of a continuous task. After a task is created, the data will be continuously synced (almost in real time) to keep consistency between the source and target databases.

    DTS supports the sync of self-built, TencentDB, and third-party cloud databases to TencentDB.

    • Cloud-local sync: DTS can sync an IDC-based self-built database to a TencentDB instance and vice versa.
    • Cross-cloud sync: DTS can sync a third-party cloud database to TencentDB instance.
    • Cross-TencentDB instance sync: DTS can sync TencentDB instances in various scenarios, such as multi-site active-active, cross-border, and cross-Tencent Cloud account sync.

    You can select different access types for different deployment modes of the source database. DTS supports the following access types: Public Network, Self-Build on CVM, Direct Connect, VPN Access, Database, and CNN. Each access type has different requirements for network conditions. For more information, see Overview.

    Data sync supports various complex topology structures, such as one-to-many, many-to-one, two-way, and ring sync. To create a complex topology, see Creating Two-Way Sync Data Structure, Creating Many-to-One Sync Data Structure, or Creating Multi-Site Active-Active IDC Architecture.

    Database types and versions supported by sync

    Data Flow Direction Sync Direction Source Database Target Database
    MySQL > TencentDB for MySQL To Tencent Cloud
    • Self-built MySQL 5.5, 5.6, 5.7, and 8.0
    • TencentDB for MySQL 5.5, 5.6, 5.7, and 8.0
    • Third-party cloud databases
      • Alibaba Cloud 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 > TencentDB for MySQL To Tencent Cloud
  • Self-built MariaDB 5.7, 8.0, 10.0, and 10.1
  • TencentDB for MariaDB 5.7, 8.0, 10.0, and 10.1
  • TencentDB for MySQL 5.5, 5.6, 5.7, and 8.0
    Percona > TencentDB for MySQL To Tencent Cloud Self-built Percona 5.5, 5.6, 5.7, and 8.0 TencentDB for MySQL 5.5, 5.6, 5.7, and 8.0
    TDSQL-C for MySQL > TencentDB for MySQL To Tencent Cloud TDSQL-C for MySQL 5.7 and 8.0 TencentDB for MySQL 5.7 and 8.0
    TDSQL for MySQL > TencentDB for MySQL To Tencent Cloud TDSQL for MySQL 5.7 and 8.0 TencentDB for MySQL 5.7 and 8.0
    MySQL > TencentDB for MariaDB To Tencent Cloud
  • Self-built MySQL 5.5, 5.6, 5.7, and 8.0
  • TencentDB for MySQL 5.5, 5.6, 5.7, and 8.0
  • TencentDB for MariaDB 5.7, 8.0, 10.0, and 10.1
    MariaDB > TencentDB for MariaDB To Tencent Cloud
  • Self-built MariaDB 5.7, 8.0, 10.0, and 10.1
  • TencentDB for MariaDB 5.7, 8.0, 10.0, and 10.1
  • TencentDB for MariaDB 5.7, 8.0, 10.0, and 10.1
    Percona > TencentDB for MariaDB To Tencent Cloud Self-built Percona 5.5, 5.6, 5.7, and 8.0 TencentDB for MariaDB 5.7, 8.0, 10.0, and 10.1
    TDSQL for MySQL > TencentDB for MariaDB To Tencent Cloud TDSQL for MySQL 5.7, 8.0, 10.0, and 10.1 TencentDB for MariaDB 5.7, 8.0, 10.0, and 10.1
    MySQL > TDSQL-C for MySQL To Tencent Cloud
    • Self-built MySQL 5.5, 5.6, 5.7, and 8.0
    • TencentDB for MySQL 5.5, 5.6, 5.7, and 8.0
    • Third-party cloud databases
      • Alibaba Cloud 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, for 8.0
      • Amazon Aurora MySQL 5.6 and 5.7
    TDSQL-C for MySQL 5.7 and 8.0
    TDSQL-C for MySQL > TDSQL-C for MySQL To Tencent Cloud TDSQL-C for MySQL 5.7 and 8.0 TDSQL-C for MySQL 5.7 and 8.0
    MySQL > TDSQL for MySQL To Tencent Cloud
  • Self-built MySQL 5.6, 5.7, and 8.0
  • TencentDB for MySQL 5.6, 5.7, and 8.0
  • TDSQL for MySQL 5.7 and 8.0
    MariaDB > TDSQL for MySQL To Tencent Cloud
  • Self-built MariaDB 5.7, 8.0, 10.0, and 10.1
  • TencentDB for MariaDB 5.7, 8.0, 10.0, and 10.1
  • TDSQL for MySQL 5.7, 8.0, 10.0, and 10.1
    Percona > TDSQL for MySQL To Tencent Cloud Self-built Percona 5.5, 5.6, 5.7, and 8.0 TDSQL for MySQL 5.7 and 8.0
    TDSQL for MySQL > TDSQL for MySQL To Tencent Cloud TDSQL for MySQL 5.7, 8.0, 10.0, and 10.1 TDSQL for MySQL 5.7, 8.0, 10.0, and 10.1
    TencentDB for MySQL > local/third-party MySQL From Tencent Cloud TencentDB for MySQL 5.5, 5.6, 5.7, and 8.0
  • Self-built MySQL 5.5, 5.6, 5.7, and 8.0
  • Alibaba Cloud MySQL 5.6, 5.7, and 8.0
  • Note:

    • "To Tencent Cloud" refers to scenarios where the target database is a TencentDB instance. "From Tencent Cloud" refers to scenarios where the target database isn't a TencentDB instance.
    • Sync requirement: At least one of the source and target databases must be a Tencent Cloud database instance.
    • The target database version must be later than or equal to the source database version.
    • To use the sync feature of TDSQL for MySQL (as the source or target database), submit a ticket for application.
    • To sync data from MySQL/MariaDB/Percona to TencentDB for MariaDB or from MariaDB/Percona to TencentDB for MySQL, submit a ticket for application.
    • Cross-account sync refers to the sync of data between the source and target TencentDB instances under different root accounts. For detailed directions, see Cross-Account TencentDB Instance Sync.

    Key features supported by sync

    Data Flow Direction Sync Direction Two-Way Sync Data Initialization Type Cross-Account Sync Source Database Access Type Target Database Access Type
    MySQL > TencentDB for MySQL To Tencent Cloud Supported
  • Structure initialization
  • Full data initialization
  • Supported Public network/Self-build on CVM/Direct Connect/VPN access/Database/CCN Database
    MariaDB > TencentDB for MySQL To Tencent Cloud Supported (two-way sync is supported only between TencentDB instances)
  • Structure initialization
  • Full data initialization
  • Supported Public network/Self-build on CVM/Direct Connect/VPN access/Database/CCN Database
    Percona > TencentDB for MySQL To Tencent Cloud Not supported
  • Structure initialization
  • Full data initialization
  • - Public network/Self-build on CVM/Direct Connect/VPN access/CCN Database
    TDSQL-C for MySQL > TencentDB for MySQL To Tencent Cloud Supported
  • Structure initialization
  • Full data initialization
  • Supported Database Database
    TDSQL for MySQL > TencentDB for MySQL To Tencent Cloud Supported
  • Structure initialization
  • Full data initialization
  • Supported Database Database
    MySQL > TencentDB for MariaDB To Tencent Cloud Supported (two-way sync is supported only between TencentDB instances)
  • Structure initialization
  • Full data initialization
  • Supported Public network/Self-build on CVM/Direct Connect/VPN access/Database/CCN Database
    MariaDB > TencentDB for MariaDB To Tencent Cloud Supported (two-way sync is supported only between TencentDB instances)
  • Structure initialization
  • Full data initialization
  • Supported Public network/Self-build on CVM/Direct Connect/VPN access/Database/CCN Database
    Percona > TencentDB for MariaDB To Tencent Cloud Not supported
  • Structure initialization
  • Full data initialization
  • - Public network/Self-build on CVM/Direct Connect/VPN access/CCN Database
    TDSQL for MySQL > TencentDB for MariaDB To Tencent Cloud Supported
  • Structure initialization
  • Full data initialization
  • Supported Database Database
    MySQL > TDSQL-C for MySQL To Tencent Cloud Supported
  • Structure initialization
  • Full data initialization
  • Supported Public network/Self-build on CVM/Direct Connect/VPN access/Database/CCN Database
    TDSQL-C for MySQL > TDSQL-C for MySQL To Tencent Cloud Supported
  • Structure initialization
  • Full data initialization
  • Supported Database Database
    MySQL > TDSQL for MySQL To Tencent Cloud Supported (two-way sync is supported only between TencentDB instances)
  • Structure initialization
  • Full data initialization
  • Supported Public network/Self-build on CVM/Direct Connect/VPN access/Database/CCN Database
    MariaDB > TDSQL for MySQL To Tencent Cloud Supported (two-way sync is supported only between TencentDB instances)
  • Structure initialization
  • Full data initialization
  • Supported Public network/Self-build on CVM/Direct Connect/VPN access/Database/CCN Database
    Percona > TDSQL for MySQL To Tencent Cloud Not supported
  • Structure initialization
  • Full data initialization
  • - Public network/self-build on CVM/Direct Connect/VPN access/CCN Database
    TencentDB for MySQL > local/third-party MySQL From Tencent Cloud Supported
  • Structure initialization
  • Full data initialization
  • - Database Public network/Self-build on CVM/Direct Connect/VPN access/CCN
    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