tencent cloud

Feedback

Comparison Between NewDTS and OldDTS

Last updated: 2022-10-10 17:53:13

    Overview

    The legacy version of DTS implements incremental data sync through cloud native replication, which has a strong dependency on the kernel form of the source database and has many restrictions on the features; for example, it does not support advanced features such as table name mapping and many-to-one database sync.

    The new version of DTS uses a new proprietary kernel and comprehensively improves the product features to provide more stable, available, flexible, and secure data transfer capabilities for better ease of use. Its capabilities are polished for data transfer, with advanced feature such as heterogeneous database migration and cross-account data migration.

    Feature Comparison

    Data migration

    The key features of the new and legacy versions of DTS are compared as follows:

    Item Legacy Version New Version
    Database type
  • Heterogeneous databases cannot be migrated.
  • Alibaba Cloud source databases can be migrated.
  • Heterogeneous databases can be migrated.
  • Alibaba Cloud and AWS source databases can be migrated.
  • Cross-account migration Not supported. Supported.
    Supported data types
  • It supports the migration of basic tables, views, functions, triggers, and stored procedures.
  • It supports the migration of user account information.
  • It only supports the migration of basic tables and views, while the feature of migrating functions, triggers, and stored procedures is under development.
  • It supports the migration of user account information.
  • Supported versions It does not support cross-version migration. It supports cross-version migration for most databases. For more information on the supported versions, see Databases Supported by Data Migration.
    Task progress visualization Not supported. Supported.
    Monitoring and alarming
  • It does not support metric monitoring.
  • It does not support default alarm policy.
  • It supports metric monitoring.
  • It supports default alarm policy, so that alarms will be automatically triggered for exceptions during migration.
  • Enhanced operation experience -
  • It supports migration without lock to add locks only to tables without primary keys.
  • It supports table mapping.
  • It supports instance restart or upgrade during incremental migration.
  • It decouples the migration task from databases and releases locks during incremental migration.
  • High availability (HA) It has strict restrictions for HA switch.
  • It supports HA switch of the source instance if GTID is enabled.
  • It supports HA switch of the target instance.
  • Data verification The operator must have the super privileges of the source instance account. The operator does not need to have the super privileges of the source instance account (only for certain databases currently).

    Data sync

    The key features of the new and legacy versions of DTS are compared as follows:

    Item Legacy Version New Version
    Sync type It supports one-way and one-to-one sync modes. It supports two-way, ring, and many-to-one sync modes.
    Cross-account sync It does not support cross-account sync. It supports cross-account sync.
    Supported versions It does not support cross-version sync. It supports cross-version sync. For more information on the supported versions, see Databases Supported for Data Sync.
    Content conflict It does not support content conflict check. It provides table conflict check policies and supports renaming tables.
    Primary key conflict It does not support primary key conflict policies. It provides primary key conflict processing policies:
  • Report: If a primary key conflict of tables is found during data sync, it will report an error and pause the data sync task.
  • Ignore: If a primary key conflict is found during data sync, it will keep the primary key record in the target database.
  • Overwrite: If a primary key conflict is found during data sync, it will use the primary key record in the source database to overwrite that in the target database.
  • Task progress visualization Not supported. Supported.
    Monitoring and alarming
  • It does not support metric monitoring.
  • It does not support default alarm policy.
  • It supports metric monitoring.
  • It supports default alarm policy, so that alarms will be automatically triggered for exceptions during sync.
  • Enhanced operation experience -
  • It supports table mapping.
  • It supports instance restart or upgrade during incremental sync.
  • High availability (HA) It has strict restrictions for HA switch.
  • It supports HA switch of the source instance if GTID is enabled.
  • It supports HA switch of the target instance.
  • Data subscription

    The key features of the new and legacy versions of DTS are compared as follows:

    Item Legacy Version New Version
    Database type TencentDB for MySQL only. TencentDB for MySQL, TencentDB for MariaDB, and TDSQL for MySQL.
    Subscribed data storage method The data is stored on physical machines in master/slave mode. The data is stored in the Kafka middleware, and partitioned storage of data in a single topic is supported (with partitioning strategy available), improving the consumption efficiency.
    Supported protocol Proprietary protocol with SDK for Java only. Kafka protocol with Kafka client SDKs for multiple programming languages.
    Monitoring and alarming
  • It supports metric monitoring.
  • It does not support default alarm policy.
  • It supports more metric monitoring.
  • It supports default alarm policy, so that alarms will be automatically triggered for exceptions during subscription.
  • Data channel It allows creating only one data channel for a single instance. It allows creating multiple data channels for a single instance, which can be consumed concurrently through a consumer group.
    Consumption method It supports only serial processing. It supports partitioned storage of data in a single topic for concurrent consumption of data in multiple partitions, improving the consumption efficiency.
    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