Data Transmission Service (DTS) provides an easy-to-use data synchronization feature. To configure a data synchronization task, you only need to perform simple operations in the DTS console.

If you use the data synchronization feature for the first time, read the topic Manage a data synchronization task to learn how to create, monitor, and manage a data synchronization task.

Precautions

This topic provides a general procedure for configuring a data synchronization task. The procedure varies with the data sources. For more information about how to configure data synchronization tasks for specific data sources, see Overview of data synchronization scenarios.

Before you begin

If the source database is a self-managed MySQL database or runs on a PolarDB for MySQL cluster, you must enable the binary logging feature for the database. For more information, see Enable binary logging and Create an account for a user-created MySQL database and configure binary logging.

Procedure

  1. Purchase a data synchronization instance based on the database type and region of the source and destination instances. For more information, see Purchase a DTS instance.
  2. Log on to the DTS console.
  3. In the left-side navigation pane, click Data Synchronization.
  4. At the top of the Synchronization Tasks page, select the region where the data synchronization instance resides.
  5. Find the data synchronization instance and click Configure Synchronization Channel in the Actions column.
  6. Configure the source and destination instances. Configure the source and destination instances
  7. In the lower-right corner of the page, click Set Whitelist and Next.
    Note If the source instance or destination instance is an Alibaba Cloud database instance, DTS automatically adds the CIDR blocks of DTS servers to the whitelist of the database instance. This ensures that DTS servers can connect to the database instance.
  8. Select the synchronization policy and the objects to be synchronized. Click Next. Select the synchronization policy and the objects to be synchronized
    ParameterDescription
    Rename Databases and Tables

    You can use the object name mapping feature to rename the objects that are synchronized to the destination instance. For more information, see Object name mapping.

    Retry Time for Failed Connections
    By default, if DTS fails to connect to the source or destination database, DTS retries within the next 720 minutes (12 hours). You can specify the retry time based on your needs. If DTS reconnects to the source and destination databases within the specified time, DTS resumes the data synchronization task. Otherwise, the data synchronization task fails.
    Note When DTS retries a connection, you are charged for the DTS instance. We recommend that you specify the retry time based on your business needs. You can also release the DTS instance at your earliest opportunity after the source and destination instances are released.
    Replicate Temporary Tables When DMS Performs DDL Operations
    If you use Data Management (DMS) to perform online DDL operations on the source database, you can specify whether to synchronize temporary tables generated by online DDL operations.
    • Yes: DTS synchronizes the data of temporary tables generated by online DDL operations.
      Note If online DDL operations generate a large amount of data, the data synchronization task may be delayed.
    • No: DTS does not synchronize the data of temporary tables generated by online DDL operations. Only the original DDL data of the source database is synchronized.
      Note If you select No, the tables in the destination database may be locked.
  9. Select the initial synchronization types. Advanced Settings
  10. In the lower-right corner of the page, click Precheck.
    Note
    • Before you can start the data synchronization task, DTS performs a precheck. You can start the data synchronization task only after the task passes the precheck.
    • If the task fails to pass the precheck, you can click the Info icon icon next to each failed item to view details.
      • You can troubleshoot the issues based on the causes and run a precheck again.
      • If you do not need to troubleshoot the issues, you can ignore failed items and run a precheck again.
  11. Close the Precheck dialog box after the following message is displayed: The precheck is passed. Then, the data synchronization task starts.
  12. Wait until initial synchronization is completed and the data synchronization task is in the Synchronizing state.

    You can view the status of the data synchronization task on the Synchronization Tasks page.

    Status of a data synchronization task

References