Updated on 2024-09-25 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.

    • When a task in incremental state is paused, only the replay or capture and replay of incremental data is paused. Before database cutover, stop the task.
    • 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.
    • After the task is paused, its status becomes Paused.
    • You can use the resumable transfer function to continue the synchronization task.

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->MySQL
    • DDM->DDM
    • DDM->GaussDB(DWS)
    • Oracle->GaussDB(DWS)
    • Oracle->PostgreSQL
    • Oracle->GaussDB(for MySQL)
    • Oracle -> GaussDB primary/standby
    • Oracle -> GaussDB distributed
    • Oracle->MySQL
    • 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->MySQL
    • Microsoft SQL Server->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
    • DDM->MySQL
    • 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)
  • GaussDB(for MySQL)->CSS/ES
  • Oracle->MySQL
  • Oracle->PostgreSQL
  • Oracle->GaussDB(for MySQL)
  • Oracle->DDM
  • Oracle->GaussDB(DWS)
  • TiDB->GaussDB(for MySQL)
  • DDM->DDM
  • DDM->MySQL
  • DDM->Oracle
  • DDM->GaussDB(DWS)
  • PostgreSQL->PostgreSQL
  • PostgreSQL->GaussDB(DWS)
  • MongoDB->DDS
  • DDS->MongoDB
  • Cassandra->GeminiDB Cassandra
  • GaussDB Primary/Standby -> MySQL
  • GaussDB Primary/Standby -> Oracle
  • GaussDB Primary/Standby -> GaussDB(DWS)
  • GaussDB Primary/Standby -> GaussDB Primary/Standby
  • GaussDB Primary/Standby -> GaussDB Distributed
  • GaussDB Distributed -> MySQL
  • GaussDB Distributed -> Oracle
  • GaussDB Distributed -> GaussDB(DWS)
  • GaussDB Distributed -> GaussDB Distributed
  • GaussDB Distributed -> GaussDB Primary/Standby