A data source must be configured before you create a data migration project. To migrate data from a DataBase Proxy (DBP) data source, you must create it as the source data source. This topic describes how to create a DBP data source in OceanBase Migration Service (OMS).
Background
DBP is a financial-grade distributed database middleware that is developed by Ant Financial Technology. It resolves the data access bottleneck and database disaster recovery problems under massive requests and provides distributed database services featuring horizontal splitting, smooth scaling, and read/write splitting.
DBP is compatible with the MySQL protocols and syntax. DBP supports features such as database and table sharding, smooth scaling, service upgrading and downgrading, transparent read/write splitting, and distributed transactions. It also provides lifecycle management for distributed databases.
After you create a DBP data source in OMS, you can manage all MySQL logical tables in the DBP data source. To create a project for synchronizing MySQL logical tables to physical tables in an OceanBase database in MySQL tenant mode, you need only to create a DBP data source.
Procedure
Log on to the OMS console.
In the left-side navigation pane, click Data Source Management .
On the Data Sources page, click New Data Source in the upper-right corner.
In the New Data Source panel, select OceanBase for Data Source Type .
Select Logical Data Sources and select DBP from the drop-down list.
Set the following parameters.
Parameter Description Data Source Identifier The name of the data source. The name must be 1 to 32 characters in length and can contain Chinese characters, digits, and case-sensitive letters. Connection Mode The access method. Default value: OP Gateway . Open Platform (OP) is an open platform developed by Ant Financial Technology. URL The URL of the OP gateway, or the URL of the OP gateway JSON file that can be obtained in the stand-alone deployment mode of DBP. Route The routing API, such as MiddleWareCluster-ODP. Access Key The access key of the visitor. Security Key The security key of the visitor. Instance ID The ID of the set of a middleware tenant and the related execution spaces. This ID is also used as the user identifier. DBP Instance ID The ID of the physical DBP instance. obproxy URL Optional. DBP logical tables support the address of a centralized cluster of OBProxies in the IP:Port format. Username The username used to access the physical tables under the logical tables to be synchronized. This parameter is checked during the precheck of a full synchronization task but not during the connection test. Password The password used to access the physical tables under the logical tables to be synchronized. This parameter is checked during the precheck of a full synchronization task but not during the connection test. Remarks Optional. Additional information about the data source. Click Test Connection to test the network connection between OMS and the source, and the validity of the username and password.
After the connection test succeeds, click OK.