All Products
Search
Document Center

ApsaraDB for OceanBase:View details of a data synchronization project

Last Updated:Mar 27, 2023

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 data synchronization project whose details you want to view to go to the details page.

    On the Data Synchronization page, you can search for data synchronization projects by tag, status, type, and keyword. The state of a data synchronization project can be:

    • 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.

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

    • Integrating: The data synchronization project is being integrated with the 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 has failed. You can view where the failure occurred on the right. To view the error messages, click the project name to go to the project details page.

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

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

    • Released: The data synchronization project is released. After a data synchronization project is released, the data transmission feature terminates the project.

    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.

Parameter

Description

ID

The unique ID of the data synchronization project.

Migration Instance

The migration instance selected when this project was created.

Alert Status

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

Synchronization Type

The synchronization type of the data synchronization project.

Created At

The time when the data synchronization project was created.

Synchronization Start Timestamp

The synchronization start timestamp specified 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 identifier.

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.

  • Clone a data synchronization project

    To clone the current synchronization project, click the More icon in the upper-right corner and choose Clone from the drop-down list. During the cloning process, you can modify the project settings as needed.

  • View parameters

    Click the More icon in the upper-right corner and choose Settings from the drop-down list. On the page that appears, you can view the configuration parameters specified when the data synchronization project was created.

  • Download object settings

    The data transmission feature allows you to download the configurations of data synchronization projects 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. When you create a data synchronization project, we recommend that you enable alert monitoring to learn the project status in real time. For more information, see Configure alert monitoring. 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. 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.

Parameter

Description

Synchronization 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.