Data synchronization

Last Updated: Jun 30, 2017

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.

Features

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.

Synchronization task

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.
  • Modify configuration
  • Start
  • Delete
  • Configure monitor
Pre-checking Synchronization task is performing pre-check.
  • Delete
  • Configure monitor
Pre-check failed The pre-check failed.
  • Modify configuration
  • Start
  • Delete
  • Configure monitor
Initializing Synchronization task is migrating the existing data from the source instance to the target instance.
  • Delete
  • Configure monitor
Initialize Failed The synchronization task failed to migrate existing data.
  • Modify synchronization objects
  • Delete
  • Configure monitor
Synchronizing The synchronization task is replicating incremental data from the source instance to the target instance.
  • Modify synchronization object
  • Delete
  • Configure monitor
Failed Synchronization task failed to replicate incremental data.
  • Modify synchronization object
  • Delete
  • Configure monitor
Paused Synchronization task is halted.
  • Start
  • Modify synchronization object
  • Delete
  • Configure monitor

Benefits

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.

Thank you! We've received your feedback.