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 |
|
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. |
|
Precheck Failed | The synchronization task has failed to pass the precheck. |
|
Not Started | The synchronization task has passed the precheck but is not started. |
|
Performing Initial Synchronization | The initial synchronization is in progress. |
|
Initial Synchronization Failed | Data migration has failed during initial synchronization. |
|
Synchronizing | The task is synchronizing data. |
|
Synchronization Failed | An error occurred during synchronization. |
|
Paused | The synchronization task is paused. |
|
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.