Data synchronization

Last Updated: Dec 20, 2017

Data synchronization helps you replicate data between two databases in real time. It is applicable to 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 in the DTS console.

Synchronization task displays different status on creation and progress.

Synchronization Status Description Operations Available
Not started Synchronization task is configured, but 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 fails.
  • 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 fails to replicate incremental data.
  • Modify synchronization object
  • Delete
  • Configure monitor
Paused Synchronization task is suspended.
  • Start
  • Modify synchronization object
  • Delete
  • Configure monitor

Benefits

DTS synchronization offers the following features:

  • 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.