Create a MySQL data source

You must configure data sources before you create a data migration project. Before you start a data migration task, you can add a MySQL database as the source or destination data source. This topic describes how to create a MySQL 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.

Procedure

1. Log on to the OMS console.

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

3. On the Data Source Management page, click New Data Source in the upper-right corner.

   

4. In the New Data Source dialog box, select MySQL for Data Source Type and configure the following 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. The region is the value that you set for the cm_region parameter when you deploy OMS. 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.
   Database Attributes	Database attributes include Primary Database, Primary Database + Standby Database, and Standby Database. When you configure the primary database, you can choose whether to select the following option: Allow OMS to automatically write heartbeat data into this instance during incremental synchronization. This resolves the problem of high latency when no business data is written in the source database. If you select this option, OMS creates the drc.heartbeat table in the MySQL database and updates the table to store the synchronization timestamps. This prevents OMS from displaying lengthy latency information when the source database is not processing business traffic. Notice The MySQL database user must have the privileges to create and write tables. For more information, see Create and update a heartbeat table. If you do not select this option, OMS does not create the drc.heartbeat table.
   Host IP Address	The IP address of the host where the database is located. You must specify the IP address of the physical server that hosts the Relational Database Service (RDS). Do not enter the IP address of any middleware.
   Port	The port number of the host where the database is located.
   Database Username	The name of the MySQL database user for data migration or synchronization.
   Database Password	The password of the database user.
   DB Name (Optional)	The name of the MySQL database. Note If you specify Database Name, when the created data source serves as the source data source of a data migration or synchronization project, you can select only objects in the specified database as the migration or synchronization objects.
   Remarks (Optional)	Additional information about the data source.

5. Click Test Connection to verify the network connection between OMS and the data source, as well as the validity of the username and password. You can specify a database as the source or destination.

6. After the test is passed, click OK.