This topic describes how to perform online compatibility assessment for a database.
Background information
Online assessment directly connects to your database, collects information such as objects, SQL statements, and database load from your database. Then, online assessment compares the collected information with OceanBase Database to identify incompatibilities and provide solutions.
Limitations
Only users with the roles Project Admin and Data Services Admin are allowed to create the online assessment tasks.
Procedure
Create an online assessment task.
Log on to the OceanBase Cloud console.
In the left-side navigation pane, click Data Services > Migrations.
The Assess Compatibility tab automatically appears.
On the Assess Compatibility tab, choose Create > Online Assessment in the upper-right corner.
On the Assess Compatibility tab, click Create > Online Assessment in the upper right corner.
On the Basic Information page, configure the parameters.
Enter a custom name in the Task Name field. The task name cannot exceed 30 characters in length.
In the Source Profile section, configure the parameters.
If you want to reference the configurations of an existing data source, click Quick Fill next to Source Profile and select the required data source from the drop-down list. Then, the parameters in the Source Profile section are automatically populated. If you need to save the current configuration as a new data source, click on the Save icon located on the right side of the Quick Fill.
You can also click Quick Fill > Manage Data Sources, enter Data Sources page to check and manage data sources. You can manage different types of data sources on the Data Sources page. For more information, see Data Source document.
Parameter Description Cloud Vendor Currently supports Amazon Cloud, Huawei Cloud, and Alibaba Cloud. Database Type At present, only MySQL is supported. Instance Type - When you select Amazon Cloud as the cloud vendor, the instance type supported is Aurora MySQL.
- When you select Huawei Cloud as the cloud vendor, the instance type supported is RDS MySQL. >
- When you select Alibaba Cloud as the cloud vendor, the instance type supported are RDS MySQL and PolarDB MySQL.
Region The region of the source database. Connection Type Available connection types are Endpoint and Public IP. - If you choose Endpoint connection type, you need to first add the authorized account ID displayed on the page to the whitelist of your endpoint service. This allows the endpoint from that account to connect to the endpoint service. For more information, see Adding private network whitelist.
- If your Cloud Vendor is Amazon Cloud, when you create an Endpoint Service, if the parameter Acceptance required for endpoint connections is set to Enabled, the compatibility assessment will prompt you to Accept endpoint connection request in the Amazon Cloud console upon first connecting via private connection.
- When your Cloud Vendor is Huawei Cloud, create an endpoint service, then obtain the account ID and add it to the user whitelist of the endpoint service. For more information, see Configure endpoints for cross-VPC communication.
Connection - When you select Connection Type as Endpoint, enter the endpoint service name.
- When you select Connection Type as Public IP, enter the IP address and port number of the database host machine.
Account/Database User The name of the database user of the MySQL database for which compatibility assessment is to be performed. Password The password of the database user. In the Target Profile section, configure the variables.
Parameter Description Target Database Type At present, only OceanBase MySQL Compatible Mode is supported. Target Database Version Select the target database version from the drop-down list. In the Assessment Type section, select the assessment type.
At present, Object Assessment and Profile Assessment are supported.
Click Next.
On the Advanced Configurations page, specify the assessment scope.
Parameter Description Select Assessment Objects In Source List on the left side, select the target schema and click > to add it to the list on the right side. Select Object Type In the Select Object Type section, select the type of the target objects. Click Start Assessment to start the online assessment task.