Updated on 2024-11-30 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)

GaussDB(for MySQL)

From MySQL to GaussDB(for MySQL) (Current cloud)

GaussDB(for MySQL)

GaussDB(for MySQL)

From GaussDB(for MySQL) to GaussDB(for MySQL) (Current cloud)

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

RDS for MySQL

From MySQL to MySQL (To the cloud)

GaussDB(for MySQL)

From MySQL to GaussDB(for MySQL) (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

GaussDB(for MySQL)

From MySQL to GaussDB(for MySQL)

AWS

Amazon Aurora MySQL

RDS for MySQL

From MySQL to MySQL

AWS

Amazon Aurora MySQL

GaussDB(for MySQL)

From MySQL to GaussDB(for MySQL)

Alibaba Cloud

ApsaraDB RDS for MySQL

RDS for MySQL

From MySQL to MySQL

Alibaba Cloud

ApsaraDB RDS for MySQL

GaussDB(for MySQL)

From MySQL to GaussDB(for MySQL)

Alibaba Cloud

PolarDB for MySQL

RDS for MySQL

From MySQL to MySQL

Alibaba Cloud

PolarDB for MySQL

GaussDB(for MySQL)

From MySQL to GaussDB(for MySQL)

Tencent Cloud

TDSQL-C for MySQL

RDS for MySQL

From MySQL to MySQL

Tencent Cloud

TDSQL-C for MySQL

GaussDB(for MySQL)

From MySQL to GaussDB(for MySQL)