Creating a Workload Replay Task

Operation Process

Preparations

Before creating a workload replay task, prepare the Huawei account, source and destination databases, database connection accounts, SQL workload files, and network environment by referring to the following steps.

Step 1: Create a Workload Replay Task

This step describes how to set parameters based on the example values in Preparations. For more information about workload replay, see Replay Overview.

1. Go to the Create Workload Replay Task page.
2. Configure basic information as follows:
   Figure 2 Basic information
   

   Parameter	Example Value	Description
   Region	AP-Singapore	The region where the current task is deployed.
   Project	AP-Singapore	The project corresponds to the current region.
   Task Name	DRS-Replay	The name of the workload replay task.
   Description	Leave this parameter blank for now.	Task description.

3. Configure information about the replay instance.
   Figure 3 Replay instance details
   

   Parameter	Example Value	Description
   Data Flow	Current cloud	The direction of the workload replay task. The options are Current cloud and To the cloud. Current cloud: Both the source and destination databases are Huawei Cloud DB instances. To the cloud: The destination database is a Huawei Cloud DB instance and data needs to be transferred to the cloud.
   Source DB Engine	MySQL	The DB engine type of the source database.
   Workload File Source	Download from Huawei Cloud APIs	Specifies where the workload file in the source database is from.
   Destination DB Engine	MySQL	The DB engine type of the destination database.
   Network Type	Public network	The network type of the workload replay task.
   Destination DB Instance	rds-Replaytar	Select a destination DB instance. The destination DB instance is rds-Replaytar in Databases.
   Replay Instance Subnet	Default subnet	The subnet where the workload replay task is.
   Specify EIP	-	Select an EIP for the DRS instance. In this example, it is the EIP created in Network.

4. Select an AZ and an enterprise project.
   Figure 4 AZ and Enterprise Project
   

   Parameter	Example Value	Description
   AZ	AZ1	Select the AZ where you want to create the DRS task.
   Enterprise Project	default	If your account is associated with an enterprise project, select the project from the Enterprise Project drop-down list. For more details, see Enterprise Management User Guide.
   Tags	Leave this parameter blank for now.	Tags for the workload replay task. Adding tags helps you better identify and manage your tasks.

5. Click Create Now.

   Wait for 5 to 10 minutes. If the message "Replay instance created successfully" is displayed, the DRS task is successfully created.

6. On the Configure Source and Destination Databases page, specify the source and destination database details.
   • Source database settings
     • Workload File Source: Download from Huawei Cloud APIs
     • DB Instance Name: Select the source DB instance rds-Replaysrc created in Databases.
     • Workload Type: Audit log
     • Time Range: Select the time range for audit logs in SQL Workload Files.
   • Destination database settings

     Enter the connection details about the destination database in Connection Accounts.

7. Configure the task.
   Figure 5 Task settings
   

   Parameter	Example Value	Description
   SQL Type	SELECT	Select the SQL type to be replayed to the destination database. The default value is SELECT. The available options are SELECT, INSERT, UPDATE, DELETE, and DDL.
   Replay Mode	Performance	Mode of the workload replay task. You can select Performance or Transaction. In performance mode, you can set how many concurrent connections are allowed. SQL statements are replayed to the destination database based on a set number of connections. The SQL execution sequence in the source database may be different from that in the destination database. The replay performance is better. In transaction mode, you cannot set how many concurrent connections are allowed. The number of connections is dynamically adjusted based on the connections in the source database logs to ensure that transaction SQL statements in the same connection of the source database are executed in sequence.
   Filter out SQLs	-	The system fuzzily matches SQL statements based on the entered condition.
   Filter out SQLs Without Conditions	-	This option is used to filter out SQL statements of the SELECT, UPDATE, and DELETE types that do not contain conditions.
   Maximum Concurrent Connections	8	The number of replay threads configured for the workload replay task.
   Acceleration Configuration	100%	The percentage of the replayed SQLs to the SQLs executed on the source database within the same period.

8. Click Test Connection in the Destination Database area to test the connection to the destination database. After the connection test is successful, click Next.
9. On the Check Task page, check the workload replay task.
   • If any check fails, review the cause and rectify the fault. After the fault is rectified, click Check Again.
   • If all check items are successful, click Next.

10. On the Confirm Task page, specify Start Time.
    Figure 6 Task startup settings
    

    Parameter	Example Value	Description
    Start Time	Start upon task creation	Set Start Time to Start upon task creation or Start at a specified time based on site requirements. The Start at a specified time option is recommended.
    Send Notifications	Disable	This parameter is optional. After enabled, select an SMN topic. If the status, latency metric, or data of the workload replay task is abnormal, DRS will send you a notification.
    Stop Abnormal Tasks After	14	Any task in the Abnormal state that has run for longer than the period you set here (in days) will automatically stop.

11. Confirm that the configured information is correct and click Submit to submit the task.
12. After the workload replay task is submitted, check the task status or query the replay progress on the Workload Replay Management page.
    • You can click in the upper right corner to view the latest task status.
    • By default, DRS retains a task in the Configuration state for three days. After three days, DRS automatically deletes background resources, but the task status remains unchanged. When you reconfigure the task, DRS applies for resources for the task again.

Step 2: Query Replay Progress

The replay progress displays the SQL execution status during workload replay, helping you learn about the task status.

1. On the Workload Replay Management page, click the target replay task in the Task Name/ID column.
2. In the navigation pane, choose Workload Replay Progress to check task progress.
   • In the Workload Replay Progress area, you can view the task status, start time, total number of SQL statements, and number of replayed SQL statements.
   • In the Statistics Chart area, you can view the total number of SQL statements, number of replayed SQL statements, number of abnormal SQL statements, and number of slow SQL statements in a specified period.
   • In the Abnormal SQLs in Workload Replay area, you can view the category and number of SQL statements that fail to be replayed.
   • In the Slow SQLs area, you can view the original time and replay time required for executing a SQL statement.
   • In the SQL Execution Progress are, you can view the SQL statements that are executing in the destination database during replay.

3. After workload replay is complete, check the replay reporting to learn about the execution of each SQL statement.

Step 3: Check Replay Reporting

The replay reporting records the execution time curve of each SQL statement replayed in the destination database, number of replayed SQLs, and replay duration.

1. On the Workload Replay Management page, click the target replay task in the Task Name/ID column.
2. On the Replay Reporting page, check the report details about the current task.
   • In the Statistics Chart area, you can view the total number of SQL statements, number of replayed SQL statements, number of abnormal SQL statements, and number of slow SQL statements replayed in the destination database in a specified period.
     Figure 7 Replay statistics chart
     

   • In the Slow SQLs area, you can view the number of SQL statements of each type and the replay duration.
   • In the Abnormal SQLs in Workload Replay area, you can view the category and number of SQL statements that fail to be replayed.
     Figure 8 SQLs to be replayed
     

Stopping a Task

After confirming that the workload replay task is no longer used, you can stop the DRS task.

1. On the Workload Replay Management page, locate the task and click Stop in the Operation column.
2. In the displayed dialog box, click Yes.