Step 2: Query the Synchronization Progress

This section describes how to check the synchronization progress.

Prerequisites

You have logged in to the DRS console.

Procedure

  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 Synchronization Progress to view table synchronization progress.

    • When a full synchronization is complete, the progress reaches 100%.
    • After the full synchronization is complete, the incremental synchronization starts. You can view the incremental synchronization delay on the Synchronization Progress tab.
    • You can also view the incremental synchronization delay on the Data Synchronization Management page. When the incremental synchronization delay exceeds the preset or default threshold, the value of the incremental synchronization delay is displayed in red in the task list.
    • When the delay is 0s, the data in the source and destination databases is synchronized in real time.

    "Delay" refers to the delay from when the transaction was submitted to the source database to when it is synchronized to the destination database and executed.

    Transactions are synchronized as follows:

    1. Data is extracted from the source database.
    2. The data is transmitted over the network.
    3. DRS parses the source logs.
    4. The transaction is executed on the destination database.

    If the delay is 0, the source database is consistent with the destination database, and no new transactions need to be synchronized.

    Frequent DDL operations, ultra-large transactions, and network problems may result in excessive synchronization delay.