View and modify migration parameters

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

View parameter configurations

You can view the parameter configurations of a data migration task in the Running, Modifying, Integrating, Completed, Ending, or Ended state.

1. Log in to the OMS console.

2. In the left-side navigation pane, click Data Migration.

3. On the Migration Tasks page, click the ... next to the target task and then select Settings.

   

   You can also click the name of the target task to go to the details page, and then click the ... in the upper-right corner and select Settings.

   

4. In the Settings panel, view the parameter configurations of the current task.

Modify parameter configurations

You can modify parameter configurations for data migration tasks in the Not Started, Running, Stopped, or Failed state.

1. Log in to the OMS console.

2. In the left-side navigation pane, click Data Migration.

3. On the Migration Tasks page, click ... > Modify Parameters in the actions column of the target task.

   

   You can also click the name of the target task to go to the details page, and then click ... > Modify Parameters in the upper-right corner.

   

4. In the Modify Parameters panel, modify the parameters as needed.

   • Schema migration

     The following parameters are displayed only if you have selected One-way Synchronization > Schema Migration in the Select Migration Type step.

     Parameter	Description
     Automatically Enter Next Stage upon Completion	If you select schema migration and any other migration type, you can specify whether to automatically proceed to the next stage after schema migration is completed. The default value is Yes. You can also view and modify this value on the Schema Migration tab of the data migration task details page.
     Normal Index Migration Method	The migration mode for non-unique key indexes associated with a migrated table object. Valid values: Do Not Migrate, Migrate with Schema, and Post-Full-Migration. The Post Full Migration value is displayed only if full migration is selected.
     Trigger Migration Method	The migration mode for triggers associated with a migrated table object. Valid values: Do Not Migrate, Migrate with Schema, and Forward Switchover Migration. Notice You can modify this parameter only when you are migrating data from an Oracle database to an Oracle compatible mode of OceanBase Database. If you select only Schema Migration, the default value is Not Supported and you cannot select Forward Handover Migration. If you select other migration types in addition to Schema Migration, you cannot select With Schema.

   • Full migration

     The following parameters are displayed only if you have selected Full Migration in the Select Migration Type step.

     

     Parameter	Description
     Full Migration Rate Limit	You can choose whether to limit the full migration rate as needed. If you choose to limit it, you need to set the maximum number of rows that can be migrated to the target database per second (RPS) and the maximum amount of data that can be migrated to the target database per second (BPS). Note The RPS and BPS values entered here are only for throttling. The actual full migration performance is affected by factors such as the source and target databases and instance specifications.
     Full Migration Resource Configuration	You can select Small, Medium, or Large to use the corresponding default values of concurrency for reads, concurrency for writes, and memory. You can also customize the resource configurations for full migration. The resource configuration limits the resource consumption of the full migration phase of the task. It is provided by the full migration component Full-Import. Notice When you customize the configuration, the minimum value is 1 and only integers are supported.
     Handle Non-empty Tables in Target Database	Valid values: Ignore and Stop Migration: If you select Ignore, OMS will log the conflicting data and retain the original data when there is a conflict between the original data and the data to be written to the target database. Notice If you select Ignore, the full verification will use the IN mode to pull data, which cannot verify whether the target database contains data that does not exist in the source database. The verification performance will also be slightly degraded. If you select Stop Migration, OMS will report an error and stop migration when there is data in the target table. You must clear the data in the target table before you continue the migration. Notice If you click Resume, OMS will ignore this setting and continue to migrate table data. Proceed with caution.

   • Incremental synchronization

     The following parameters are displayed only if you have selected Incremental Synchronization in the Select Migration Type step.

     

     Parameter	Description
     Incremental Synchronization Rate Limit	You can choose whether to limit the incremental synchronization rate. If you choose to limit it, you need to set the maximum number of rows that can be synchronized to the target database per second (RPS) and the maximum amount of data that can be synchronized to the target database per second (BPS). Note The RPS and BPS values entered here are only for throttling. The actual incremental synchronization performance is affected by factors such as the source and target databases and instance specifications.
     Incremental Log Pull Resource Configuration	You can select Small, Medium, or Large to use the corresponding default value of Memory. You can also customize the resource configurations for incremental log pull. By setting the resource configuration for the Store component, you can limit the resource consumption of a task in log pull in the incremental synchronization stage. Notice When you customize the configuration, the minimum value is 1 and only integers are supported.
     Incremental Data Write Resource Configuration	You can select Small, Medium, or Large to use the corresponding default values of Write Concurrency and Memory. You can also customize the resource configurations for incremental data write. By setting the resource configuration for the Incr-Sync component, you can limit the resource consumption of a task in data writes in the incremental synchronization stage. Notice In the case of custom configurations, the minimum value is 1, and only integers are supported.
     Incremental Record Retention Duration	The duration that incremental parsed files are cached in OMS. A longer retention duration results in more disk space occupied by the Store component.
     Incremental Synchronization Start Timestamp	If you have selected Full Migration as the migration type, this parameter is not displayed. If you have selected Incremental Synchronization but not Full Migration, specify a point in time after which the data is to be synchronized. The default value is the current system time. For more information, see Set an incremental synchronization timestamp. If you have configured Obtain Incremental Data through Kafka for the Oracle data source, you can modify the Incremental Synchronization Start Timestamp parameter before the incremental synchronization starts (not including full migration).
     Incremental Synchronization	Incremental Synchronization includes DML synchronization and DDL synchronization. You can click Customize DDL/DML to configure DDL and DML synchronization as needed. For more information, see Customize DDL/DML synchronization.
     Adapt to Online DDL Tool	If you enable this feature, the database uses an online DDL tool to perform online schema changes, and data migration filters out temporary table objects to improve the stability of the data migration task. For more information, see Online DDL tools. Note Currently, this feature is supported only in scenarios where the source database is a MySQL database and Alibaba Cloud DMS, gh-ost, or pt-osc is used to perform online schema changes.

   • Reverse incremental migration

     The following parameters are displayed only if you have selected Reverse Increment in the Select Migration Type step. The parameter settings for reverse incremental migration are the same as those for incremental synchronization by default.

     

   • Full verification

     The following parameters are displayed only if you have selected Full Verification in the Select Migration Type step.

     

     Parameter

     Description

     Full Verification Resource Configuration

     You can select Small, Medium, or Large to use the corresponding default values of concurrency for reads and memory. You can also customize the full verification resource configuration. The resource configuration limits the resource consumption of full verification. It is provided by the full verification component Full-Verification. Notice When you customize the configuration, the minimum value is 1 and only integers are supported.

5. Click OK.