You must configure data sources before you create a data migration project. Before you start a data migration project, you must create an OceanBase database as the data source for the source or destination. This topic describes how to create a public cloud OceanBase data source in OceanBase Migration Service (OMS).
Prerequisites
You have obtained the IP address and port number of the related database.
You have created a database user for data migration.
We recommend that you create a dedicated database user for the data migration project and grant the required data operation privileges to the user. For more information, see Create a database user.
Procedure
Log on to the OMS console.
In the left-side navigation pane, click Data Source Management.
On the Data Source Management page, click New Data Source in the upper-right corner.
In the New Data Source dialog box, select OceanBase for Data Source Type.
Select Public Cloud Data Source, configure the parameters.
Parameter Description Data Source Identifier We recommend that you set it to a combination of digits and letters. It must not contain any spaces and cannot exceed 32 characters in length.
Notice
The data source identifier must be globally unique in OMS.Region Select the region where the data source resides from the drop-down list.
Notice- This parameter is displayed only when multiple regions are available.
- Make sure that the mappings between the data source and the region are consistent. Otherwise, the migration and synchronization performance can be poor.
Tenant Type The type of the OceanBase Database tenant. Valid values: Oracle and MySQL. Input Mode Valid values: Manual Input and Command-line Connection String. - Manual Input: Enter the IP address and port number of the OceanBase database.
- Command-line Connection String: Enter a command-line connection string.
Command-line Connection String This parameter is displayed only if you have selected Command-line Connection String for Input Mode. You can enter a one-segment or three-segment string. After you enter the string, the Service Address and Port parameters are automatically populated. Here are two examples: - A one-segment string
mysql -ht5zxxxx.oceanbase.aliyuncs.com -utest -P3306 -c -A -p - A three-segment string
obclient -hxxx.xxx.xxx.xxx -P2891 -uuser@tenant#cluster -p
Service Address The service address of the OceanBase database. Port The port number of the host where the database is located. Database Username The username of the OceanBase database user for data migration or synchronization. We recommend that you create a dedicated database user for data migration or synchronization. Database Password The password of the database user. Remarks (Optional) Additional information about the data source. (Optional) In the New Data Source dialog box, click Show next to Advanced Options to set the parameters as needed.
Incremental Synchronization Mode
If the public cloud OceanBase data source is the source and incremental synchronization is required, or the data source is the destination and reverse incremental migration is required, you need to enable Incremental Synchronization Mode and specify parameters described in the following table to read the incremental logs of the OceanBase data source.
Parameter Description Incremental Synchronization Mode - If you use a MySQL tenant of OceanBase Database, valid values are OBLogProxy and OceanBase BinlogService. If you select OceanBase BinlogService, you need to enable OceanBase Binlog. For more information, see Overview.
- If you use an Oracle tenant of OceanBase Database, the valid value is OBLogProxy.
OBLogProxy Address The settings of OBLogProxy. OBLogProxy is a proxy service for managing incremental logs of OceanBase Database. It provides project intervention and management capabilities as services to allow applications to access and manage real-time incremental logs of OceanBase Database. It also addresses the need for incremental log subscriptions in network isolation mode. Port Schema Migration Configuration
If the public cloud OceanBase data source is the source and schema migration is required, you need to specify parameters described in the following table to read the schema information of objects in the OceanBase data source.
Parameter Description OceanBase Cluster Version The version of the OceanBase cluster. Valid values: Before V4.2.0 and V4.2.0 and Later. sys Tenant Username (Optional) The name of a user in the sys tenant and its password. These two parameters are displayed only if you have selected Before V4.2.0 for OceanBase Cluster Version. Password __OCEANBASE_INNER_DRC_USER Password (Optional)
This user is used to migrate tables without unique keys in OceanBase Database. Note that you must create this user under the tenant where the current data source is located.
Click Test Connection to test the network connection between OMS and the data source, and the validity of the username and password.
After the test is passed, click OK.