Three types of performance assessment tasks are supported: Full Assessment, SQL File Parsing, and SQL File Replay. This topic describes how to create an SQL file parsing task.
Limitations
The migration assessment service supports file parsing only for the source database.
Procedure
Create an SQL file parsing 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 > SQL File Parsing in the upper-right corner.
On the Set Up Source Database page, configure the parameters.
Parameter
Description
Assessment Task Name
The name of the assessment task. You can specify a custom task name.
Cloud Vendor
Select Alibaba Cloud Database from the drop-down list.
Source Database Type
Select the required database type from the drop-down list. You can select RDS_MySQL, PolarDB-X 1.0, PolarDB-X 2.0, OB_MySQL, OB_Oracle, TIDB, or POLARMYSQL.
Source Database Instance
Select a created database instance from the drop-down list.
NoteThis parameter is available only when you select OB_MySQL or OB_Oracle for Source Database Type.
Tenant
This parameter is available only when you select OB_MySQL or OB_Oracle for Source Database Type.
Click Next. On the Configure Data Collection page, configure the parameters.
If you selected RDS_MySQL, PolarDB-X 1.0, PolarDB-X 2.0, or POLARMYSQL for Source Database Type, the Import File from OSS and Upload File options are supported for Data Collected From. Before performance assessment, you need to enable the SQL audit feature for RDS, PolarDB-X, or PolarDB by using Simple Log Service (SLS). For more information, see Prerequisite operations.
NoteWe recommend that you create a dedicated user for the migration assessment service and grant the user only permissions on relevant buckets. For more information about the Alibaba Cloud account system, see the documentation of Resource Access Management.
If you store SLS traffic files in an OSS bucket, select Import File from OSS to import traffic files for 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 Directory
The directory to which the traffic files are delivered.
Data Collection Range
The time period for assessment. Objects generated during the specified time period are assessed. The maximum time period is 24 hours.
If no data is obtained, no log files are generated within the specified period.
Click Verify. After the verification succeeds, parsable files are displayed in Valid File List.
If you store SLS traffic files in the local storage, select Upload File and manually import files in the JSON, CSV, LOG, or ZIP format for assessment.
NoteIf you select TIDB for Source Database Type, only the Upload File option is supported for Data Collected From.
If you selected OB_MySQL or OB_Oracle for Source Database Type, configure the parameters in the following table.
Parameter
Description
Data Collected From
If the source database type is OB_MySQL or OB_Oracle, you can select Collect from Audit Views.
NoteThis collection method is available for limited-time free trial.
Data Collection Range
You can select a start time and end time for data collection. A maximum span of 30 days is supported, and data in at most 24 hours can be parsed at a time.
Click Next. The system automatically performs a precheck.
After the task passes the precheck, click Start to start the SQL file parsing task.
After the task starts, you can view its information, such as the task progress, on the Assessment Tasks tab. For more information, see View details of a performance assessment task. After a file is separately parsed, it will be displayed on the Parsed Files tab of the Performance Assessment page.