Data Transmission Service:Modify the parameters of a DTS instance

Prerequisites

Usage notes

• You can modify instance parameters for a module only if the module is running. To view the status of modules in a DTS instance, perform the following steps: Go to the details page of the DTS instance. In the left-side navigation pane, click Task Management. Then, view the status of modules in the Progress section.
• To ensure the stability of a DTS instance, DTS allows you to modify only the parameters that are displayed on the Modifiable Parameters tab in the console. Parameters that are not displayed in the console cannot be modified.
• You can refer to the Valid Values, Parameter Type, and Description columns on the Modifiable Parameters tab to modify instance parameters.
• If the Force Restart column is set to Yes for a parameter in a module on the Modifiable Parameters tab, DTS immediately restarts the module after you submit the parameter modification. Therefore, we recommend that you modify instance parameters during off-peak hours.

Specify an instance

The following section describes how to modify the parameters of a DTS instance for data synchronization. The steps for modifying the parameters of a DTS instance for data migration are similar.

1. Go to the Data Synchronization Tasks page.
   1. Log on to the Data Management (DMS) console.
   2. In the top navigation bar, click DTS.
   3. In the left-side navigation pane, choose DTS (DTS) > Data Synchronization.
   Note

   • Operations may vary based on the mode and layout of the DMS console. For more information, see Simple mode and Configure the DMS console based on your business requirements.
   • You can also go to the Data Synchronization Tasks page of the new DTS console.
2. From the drop-down list to the right of Data Synchronization Tasks, select the region in which the data synchronization instance resides.
   Note If you use the new DTS console, you must select the region in which the data synchronization instance resides in the top navigation bar.
3. Find the instance whose parameters you want to modify and click the instance ID.

Modify instance parameters

1. Find the instance whose parameters you want to modify and click the instance ID. For more information, see Specify an instance.
2. Go to the page for modifying instance parameters.

   You can go to the page for modifying instance parameters by using one of the following methods based on your business requirements:

   • Use the Parameter Settings menu in the left-side navigation pane.

     In the left-side navigation pane, click Parameters Settings.

   • Use the Task Management menu in the left-side navigation pane.
     1. In the left-side navigation pane, click Task Management.
     2. In the Progress section, click the incremental or full data synchronization module to which the parameter that you want to modify belongs.
        Note You cannot modify parameters in the schema migration module.
     3. In the lower part of the module, click Parameter Settings.
3. Modify instance parameters.
   1. Optional:Click the Modifiable Parameters tab.
   2. Click the icon in the Parameter Value column for the parameter that you want to modify.
   3. In the Modify Parameters dialog box, change the value of the parameter.
      Note DTS supports different types of DTS instances, a variety of source and destination database instances, and different configurations that you can specify for the Task Stages parameter. Therefore, the modifiable parameters that are displayed in the console vary. The following table describes the common parameters.

      Table 1. Description of common parameters

      Parameter	Module	Description
      sink.ignore.failed.ddl	Incremental data synchronization Incremental data migration	Specifies whether to ignore the DDL operations that fail to be migrated or synchronized. Valid values: true: If the DDL operations fail to be migrated or synchronized, the data migration or synchronization task ignores the failed DDL operations and proceeds. This is the default value. false: If the DDL operations fail to be migrated or synchronized, the data migration or synchronization task fails.
      sink.batch.enable	Incremental data synchronization Incremental data migration	Specifies whether to enable batch commit. Valid values: true: enables batch commit. false: does not enable batch commit. This is the default value.
      source.filter.ddl.enable	Incremental data synchronization Incremental data migration	Specifies whether to exclude DDL operations during incremental data migration or synchronization. Valid values: true: excludes DDL operations during incremental data migration or synchronization. false: does not exclude DDL operations during incremental data migration or synchronization. This is the default value.
      trans.hot.merge.enable	Incremental data synchronization Incremental data migration	Specifies whether to enable hot data merging. Valid values: true: enables hot data merging. false: does not enable hot data merging. This is the default value.
      sink.bulk.copy.enable	Full data synchronization Full data migration	Specifies whether to enable the bulk copy mode for MySQL and PostgreSQL databases. Valid values: true: enables the bulk copy mode. This is the default value. false: disables the bulk copy mode. Note This parameter must be used together with the sink.worker.type parameter.
      sink.worker.type	Full data synchronization Full data migration	Specifies the mode of writing data to MySQL and PostgreSQL databases. Valid values: stream: writes data in bulk copy mode. This is the default value. batch: writes data in PreparedStatement executeBatch mode. In this case, the sink.bulk.copy.enable parameter must be set to false. Note This parameter must be used together with the sink.bulk.copy.enable parameter.
      sink.batch.size.minimum	Full data synchronization Full data migration	The number of records that are written to the destination database at a time. Valid values: [0,1024]. Default value: 128.

   4. Click OK.
   5. Optional:Modify other parameters based on your business requirements.
      Note To undo all modifications that you have not submitted, click Revoke, and then click OK in the message that appears.
4. Click Apply Changes.
5. In the message that appears, click OK.
   Note By default, Take Effect Immediately is selected. This indicates that the parameter modifications take effect immediately.

Query parameter modification records

1. Find the instance whose parameter modification records you want to query and click the instance ID. For more information, see Specify an instance.
2. In the left-side navigation pane, click Parameters Settings.
3. On the page that appears, click the Modification History tab.
4. Specify the time range within which you want to query parameter modification records.
   Note

   • By default, the parameter modification records within the last seven days are queried and displayed.
   • Specify the start time on the left side and the end time on the right side.
5. Click OK.
   Note Only the parameter modifications that you have submitted are recorded.