Data synchronization helps you replicate data between two databases in real time. It is applicable for scenarios such as off-site disaster recovery, cross region data synchronization, and data synchronization between OLTP and OLAP.
Key features of DTS synchronization include:
Real-time data synchronization between two RDS instances.
Data synchronization between a RDS instances in a classic network and a RDS instances in a VPC network.
Data synchronization between two RDS instances under different Alibaba Cloud accounts.
To synchronize data between two instances, you must create a synchronization task (that is, the basic unit of data synchronication) on the DTS console.
Synchronization task displays different status on creation and progress.
|Synchronization status||Description||Operations available|
|Not started||Synchronization task has been configured, but is not started.||
|Pre-checking||Synchronization task is performing pre-check.||
|Pre-check failed||The pre-check failed.||
|Initializing||Synchronization task is migrating the existing data from the source instance to the target instance.||
|Initialize Failed||The synchronization task failed to migrate existing data.||
|Synchronizing||The synchronization task is replicating incremental data from the source instance to the target instance.||
|Failed||Synchronization task failed to replicate incremental data.||
|Paused||Synchronization task is halted.||
DTS synchronization offers convenient design features such as:
Synchronization object modification
You can add or delete synchronization objects during replication.
Synchronization exception monitoring
DTS monitors the performance of all tasks and detects problems, such as lag or abended processes. When a task fails, DTS immediately sends an alarm message to the task owner.
Synchronization performance visualization
DTS console displays crucial information, such as replication lag and task status in real time, for better insight into your key business applications.