ApsaraDB for OceanBase:Create an SQL file replay task

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 replay task.

Limitations

The migration assessment service supports replay of only parsed files. For more information, see Create an SQL file parsing task.

Procedure

1. Create an SQL file replay task.

   1. Log on to the ApsaraDB for OceanBase console.

   2. In the left-side navigation pane, choose Migration Assessment > Performance Assessment.

   3. On the Performance Assessment page, choose Create > SQL File Replay in the upper-right corner.

      You can also click Start Replay next to the target parsed file on the Parsed Files tab of the Performance Assessment page.

2. On the Set Up Target Database page, configure the parameters.

   Parameter	Description
   Assessment Task Name	The name of the assessment task. You can specify a custom task name.
   Select Parsed File	Select a parsed file from the drop-down list. If you create an SQL file replay task on the Parsed Files tab, you cannot modify this parameter.
   Target Database Instance	Select a target database instance from the drop-down list.
   Baseline Data Migration	Valid values: Data Migration Completed and Use Backup Data for Initialization. Note The Use Backup Data for Initialization option is supported only if the source type of the parsed file you selected is OB_MySQL. If you select Use Backup Data for Initialization, a new instance is created for data backup and restore. For more information, see the following table.
   Tenant	Select a tenant from the drop-down list. Note This parameter is displayed only when you select Data Migration Completed for Baseline Data Migration.

   If you select Use Backup Data for Initialization, you need to configure the following parameters.

   Important

   The migration assessment service supports restore only from an earlier version to a later version. However, restore from an earlier version of the OceanBase Database V4.x series to a later version of this series is not supported.

   Parameter	Description
   Object to Restore	The default value is Tenant.
   Source Cluster	Select the source cluster for data restore from the drop-down list.
   Source Tenant	Select the source tenant for data restore from the drop-down list.
   Restore Point in Time	The point in time to which data is to be restored. The latest point in time to which data can be restored is displayed. You can select a point in time as needed.
   Target Instance	Select from the drop-down list the instance to which the data is to be restored.
   Target Tenant Name	Select from the drop-down list the tenant to which the data is to be restored.
   Resource Distribution Nodes	The number of nodes for resource distribution. More nodes means higher reliability and availability. However, more nodes also require more overall distribution overheads. Select the number of nodes as needed.
   Single-node Resources	The number of CPU cores and memory size allocated to a single node. You can click View Resource Distribution to view the resource distribution among the nodes. Note The total CPU and memory capacities of all tenants cannot exceed the specifications of the cluster to which they belong. Total resources available to a tenant = Single-node resources x Number of resource distribution nodes × Number of replicas
   VPC	The ID of the virtual private cloud (VPC) to which the Elastic Compute Service (ECS) instance belongs. If no suitable VPC is available, create a VPC as prompted. For more information, see Create a VPC.
   Primary Zone	The primary zone of the target tenant.
   vSwitch	The ID of the vSwitch on the network to which the ECS instance belongs. If no suitable vSwitch is available, create a vSwitch as prompted. For more information, see Create a vSwitch.
   Remarks (optional)	The remarks information about data backup and restore.

3. Click Next. On the Configure Workload Replay page, configure the parameters.

   Parameter	Description
   Replay Account/Password	After you enter the replay account and password, click Verify.
   Replay Library	Select a file from the Parsable Files list and click > to add it to the Target list on the right.
   Replay Type	Select the replay type. Valid values: Read Traffic (DQL) and Write Traffic (DML).
   Replay Speed	Select the replay speed from the drop-down list. Maximum replay speed: 10x. Replay at a faster speed increases the queries per second (QPS) and transactions per second (TPS) of traffic so that the replay can be completed within a shorter time frame. For example, if the replay speed is set to 2x, the time required to replay the same traffic can be reduced by half, for example, from four hours to two hours.
   Sampling Rate	Select the sampling rate 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.

4. Click Next. The system automatically performs a precheck.

5. After the precheck succeeds, click Start to execute the SQL file replay task.

   After the task starts, you can view the assessment report on the Assessment Tasks tab. For more information, see View the performance assessment report.

   Important

   When you start replay, the migration assessment service automatically adds an allowlist group named in the omaxxx format to the replay target instance that you selected. This allowlist group ensures that the replay server can normally connect to your database.