Updated on 2025-02-17 GMT+08:00

Replay Overview

A workload replay task simulates the service load of the source database on the destination database so you can evaluate the effectiveness and performance of the destination database.

A task consists of SQL recording and replay. All of the SQL statements (create, delete, update, and query operations) executed in the required period on the source database will be downloaded by a recording tool from the binlog, and then cached and injected into the destination database where you can trigger a replay and review performance.

Typical Scenarios

  • By creating a workload replay task, you can evaluate how the service load of the source database runs on the destination database.
  • By specifying the replay thread and speed, you can simulate the peak service load of the source database and analyze the stability of the destination database when workloads increase sharply.
Figure 1 Workload replay

Supported Database Types

The following table lists the database types supported by DRS in workload replay.

Table 1 Replay scheme

Source DB Type and Version

Destination DB Type and Version

Related Documents

RDS for MySQL

RDS for MySQL

From MySQL to MySQL (Current cloud)

TaurusDB

From MySQL to TaurusDB (Current cloud)

TaurusDB

TaurusDB

From TaurusDB to TaurusDB (Current cloud)

  • ECS-hosted MySQL
  • On-premises MySQL
  • MySQL on other clouds

RDS for MySQL

From MySQL to MySQL (To the cloud)

TaurusDB

From MySQL to TaurusDB (To the cloud)

Other Cloud Replay Solutions

DRS allows you to replay data from other cloud databases (such as AWS RDS for MySQL and Aurora for MySQL) to Huawei Cloud databases (such as RDS for MySQL).

Table 2 Replay solutions

Source Database Cloud Vendor

Source DB Type

Destination Database (Huawei Cloud)

Reference

AWS

Amazon RDS for MySQL

RDS for MySQL

From MySQL to MySQL

AWS

Amazon RDS for MySQL

TaurusDB

From MySQL to TaurusDB

AWS

Amazon Aurora MySQL

RDS for MySQL

From MySQL to MySQL

AWS

Amazon Aurora MySQL

TaurusDB

From MySQL to TaurusDB

Alibaba Cloud

ApsaraDB RDS for MySQL

RDS for MySQL

From MySQL to MySQL

Alibaba Cloud

ApsaraDB RDS for MySQL

TaurusDB

From MySQL to TaurusDB

Alibaba Cloud

PolarDB for MySQL

RDS for MySQL

From MySQL to MySQL

Alibaba Cloud

PolarDB for MySQL

TaurusDB

From MySQL to TaurusDB

Tencent Cloud

TDSQL-C for MySQL

RDS for MySQL

From MySQL to MySQL

Tencent Cloud

TDSQL-C for MySQL

TaurusDB

From MySQL to TaurusDB