All Products
Search
Document Center

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

Last Updated:Nov 29, 2024

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

View parameter configurations

You can view the parameter configurations of a data migration 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 Migration.

  3. On the Migration 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 migration 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 Migration.

  3. On the Migration 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 data migration

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

      image

      Parameter

      Description

      Read Concurrency Configuration

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

      Write Concurrency Configuration

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

      Full Data Migration Rate Limit

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

      Note

      The RPS and BPS values specified here are only for throttling. The actual full migration 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 Migration 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.

    • Reverse incremental migration

      This section is displayed only if you have selected Incremental Synchronization on the Select Migration Type page. The default parameter configurations for reverse incremental migration are consistent with those for incremental synchronization.

      image

      Parameter

      Description

      Write Concurrency Configuration

      The concurrency for writing data to the source during reverse incremental migration. The maximum value is 512. A high concurrency may incur excessive stress on the source, thereby affecting the business.

      Reverse Increment Rate Limit

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

      Note

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

      Reverse incremental migration

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

  5. Click OK.