All Products
Search
Document Center

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

Last Updated:Nov 29, 2024

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

View parameter configurations

You can view the parameter configurations of a data synchronization task 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 Tasks page, click the More icon next to the target task and select Settings.

    image

    You can also click the name of the task to go to its details page. Then, click the More icon in the upper-right corner and select Settings.

    image

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

Modify parameter configurations

You can modify the parameter configurations of a data synchronization task 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 Tasks page, click the More icon next to the target task and select Modify Parameter Configurations.

    image

    You can also click the name of the task to go to its details page. Then, click the More icon in the upper-right corner and select Modify Parameter Configurations.

    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 incremental synchronization parameters, which are displayed only when 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.