One-click fix

Prerequisites

The target DTS instance must meet the following requirements:

• The instance must be for data synchronization and include the Incremental Data Collection module.

• the Database Type of the destination database is PolarDB for MySQL, , or AnalyticDB for MySQL 3.0.

  Note

  AnalyticDB for MySQL 3.0 Enterprise Edition is not supported.

• The DTS instance must have an abnormal table, and the one-click fix option must be available in the Incremental Write module.

Usage notes

• This feature is in beta testing and is available only to some users.

• Only data synchronization instances (excluding serverless instances) support this feature.

• During the Resynchronize phase, DTS uses the Modify Synchronization Objects feature to create a subtask that includes schema synchronization, full data synchronization, and incremental data synchronization.

• During the Restore Abnormal Table phase, DTS renames tables.

Procedure

1. Go to the data synchronization task list page in the destination region. You can do this in one of two ways.

   DTS console

   1. Log on to the DTS console.

   2. In the navigation pane on the left, click Data Synchronization.

   3. In the upper-left corner of the page, select the region where the synchronization instance is located.

   DMS console

   Note

   The actual steps may vary depending on the mode and layout of the DMS console. For more information, see Simple mode console and Customize the layout and style of the DMS console.

   1. Log on to the DMS console.

   2. In the top menu bar, choose Data + AI > DTS (DTS) > Data Synchronization.

   3. To the right of Data Synchronization Tasks, select the region of the synchronization instance.

2. Find the target instance.

   Filter by task name, instance ID, or database instance ID to find the target instance.

   Further filter by criteria such as Status, Sort (the default is Sort by Creation Time in Descending Order), Environment Tag, and Tag Filter.

3. Click the ID of the target instance.

4. Optional: In the left-side navigation pane, click Task Management.

5. In the Progress section, click the Incremental Write module.

6. On the Basic Information tab, initiate the one-click fix from the DTS One-click Fix section.

   Note

   • During the process, manually click the button above the Incremental Write module to refresh the task status.

   • After the one-click fix operation is complete and the instance is restored, the DTS One-click Fix section disappears.

   1. Authorize DTS to perform the one-click fix operation.

      Note

      The one-click fix operation primarily includes filtering the abnormal table, creating a subtask, and renaming tables.

      Click Authorize at the bottom of the tab, then click OK in the dialog box.

   2. Filter the abnormal table to stop synchronizing its data and restore the DTS instance.

      After authorization is complete, click Confirm at the bottom of the tab, then click OK in the dialog box.

   3. Resynchronize the abnormal table.

      Important

      DTS creates a subtask that includes schema synchronization, full data synchronization, and incremental data synchronization. This subtask creates a temporary table in the target database to hold the full and incremental data from the abnormal table.

      After the abnormal table is filtered, click Confirm at the bottom of the tab, then click OK in the dialog box.

      The confirmation dialog box states that recovery time depends on the data volume of the abnormal table; larger tables require more time.

   4. Restore synchronization for the abnormal table.

      Note

      DTS first renames the original abnormal table in the target database to a backup table (for example, renames table1 to table1_<DTS_instance_ID>_bak_****). Then, it renames the temporary table created during resynchronization to the original table's name.

      After the resynchronization phase is complete, click Confirm at the bottom of the tab, then click OK in the dialog box.

FAQ

• Which tables are renamed during the one-click fix operation?

  DTS renames only the original abnormal table in the target database and the temporary table created during the Resynchronize phase.

• Can a one-click fix task be terminated?

  Yes. Terminating a one-click fix task does not automatically roll back any changes. To restore a filtered table to the synchronization object, see Restore an instance whose one-click fix task is terminated.