Before you create a data migration or synchronization task, you must create a data source. This topic describes how to create an OceanBase data source by using the data transmission service.
Security risks
You can choose to automatically or manually add public CIDR blocks for the data transmission service, but security risks exist. Your use of the data transmission service indicates that you have understood and acknowledged the possible security risks. You must take basic security protection measures, such as setting a complex password for your account, limiting the open port numbers of CIDR blocks, enabling authentication for communication among internal APIs, and regularly check for and limit CIDR blocks that are not required.
The data transmission service will add or delete the CIDR blocks automatically added to an allowlist or security group based on business needs and security risks. Do not use the CIDR blocks in an allowlist or security group for business needs other than the data transmission service. If you use such CIDR blocks for other business needs, the issues thus incurred are beyond the guarantee scope of the SLA of the data transmission service. For more information about how to add an IP address to an allowlist or security group for the data transmission service, see Add an allowlist.
Procedure
Log on to the ApsaraDB for OceanBase console.
In the left-side navigation pane, choose Data Transmission > Data Source Management.
On the Data Sources page, click New Data Source in the upper-right corner.
In the New Data Source dialog box, use the default value OceanBase for Data Source Type. Select a value for Instance Type and configure the parameters.
If OceanBase Cluster Instance is selected for Instance Type, set 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.
Cross Alibaba Cloud Account
The data transmission service allows you to configure a task to migrate or synchronize data between instances under different Alibaba Cloud accounts.
You can choose whether to select this option based on business needs. If you select this option, enter the Alibaba Cloud account of the destination instance. If you do not have permissions on this Alibaba Cloud account, request for authorization first. For more information, see Apply for cross-account authorization.
Cluster ID/Name
The ID or name of the cluster to which the OceanBase Database tenant belongs.
Tenant Name
The name of the OceanBase Database tenant.
Tenant Mode
The mode of the OceanBase Database tenant. This field is automatically populated and cannot be modified.
Username
The name of the OceanBase Database user.
We recommend that you create a dedicated database user for the migration or synchronization task. For more information, see Create a normal account for a MySQL tenant in an OceanBase cluster instance and grant privileges to the account or Create a normal account for an Oracle tenant in an OceanBase cluster instance and grant privileges to the account.
Password
The password of the OceanBase database user.
Remarks (Optional)
Additional information about the data source.
__OCEANBASE_INNER_DRC_USER password (Optional)
The password of the __OCEANBASE_INNER_DRC_USER admin user. The admin 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.
In the New Data Source dialog box, you can click Show next to Advanced Options to set this parameter as needed.
If OceanBase Database Tenant Instance is selected for Instance Type, set 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.
Cross Alibaba Cloud Account
The data transmission service allows you to configure a task to migrate or synchronize data between instances under different Alibaba Cloud accounts.
You can choose whether to select this option based on business needs. If you select this option, enter the authorized Alibaba Cloud account of the destination instance. For more information, see Apply for cross-account authorization.
Tenant Name
The name of the OceanBase Database tenant.
Tenant Mode
The mode of the OceanBase Database tenant. This field is automatically populated and cannot be modified.
Username
The name of the OceanBase Database user. We recommend that you create a dedicated database user for the migration or synchronization task. For more information, see Create a database user.
Password
The password of the database user.
Remarks (Optional)
Additional information about the data source.
__OCEANBASE_INNER_DRC_USER password (Optional)
The password of the __OCEANBASE_INNER_DRC_USER admin user. The admin 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.
In the New Data Source dialog box, you can click Show next to Advanced Options to set this parameter as needed.
If Self-Managed Database in VPC is selected for Instance Type, set 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.
Cross Alibaba Cloud Account
The data transmission service allows you to configure a task to migrate or synchronize data between instances under different Alibaba Cloud accounts.
You can choose whether to select this option based on business needs. If you select this option, enter the authorized Alibaba Cloud account of the destination instance. For more information, see Apply for cross-account authorization.
VPC
The unique ID of the virtual private cloud (VPC) used by the user.
Tenant Type
The mode of the OceanBase Database tenant, which can be MySQL or Oracle.
Host IP Address
The IP address of the host where the database is located.
Port
The port number of the host where the database is located.
Tenant Name
The name of the OceanBase Database tenant.
Cluster Name
The name of the cluster to which the OceanBase Database tenant belongs.
Username
The name of the OceanBase Database user.
We recommend that you create a dedicated database user for the migration or synchronization task. For more information, see Create a database user.
Password
The password of the OceanBase 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.
Parameter
Description
DRC User Name
The name of the Data Replication Center (DRC) user. The user reads the incremental logs of OceanBase Database and obtains database schemas. You must create the user in the sys tenant.
Password
The password of the DRC user.
oblogproxy IP (Optional)
The settings of oblogproxy. oblogproxy is a proxy service for managing incremental logs of OceanBase Database. It provides task 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.
oblogproxy Port (Optional)
__OCEANBASE_INNER_DRC_USER password (Optional)
The password of the __OCEANBASE_INNER_DRC_USER admin user. The admin 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.
If OceanBase Serverless Instance is selected for Instance Type, set 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.
Cross Alibaba Cloud Account
The data transmission service allows you to configure a task to migrate or synchronize data between instances under different Alibaba Cloud accounts.
You can choose whether to select this option based on business needs. If you select this option, enter the authorized Alibaba Cloud account of the destination instance. For more information, see Apply for cross-account authorization.
Instance Name
Select a created serverless instance from the drop-down list.
Tenant Mode
The mode of the OceanBase Database tenant. This field is automatically populated and cannot be modified.
Username
The name of the OceanBase Database user. We recommend that you create a dedicated database user for the migration or synchronization task. For more information, see Create a normal account in an OceanBase serverless instance and grant privileges to the account.
Password
The password of the database user.
Remarks (Optional)
Additional information about the data source.
__OCEANBASE_INNER_DRC_USER password (Optional)
The password of the __OCEANBASE_INNER_DRC_USER admin user. The admin 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.
In the New Data Source dialog box, you can click Show next to Advanced Options to set this parameter as needed.
If OBKV Instance is selected for Instance Type, set 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.
Cross Alibaba Cloud Account
The data transmission service allows you to configure a task to migrate or synchronize data between instances under different Alibaba Cloud accounts.
You can choose whether to select this option based on business needs. If you select this option, enter the authorized Alibaba Cloud account of the destination instance. For more information, see Apply for cross-account authorization.
Cluster ID/Name
Select a created OBKV instance from the drop-down list. To create an OBKV instance, select Standard Edition (Key-Value) for Series. For more information, see Purchase an instance.
Tenant Name
Select the tenant ID or name corresponding to the cluster ID or name from the drop-down list.
Username
The name of the OceanBase Database user. We recommend that you create a dedicated database user for the migration or synchronization task. For more information, see Create a database account for an OBKV instance and grant privileges to the account.
Password
The password of the database user.
Remarks (Optional)
Additional information about the data source.
Click Test Connection to verify the network connection between the data transmission system and the data source, as well as the validity of the username and password.
After the test is passed, click OK.