An SQL file replay task is created based on the analyzed traffic and retransmits the traffic to the target database at a specific time. This topic describes how to create an SQL file replay task.
Prerequisites
The SQL file is parsed. For more information, see Create an SQL file parsing task.
Before you perform an SQL file replay task, you must enable the SQL audit feature on the target OceanBase Database. For more information, see Enable SQL audit.
Limitations
- Only users with the roles Project Admin and Data Services Admin are allowed to create SQL file replay tasks.
Procedure
Create an SQL file replay task.
Log on to the OceanBase Cloud console.
In the left-side navigation pane, click Data Services > Migrations.
On the Migrations page, click the Assess Performance tab.
On the Assess Performance tab, choose Create > SQL File Replay in the upper-right corner.
On the page displayed after you choose Assess Performance > Parsed Files, you can click Start Replay next to a target parsed file.
On the Set Up Target Database page, configure the parameters.
Parameter Description Assessment Task Name Enter a custom name for the assessment task, which cannot exceed 30 characters in length. Select Parsed File Select a parsed file from the drop-down list. Region The region of the database. Target Database Instance Select a target database instance from the drop-down list. Make sure that the schema and data of the target instance are consistent with those of the source instance to ensure that the workload can be replayed. Baseline Data Migration By default, Migration Completed is selected. Tenant The ID of the tenant where the target database instance resides. Target Account The username of the target database. For more information about user privileges, see User privileges for workload replay. Password The password of the target database. Click Verify. After the verification succeeds, you can view the list of databases that can be replayed in the Database List of Target End section. Select the database that you want to replay, and click > to add it to the Target list list on the right.
Click OK.
On the Configure Workload Replay page, configure the parameters.
Parameter Description Replay Type Valid values: Read Traffic (DQL) and Write Traffic (DML). Replay Speed The replay speed of the target file. Maximum replay speed: 10x. Sampling Rate The target sampling rate of the target file. Maximum sampling rate: 100%. Concurrency Simulation By default, concurrency simulation is enabled. Click Next.
After the task passes the precheck, click Start Now to start the SQL file replay task.
After the task is completed, you can view the assessment report on the Task List page. For more information, see View a performance assessment report.
Notice
When you start replay, the performance assessment service will automatically add an allowlist named in the omaxxx format in the selected OceanBase database instance to which the application load is replayed. This ensures that the server that runs the replay task can connect to the database instance.