Updated on 2024-03-28 GMT+08:00

Pausing a Synchronization Task

DRS allows you to pause real-time synchronization tasks. For details about the synchronization scenarios where synchronization tasks can be paused, see Real-time Synchronization Scenarios Where Synchronization Tasks Can Be Paused.

Prerequisites

  • You have logged in to the DRS console.

Pausing a Task

  1. In the task list on the Data Synchronization Management page, locate the target task and click Pause in the Operation column.
  2. In the displayed Pause Task dialog box, select Pause log capturing and click Yes.

    • After the task is paused, the status of the task becomes Paused.
    • After you select Pause log capturing, the DRS instance will no longer communicate with the source and destination databases. If the pause duration is too long, the task may fail to be resumed because the logs required by the source database expire. You are not advised pausing a task for more than 24 hours. For details, check the corresponding log configuration.

Pausing Tasks

  1. On the Data Synchronization Management page, select the tasks to be paused.
  2. Click Batch Operations in the upper left corner and choose Pause.

    Figure 1 Batch Operations

  3. In the displayed dialog box, confirm the task information and click Yes.

Real-time Synchronization Scenarios Where Synchronization Tasks Can Be Paused

The following tasks can be paused during incremental synchronization:

  • To the cloud
    • MySQL->MySQL
    • MySQL->GaussDB(for MySQL)
    • MySQL -> GaussDB primary/standby
    • MySQL -> GaussDB Distributed
    • MySQL->GaussDB(DWS)
    • MySQL->PostgreSQL
    • MySQL->MariaDB
    • PostgreSQL->PostgreSQL
    • PostgreSQL->GaussDB(DWS)
    • PostgreSQL -> GaussDB Primary/Standby
    • PostgreSQL -> GaussDB Distributed
    • DDM->DDM
    • DDM->GaussDB(DWS)
    • Oracle->GaussDB(DWS)
    • Oracle->PostgreSQL
    • Oracle->GaussDB(for MySQL)
    • Oracle -> GaussDB primary/standby
    • Oracle -> GaussDB distributed
    • Oracle->MySQL
    • 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
    • MongoDB->DDS
    • MariaDB->MariaDB
    • MariaDB->MySQL
    • MariaDB->GaussDB(for MySQL)
    • GaussDB(for MySQL)->GaussDB(for MySQL)
  • From the cloud
    • MySQL->MySQL
    • MySQL->CSS/ES
    • MySQL->Oracle
    • MySQL->Kafka
    • MySQL->MariaDB
    • DDM->Oracle
    • DDM->Kafka
    • DDS->MongoDB
    • DDS->Kafka
    • GaussDB(for MySQL)->MySQL
    • GaussDB(for MySQL)->Kafka
    • GaussDB(for MySQL)->CSS/ES
    • GaussDB(for MySQL)->Oracle
    • GaussDB(for MySQL)->GaussDB(DWS)
    • GaussDB primary/standby -> MySQL
    • GaussDB primary/standby -> Oracle
    • GaussDB primary/standby -> Kafka
    • 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

In addition, the following tasks can be paused during full synchronization:

  • MySQL->MySQL
  • MySQL->GaussDB(for MySQL)
  • MySQL->GaussDB(DWS)
  • MySQL->CSS/ES
  • MySQL->Kafka
  • GaussDB(for MySQL)->MySQL
  • GaussDB(for MySQL)->GaussDB(for MySQL)
  • GaussDB(for MySQL)->Kafka
  • GaussDB(for MySQL)->GaussDB(DWS)
  • Oracle->MySQL
  • DDM->MySQL
  • DDM->Oracle
  • DDM->GaussDB(DWS)
  • PostgreSQL->PostgreSQL
  • PostgreSQL->GaussDB(DWS)
  • MongoDB->DDS
  • DDS->MongoDB