All Products
Search
Document Center

ApsaraDB for OceanBase:View the details of a data synchronization project

Last Updated:Mar 19, 2024

After a data synchronization project is started, you can view the basic information, synchronization details, and synchronization objects on the details page of the project.

Access the details page

  1. Log on to the ApsaraDB for OceanBase console.

  2. In the left-side navigation pane, choose Data Transmission > Data Synchronization.

  3. Click the name of the target data synchronization project to go to its details page. On the details page, view the basic information and synchronization details of the project.

    image.png

    On the Data Synchronization page, you can search for data synchronization projects by tag, status, type, and keyword. A data synchronization project can be in one of the following states:

    • Not Configured: The data synchronization project has not been configured. You can click Configure in the Actions column to configure the project.

    • Not Started: The data synchronization project has not been started. You can click Start in the Actions column to start the project.

    • Running: The data synchronization project is in progress. You can view the data synchronization plan and current progress on the right and perform corresponding operations in the Actions column.

    • Modifying: The synchronization objects of the data synchronization project are being modified.

    • Integrating: The data synchronization project is being integrated with the corresponding synchronization object modification task.

    • Paused: The data synchronization project is manually paused. You can click Resume in the Actions column to resume the project.

    • Failed: The data synchronization project failed. You can locate the stage where the failure occurred on the right. To view the error message, click the project name to go to the project details page.

    • Completed: The data synchronization project is completed and the data transmission service has synchronized the specified data to the destination database in the configured synchronization mode.

    • Stopping: The data synchronization project is being stopped. You cannot edit a data synchronization project in this state.

    • Stopped: The data synchronization project is stopped.

    You can change the name of a project in the Not Started, Running, Paused, or Failed state. For more information, see Change the name of a data synchronization project.

View basic information

The Basic Information section displays the basic information of the current data synchronization project.

image.png

Parameter

Description

ID

The unique ID of the data synchronization project.

Synchronization Type

The synchronization type specified when the data synchronization project was configured.

Alert Status

The alert status of the data synchronization project. You can click the Edit icon to modify the alert status. For more information, see Modify the alert monitoring settings.

Created At

The time when the data synchronization project was created.

Connection Details

Click Connection Details to view the information about the source and destination databases of the data synchronization project. You can also copy the data source identifiers.

Billing Method

The billing method specified when the data synchronization project was purchased. For more information, see Billing for data transmission.

Instance Specification

The instance specifications specified when the data synchronization project was purchased. For more information, see Data transmission specifications.

You can perform the following operations:

  • View and modify synchronization objects

    Click View Objects in the upper-right corner. The synchronization objects of the current data synchronization project are displayed. You can modify the synchronization objects during the running of a synchronization project. For more information, see View and modify synchronization objects.

  • View parameters

    Click ... in the upper-right corner of the page and select Settings from the drop-down list. On the page that appears, you can view the parameters configured when the data synchronization project was created.

  • Download object settings

    On the details page of the project, click the More icon in the upper-right corner, and then click Download Project Configuration to download the configurations of the data synchronization project and import project settings in batches. For more information, see Download and import the settings of synchronization objects.

View synchronization details

In the Synchronization Details section, you can view information about Schema Synchronization, Full Synchronization, and Incremental Synchronization. Schema synchronization creates a topic. After the schema synchronization is completed, you can query the new topic.

The Incremental Synchronization section displays the status, latency, and current timestamp of the data synchronization project. Based on this information, you can monitor the performance of the data synchronization project.

image.png

When you create a data synchronization project, we recommend that you enable alert monitoring to monitor the project status in real time. For more information, see Configure alerts. If alert monitoring is disabled, when the incremental synchronization latency is less than or equal to 10 minutes, the incremental synchronization status changes from Running to Monitoring by default. Take note of the following items if alert monitoring is enabled:

  • When the incremental synchronization latency exceeds the specified alert threshold, the incremental synchronization project remains Running and the system does not trigger any alerts.

  • When the incremental synchronization latency is less than or equal to the specified alert threshold, the incremental synchronization status changes from Running to Monitoring. After the incremental synchronization status changes to Monitoring, it will not change back to Running when the latency exceeds the specified alert threshold.

The Incremental Synchronization Performance section displays the performance information of incremental data synchronization in real time. You can view the changes in synchronization performance in real time or by period, for example, by selecting Last 1 Hour, Last 1 Day, Last 7 Days, or a specified period of time.

image.png

Parameter

Description

Latency

The latency in synchronizing incremental data from the source database to the destination database, in seconds.

Synchronization Traffic

The traffic throughput of incremental data synchronization from the source database to the destination database, in Kbit/s.

Average Write Duration

The average duration of synchronizing data from an OceanBase database to a DataHub or Kafka instance.

Average Execution Time/Average Commit Time

Important

The average execution time and average commit time are measured only when data is synchronized from a MySQL tenant of OceanBase Database to an AnalyticDB MySQL database, or from one OceanBase database to another.

  • Average execution time: the average execution time of an SQL statement, in ms.

  • Average commit time: the average commit time of a transaction, in ms.

RPS

The number of records processed per second.