You can create a backup schedule on either of the following pages:
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
- Type: DBS supports multiple instance types, which offer different performance based on the CPU, memory, and network bandwidth settings of the backup server.
- 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:
- Database size: 102 GB
- Total number of records: 150 million
- Size of each record: 100~1K
- Number of fields: 3 to 22 columns
- 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(Record Per Second) | MBPS(MByte Per Second) |
---|---|---|
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 |