Help Center/ Data Replication Service/ Real-Time Synchronization/ Task Management/ Task Life Cycle/ Resetting a Synchronization Task
Updated on 2024-12-01 GMT+08:00
View PDF
Share

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.

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.

    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(for MySQL)
  • MySQL -> GaussDB primary/standby
  • MySQL -> GaussDB Distributed
  • MySQL->GaussDB(DWS)
  • MySQL->MariaDB
  • PostgreSQL->PostgreSQL
  • PostgreSQL->GaussDB(DWS)
  • PostgreSQL -> GaussDB Primary/Standby
  • PostgreSQL -> GaussDB Distributed
  • DDM->MySQL
  • DDM->DDM
  • DDM->GaussDB(DWS)
  • Oracle->MySQL
  • Oracle->GaussDB(for MySQL)
  • Oracle->GaussDB(DWS)
  • Oracle->PostgreSQL
  • Oracle -> GaussDB primary/standby
  • Oracle -> GaussDB distributed
  • Oracle->DDM
  • DB2 for LUW -> GaussDB primary/standby
  • DB2 for LUW -> GaussDB distributed
  • DB2 for LUW->GaussDB(DWS)
  • TiDB->GaussDB(for MySQL)
  • Microsoft SQL Server->GaussDB(DWS)
  • Microsoft SQL Server -> GaussDB primary/standby
  • Microsoft SQL Server -> GaussDB Distributed
  • Microsoft SQL Server->Microsoft SQL Server
  • Microsoft SQL Server->PostgreSQL
  • MongoDB->DDS
  • MariaDB->MariaDB
  • MariaDB->MySQL
  • MariaDB->GaussDB(for MySQL)
  • GaussDB(for MySQL)->GaussDB(for MySQL)
  • Cassandra->GeminiDB Cassandra
  • Dynamo->GeminiDB Dynamo
From the cloud
  • MySQL->MySQL
  • MySQL->CSS/ES
  • MySQL->Oracle
  • MySQL->Kafka
  • MySQL->MariaDB
  • DDS->MongoDB
  • DDS->Kafka
  • DDM->MySQL
  • DDM->Oracle
  • DDM->Kafka
  • GaussDB(for MySQL)->Kafka
  • GaussDB(for MySQL)->CSS/ES
  • GaussDB(for MySQL)->Oracle
  • GaussDB(for MySQL)->MySQL
  • GaussDB(for MySQL)->GaussDB(DWS)
  • GaussDB primary/standby -> GaussDB primary/standby
  • GaussDB primary/standby -> GaussDB distributed
  • GaussDB primary/standby -> GaussDB(DWS)
  • GaussDB primary/standby -> MySQL
  • GaussDB primary/standby -> Oracle
  • GaussDB primary/standby -> Kafka
  • GaussDB distributed -> GaussDB distributed
  • GaussDB distributed -> GaussDB primary/standby
  • GaussDB distributed -> GaussDB(DWS)
  • GaussDB distributed -> MySQL
  • GaussDB distributed -> Oracle
  • GaussDB distributed -> Kafka
  • PostgreSQL->PostgreSQL
  • PostgreSQL->Kafka
  • MariaDB->MariaDB
  • Microsoft SQL Server->Kafka
Self-built -> Self-built
  • MySQL->Kafka
  • MySQL->CSS/ES
  • MySQL -> GaussDB Primary/Standby
  • MySQL -> GaussDB Distributed
  • Oracle-> Kafka
  • Oracle -> GaussDB primary/standby
  • Oracle -> GaussDB distributed
  • GaussDB primary/standby -> Oracle
  • GaussDB primary/standby -> Kafka
  • GaussDB distributed -> Oracle
  • GaussDB distributed -> Kafka
  • PostgreSQL->Kafka
  • DB2 for LUW -> GaussDB primary/standby
  • DB2 for LUW -> GaussDB distributed
  • Microsoft SQL Server->Kafka
Parent topic: Task Life Cycle