All Products
Search
Document Center

ApsaraDB for OceanBase:View and modify the parameter configurations of a data synchronization project

Last Updated:Jul 03, 2024

This topic describes how to view and modify the parameter configurations of a data synchronization project.

View parameter configurations

You can view the parameter configurations of a data synchronization project in the Configuration changing, Running, Modifying, Integrating, Completed, Stopping, or Stopped state.

  1. Log on to the ApsaraDB for OceanBase console.

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

  3. On the Synchronization Projects page, choose More > Settings next to the project that you want to manage.

    image

    You can also click the name of the project to go to its details page and then choose More > Settings in the upper-right corner.

    image

  4. On the Settings page, view the parameter configurations of the current project.

Modify parameter configurations

You can modify the parameter configurations of a data synchronization project in the Not Started, Paused, or Failed state.

  1. Log on to the ApsaraDB for OceanBase console.

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

  3. On the Synchronization Projects page, choose More > Modify Parameter Configurations next to the project that you want to manage.

    image

    You can also click the name of the project to go to its details page and then choose More > Modify Parameter Configurations in the upper-right corner.

    image

  4. In the Modify Parameter Configurations panel, modify the parameter configurations as needed.

    • Full synchronization

      The following table describes the parameters for full synchronization, which are displayed only if you have selected Full Synchronization on the Select Synchronization Type page.

      image

      Parameter

      Description

      Read Concurrency Configuration

      The concurrency for reading data from the source during full synchronization. The maximum value is 512. A high concurrency may incur excessive stress on the source, thereby affecting the business.

      Write Concurrency Configuration

      The concurrency for writing data to the destination during full synchronization. The maximum value is 512. A high write concurrency may incur excessive stress on the destination, affecting the business.

      Full Synchronization Rate Limit

      You can choose whether to limit the full synchronization rate as needed. If you choose to limit the full synchronization rate, you must specify the records per second (RPS) and bytes per second (BPS). The RPS specifies the maximum number of data rows synchronized to the destination per second during full synchronization, and the BPS specifies the maximum amount of data in bytes synchronized to the destination per second during full synchronization.

      Note

      The RPS and BPS values specified here are only for throttling. The actual full synchronization performance is subject to factors such as the settings of the source and destination and the instance specifications.

    • Incremental synchronization

      The following table describes the parameters for incremental synchronization, which are displayed only if you have selected Incremental Synchronization on the Select Synchronization Type page.

      image

      Parameter

      Description

      Write Concurrency Configuration

      The concurrency for writing data to the destination during incremental synchronization. The maximum value is 512. A high write concurrency may incur excessive stress on the destination, affecting the business.

      Incremental Synchronization Rate Limit

      You can choose whether to limit the incremental synchronization rate as needed. If you choose to limit the incremental synchronization rate, you must specify the RPS and BPS. The RPS specifies the maximum number of data rows synchronized to the destination per second during incremental synchronization, and the BPS specifies the maximum amount of data in bytes synchronized to the destination per second during incremental synchronization.

      Note

      The RPS and BPS values specified here are only for throttling. The actual incremental synchronization performance is subject to factors such as the settings of the source and destination and the instance specifications.

      Incremental synchronization

      Options for Incremental Synchronization are DML Synchronization and DDL Synchronization. You can select operations as needed. For more information, see Configure DDL/DML synchronization.

  5. Click OK.