All Products
Search

This Product

    Data Transmission Service:Synchronize or migrate events

    Document Center

    Data Transmission Service:Synchronize or migrate events

    Last Updated:Mar 28, 2026

    When a DTS instance includes events, the schema that an event depends on may be synchronized or migrated to the destination database before the source database updates. This can cause data inconsistency between source and destination. Use the procedures in this topic to configure DTS to handle events explicitly and prevent inconsistency.

    Prerequisites

    Before you begin, make sure all of the following conditions are met:

    • The source database type is MySQL or PolarDB for MySQL, and the destination database type is MySQL or PolarDB for MySQL.

    • The DTS instance includes both a schema task and an incremental data task:

      • Migration instances: Select Schema Migration and Incremental Data Migration for Migration Types.

      • Synchronization instances: Incremental Data Synchronization is selected by default. Also select Schema Synchronization.

    • Source Objects is set to an entire database when you configure the task.

    Limitations

    • Each event is synchronized or migrated only once per task.

    • If Incremental Data Migration is not included in your migration instance but all other conditions are met, DTS automatically migrates events from the source to the destination.

    For migration details, see the Task Details tab in the Schema Migration 2 module.

    Configure an instance to migrate events

    The steps for data synchronization and migration instances are similar. This procedure uses a data synchronization instance as an example.

    1. Go to the Data Synchronization page.

      DTS console

      1. Log on to the DTS console.

      2. In the left-side navigation pane, click Data Synchronization.

      3. In the upper-left corner of the page, select the region in which the data synchronization instance resides.

      DMS console

      Note

      Operations may vary based on the mode and layout of the DMS console. For more information, see Simple mode and Customize the layout and style of the DMS console.

      1. Log on to the DMS console.

      2. In the top navigation bar, move the pointer over Data + AI and choose DTS (DTS) > Data Synchronization.

      3. From the drop-down list to the right of Data Synchronization Tasks, select the region in which the data synchronization instance resides.

    2. Click Create Task.

    3. (Optional) Click New Configuration Page in the upper-right corner.

      Skip this step if Back to Previous Version is displayed instead. Specific parameters in the new and previous versions of the configuration page may be different. We recommend that you use the new configuration page when available.

    4. Configure the source and destination databases. For details, see Overview of data synchronization scenarios or Overview of data migration scenarios.

    5. Click Test Connectivity and Proceed.

      Make sure the CIDR blocks of DTS servers are added to the security settings of both databases. For details, see Add the CIDR blocks of DTS servers. If the source or destination is a self-managed database and Access Method is not Alibaba Cloud Instance, click Test Connectivity in the CIDR Blocks of DTS Servers dialog box.

    6. Set Whether to migrate Event to Yes, then complete the remaining configuration. For details, see Overview of data synchronization scenarios or Overview of data migration scenarios.

    Synchronize events

    1. Go to the Data Synchronization page.

      DTS console

      1. Log on to the DTS console.

      2. In the left-side navigation pane, click Data Synchronization.

      3. In the upper-left corner of the page, select the region in which the data synchronization instance resides.

      DMS console

      Note

      Operations may vary based on the mode and layout of the DMS console. For more information, see Simple mode and Customize the layout and style of the DMS console.

      1. Log on to the DMS console.

      2. In the top navigation bar, move the pointer over Data + AI and choose DTS (DTS) > Data Synchronization.

      3. From the drop-down list to the right of Data Synchronization Tasks, select the region in which the data synchronization instance resides.

    2. Find the destination instance and click its ID.

    3. (Optional) Click Task Management in the left-side navigation pane.

    4. In the Progress area, click the Basic Information tab of the Incremental Write module.

    5. On the right side of Actions, click Migrate Event.

      image

    6. In the Confirm dialog box, click OK.

    7. View the event synchronization task details:

      1. On the right side of Progress, uncheck Hide Completed Modules.

      2. Click the Schema Migration 3 module.

      3. View the details in the Task Details tab.

      image