You can use DTS to synchronize data between two data sources in real time. This feature applies to multiple scenarios, such as active geo-redundancy, geo-disaster recovery, zone-disaster recovery, cross-border data synchronization, query load balancing, cloud BI systems, and real-time data warehousing.

Examples

For more information, see Overview of data synchronization scenarios.

Databases, initial synchronization types, and synchronization topologies

For more information, see Database types, initial synchronization types, and synchronization topologies.

Supported objects to be synchronized

Objects that can be synchronized include databases, tables, and columns. You can specify objects that you want to synchronize.

Advanced features

Feature Description Reference
Add and remove objects to be synchronized You can add and remove objects to be synchronized during data synchronization.
View and analyze synchronization performance Data synchronization provides diagrams for analyzing the synchronization latency, RPS, and traffic statistics. This allows you to view the performance trend of a synchronization channel. Check the synchronization performance
ETL features
  • Supports object name mappings at database, table, and column levels. With this feature, you can migrate data between two databases, tables, or columns that have different names.
  • Supports data filtering. With this feature, you can use SQL conditions to filter the required data in a specific table.

Statuses of a synchronization task

A synchronization task is a basic unit of real-time data synchronization. To synchronize data between two instances, you must create a synchronization task in the DTS console.

The following table describes the statuses of a synchronization task during creation and running.

Task status Description Available operations
Prechecking A precheck is being performed before the synchronization task is started.
  • View configurations for synchronization.
  • Delete the synchronization task.
  • Replicate synchronization configurations.
Precheck Failed The synchronization task has failed to pass the precheck.
  • Perform the precheck.
  • View synchronization configurations.
  • Modify objects to be synchronized.
  • Modify the synchronization speed.
  • Delete the synchronization task.
  • Replicate synchronization configurations.
Not Started The synchronization task has passed the precheck but is not started.
  • Perform the precheck.
  • Start the synchronization task.
  • Modify objects to be synchronized.
  • Modify the synchronization speed.
  • Delete the synchronization task.
  • Replicate synchronization configurations.
Performing Initial Synchronization The initial synchronization is in progress.
  • View synchronization configurations.
  • Delete the synchronization task.
  • Replicate synchronization configurations.
Initial Synchronization Failed Data migration has failed during initial synchronization.
  • View synchronization configurations.
  • Modify objects to be synchronized.
  • Modify the synchronization speed.
  • Delete the synchronization task.
  • Replicate synchronization configurations.
Synchronizing The task is synchronizing data.
  • View synchronization configurations.
  • Modify objects to be synchronized.
  • Modify the synchronization speed.
  • Delete the synchronization task.
  • Replicate synchronization configurations.
Synchronization Failed An error occurred during synchronization.
  • View synchronization configurations.
  • Modify objects to be synchronized.
  • Modify the synchronization speed.
  • Delete the synchronization task.
  • Replicate synchronization configurations.
Paused The synchronization task is paused.
  • View synchronization configurations.
  • Modify objects to be synchronized.
  • Modify the synchronization speed.
  • Delete the synchronization task.
  • Replicate synchronization configurations.

If a synchronization task is in the Synchronization Failed or Initial Synchronization Failed state, the task will be started and resumed within seven days. To stop data synchronization, you must manually pause or stop the synchronization task.

References