After the data migration is completed, you must assess the performance of the destination OceanBase database before business switchover. This topic describes how to create a performance assessment task.
Background
You can select any of the following three modes for a performance assessment task as needed: Full Performance Assessment, SQL File Parsing, and SQL File Replay. A full performance assessment task includes the parsing and replay of SQL files. You can specify to run the complete process or perform only the file parsing or the load replay. To create an SQL file replay task, you must specify a complete parsed file.
Procedure
Create a full performance assessment task.
Log on to the ApsaraDB for OceanBase console.
In the left-side navigation pane, choose Migration Assessment > Performance Assessment.
On the Performance Assessment page, choose Create Performance Assessment Task > Full Performance Assessment in the upper-right corner.
On the Select Source Type page, specify related parameters.
Parameter
Description
Assessment Task Name
The name of the assessment task. You can specify a custom task name.
Assessment Type
By default, Load Replay Stress Test is used.
Instance Source
Select Alibaba Cloud Database from the drop-down list.
Database Type
Select RDS_MySQL from the drop-down list.
Database Instance
Select a created database instance from the drop-down list.
Click Next. On the File Parsing and Configuration page, specify related parameters.
Select Import File from OSS or Upload File for Parsed File Import Method. Before the performance assessment, you must enable the SQL audit feature of the RDS Instance by using the log service (SLS). For more information, see Prerequisite operations.
If you store SLS traffic files in an Object Storage Service (OSS) bucket, select Import File from OSS to import traffic files for the performance assessment.
Parameter
Description
AccessKey Account
The AccessKey ID of your Alibaba Cloud account.
AccessKey Password
The AccessKey Secret of your Alibaba Cloud account.
Source OSS Bucket
The name of the OSS bucket from which the logs are imported.
File Delivery Directory
The directory to which the traffic files are delivered.
Stress Test Period
The period of time for the performance assessment. The maximum period is 12 hours.
If no data is obtained, log files are being generated within the specified period.
Click Verify. After the verification succeeds, you can view the files that can be parsed in the Files from OSS list. Select the file that you want to parse, and click > to add it to the Destinations list on the right.
If you store SLS traffic files in the local storage, select Upload File and manually import files in the CSV or JSON format for assessment.
Click Next. On the Select Destination Type page, specify related parameters.
Parameter
Description
Assessment Task Name
The name of the assessment task. You can specify a custom task name.
Baseline Data Migration
By default, Data Migration Completed is used.
Destination Database Instance
Select a destination database instance from the drop-down list.
Tenant ID
Select the ID of the tenant where the destination database instance resides from the drop-down list.
Privileged Account at Destination
The username of the destination database.
Password
The password of the destination database.
Click Verify. After the verification succeeds, you can view the list of schemas that can be replayed on the Logged-on Schemas page. Select the schema that you want to replay, and click > to add it to the Destinations list on the right.
Click Next. On the Replay Configuration page, configure the parameters.
Parameter
Description
Replay Type
Valid values: Query Traffic (SELECT) and Write Traffic (UPDATE, INSERT, and DELETE).
Replay Speed
Select the replay speed of the target file from the drop-down list. Maximum replay speed: 10x.
Sampling Rate
Select the target sampling rate of the target file from the drop-down list. Maximum sampling rate: 100%.
Concurrency Simulation
Specify whether to enable concurrency simulation. If you set the parameter to No, the replay speed will be slow.
The system automatically performs a precheck to check the files and connectivity.
After the precheck succeeds, click Start to launch the performance assessment task.
After the task is completed, you can view the assessment report on the Performance Assessment Tasks page. For more information, see View the assessment report.