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
- In the task list on the Data Synchronization Management page, locate the target task and click Reset in the Operation column.
- 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.
- After the check is complete and the check success rate is 100%, click Start to submit the synchronization task again.
Method 2
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
Parent topic: Task Life Cycle
- Prerequisites
- Method 1
- Method 2
- Real-time Synchronization Scenarios Where Synchronization Tasks Can Be Reset