All Products
Search
Document Center

Backup and recovery performance tests

Last Updated: Dec 07, 2018

Note for backup and recovery performance tests

The following performance test results are for reference only and shall not be used to evaluate SLA performance.

Introduction

This section tests the backup and recovery performance of multiple instance types. The results are intended as a reference for your decision making.

Terms

  1. Type: DBS supports multiple instance types, which offer different performance based on the CPU, memory, and network bandwidth settings of the backup server.
  2. RPS: Represents the number of record changes on the source database in every minute during backup and recovery. These record changes are caused by data modification operations such as insert, update, and delete. If one SQL statement involves operations on multiple data rows, multiple record changes are noted. If repeated operations are performed on the same record, multiple record changes are noted. Each commit operation is also seen as one record change.

Test model

Test procedure:Create an ApsaraDB for MySQL instance as the test database. Create a backup plan and enable full backup and incremental backup. Backup the test database and store backup sets in OSS. Use backup sets to restore the test database.

Test environment:

Database configuration Setting
Type Common ApsaraDB for RDS instance
Memory 2,400M
CPU 8-core
IOPS 1,200

Test data:

  1. Database size: 102 GB
  2. Total number of records: 150 million
  3. Size of each record: 100~1K
  4. Number of fields: 3 to 22 columns
  5. Field types: Basic MySQL data types

Test results

Full backup

Note: If the backup source database contains too many tables, table structure recovery could take a long time. We recommend that you keep a maximum of 10,000 tables in each database. If the backup source database contains tables without a primary key, or tables with a string type primary key or composite key, this could also slow down the backup process.

Instance type RPS MBPS
large 42855.76 15.31
medium 33122.27 11.83
small 9569.36 3.42
micro 6756.23 1.96

Incremental backup

Instance type MBPS
large 46.11
medium 29.82
small 14.93
micro 5.02

Full recovery

Note: If the target database contains too many tables, table structure recovery could take a long time. We recommend that you keep a maximum of 10,000 tables in each database.

Instance type RPS
large 34190.55
medium 19740.97
small 9949.45
micro 4320.22

Incremental recovery

Instance type RPS
large 35546.97
medium 21331.45
small 10061.58
micro 4972.12