All Products
Search
Document Center

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

Last Updated:Jul 03, 2024

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

View parameter configurations

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

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

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

      Incremental Synchronization Rate Limit

      You can choose whether to limit the incremental synchronization 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.