nav-img
Advanced

Resetting a Synchronization Task

During real-time synchronization, you can reset the synchronization tasks in one of the following statuses so that you do not need to configure the tasks again.

  • Paused
  • Failed

For details about the synchronization scenarios where synchronization tasks can be reset, see Real-time Synchronization Scenarios Where Synchronization Tasks Can Be Reset.

Note

Resetting a task does not clear the destination database. You can determine whether to clear the destination database based on your service requirements.

  • Full and full+incremental tasks: To ensure data consistency before and after synchronization, manually clear the destination database and reset the task. After the task is reset, full synchronization is performed again. You do not need to configure the task again.
  • Incremental tasks: Only incremental data is synchronized. You can directly reset the task without clearing the destination database.
  • If the synchronization objects contain tables without primary keys, temporary tables prefixed with drs_ may exist after resetting a task during full synchronization. You need to manually delete the temporary tables.

Prerequisites

You have logged in to the DRS console.

Method 1

  1. In the task list on the Data Synchronization Management page, locate the target task and click Reset in the Operation column.
  2. In the displayed dialog box, check the synchronization task again.

    Note

    If a many-to-one synchronization task fails to be reset, click the name of the failed subtask in the failure details to view the failure cause of the task.

  3. After the check is complete and the check success rate is 100%, click Start to submit the synchronization task again.

Method 2

  1. On the Data Synchronization Management page, click the target synchronization task name in the Task Name/ID column.
  2. On the displayed page, click the Synchronization Progress tab, and click Reset in the upper right corner.
  3. Perform 2 to 3 from method 1.

Real-time Synchronization Scenarios Where Synchronization Tasks Can Be Reset

To the cloud

  • MySQL->MySQL
  • MySQL->PostgreSQL
  • MySQL->GaussDB(DWS)
  • PostgreSQL->PostgreSQL
  • PostgreSQL->GaussDB(DWS)
  • Oracle->PostgreSQL
  • Oracle -> GaussDB primary/standby
  • Oracle -> GaussDB distributed
  • MariaDB->MariaDB

From the cloud

  • MySQL->MySQL
  • MySQL->CSS/ES
  • MySQL->Kafka
  • PostgreSQL->Kafka
  • MariaDB->MariaDB

Self-built -> Self-built

  • MySQL->CSS/ES
  • Oracle -> GaussDB primary/standby
  • Oracle -> GaussDB distributed
  • PostgreSQL->Kafka