OceanBase Migration Service (OMS) Community Edition allows you to view and update the configurations of a specified JDBCWriter. When you update the configurations, the current configurations of the JDBCWriter are displayed by default. You can view and modify the configurations of the JDBCWriter.
Application scenarios
You can update the JDBCWriter configurations in the following scenarios:
A data migration project fails due to incorrect configuration information.
A data migration project needs to be optimized.
Limits
OMS Community Edition allows you to update the configurations of only a stopped or abnormal JDBCWriter.
After you update the configurations of a JDBCWriter, the system restarts the JDBCWriter to apply the updates. Proceed with caution.
When a data migration project fails, check the configurations of the project first, such as the basic information and user privileges of the source and destination databases.
Procedure
Log on to the OMS Community Edition console.
In the left-side navigation pane, choose OPS & Monitoring > Component.
On the Component page, click the JDBCWriter tab.
On the JDBCWriter tab, search for the JDBCWriter that you want to pause by its name or server IP address. You can also perform a fuzzy search by migration project name or ID.
For single-region deployment, the region information is displayed on the right of JDBCWriter.
For multi-region deployment, you can filter JDBCWriters by region and update JDBCWriters in the target region.
Click Update on the right of the target JDBCWriter.
In the Update Configuration dialog box, add a parameter or update the configurations. For more information, see JDBCWriter parameters.
To add a JDBCWriter parameter, perform the following operations:
In the Update Configuration dialog box, hover the pointer over the blank area next to the
rootparameter and click the Add icon.Specify the Key Name field and click the check mark.
In the Update Configuration dialog box, find the new key. The default value of a new key is NULL.
Hover the pointer over the new parameter and click the Edit icon that appears. Modify the parameter value and click the check mark.
To update the configurations of a JDBCWriter, perform the following operations:
In the Update Configuration dialog box, hover the pointer over the parameter to be modified and click the Edit icon that appears.
Modify the value in the text box and then click the check mark.
Click the green check mark to update the value, or the red cross mark to cancel the modification.
In the Update Configuration dialog box, click Update.