The goal of the benchmark is to compare performance and price/performance of Amazon RDS (Aurora) and MySQL server running on EC2 instance.

MySQL versions

  • MySQL 5.6 on RDS
  • Aurora on RDS
  • MySQL 5.6 community version on EC2
  • MySQL 5.7 community version on EC2

Sysbench test

  • Primary Key lookup queries
  • OLTP workload with mix of SELECT, UPDATE, DELETE and INSERT queries
  • IO and CPU bound workloads

Sysbench Benchmarks

CPU bound

Dataset size – 76G

IO bound

Dataset size 375G

MySQL Configuration

Configuration

EC2 Instances

Client Instance

Instance type: m4.2xlarge
vCPU: 8
Memory: 32GB
EBS optimized: Yes

MySQL 5.6 Instance

Instance specifications

Instance type: r3.4xlarge
vCPU: 16
Memory: 122GB
EBS optimized: Yes
EBS Storage:
Volume Type: io1
Volume Size: 1200GB
Provisioned IOPS: 5000

Pricing

Compute: $1.43 per hour (including $0.10 per hour for EBS optimized)
Provisioned IOPS SSD storage: $0.125 per GB-month
Provisioned IOPS IO Rate: $0.065 per provisioned IOPS-month

MySQL 5.7 Instance

Instance specifications

Instance type: r3.4xlarge
vCPU: 16
Memory: 122GB
EBS optimized: Yes
EBS Storage:
Volume Type: io1
Volume Size: 1200GB
Provisioned IOPS: 5000

Pricing

Compute: $1.43 per hour (including $0.10 per hour for EBS optimized)
Provisioned IOPS SSD storage: $0.125 per GB-month
Provisioned IOPS IO Rate: $0.065 per provisioned IOPS-month

RDS Instances

RDS MySQL 5.6

Instance specifications

Instance type: db.r3.4xlarge
vCPU: 16
Memory: 122GB
PIOP optimized: Yes
Network performance: High
EBS Storage:
Volume Type: io1
Volume Size: 1200GB
Provisioned IOPS: 5000

Pricing

Instance: $1.890 per hour
PIOPS SSD storage: $0.125 per GB-month
PIOPS IO Rate: $0.10 per IOPS-month

RDS MySQL 5.7

Instance specifications

Instance type: db.r3.4xlarge
vCPU: 16
Memory: 122GB
PIOP optimized: Yes
Network performance: High
EBS Storage:
Volume Type: io1
Volume Size: 1200GB
Provisioned IOPS: 5000

Pricing

Instance: $1.890 per hour
PIOPS SSD storage: $0.125 per GB-month
PIOPS IO Rate: $0.10 per IOPS-month

RDS Aurora

Instance specifications

Instance type: db.r3.4xlarge
vCPU: 16
Memory: 122GB
PIOP optimized: Yes
Network performance: High
EBS Storage:
Volume Type: io1
Volume Size: 1200GB
Provisioned IOPS: 5000

Pricing

Instance: $2.320 per hour
Storage Rate: $0.100 per GB-month
IO Rate: $0.200 per 1 million requests

Sysbench Commands

CPU bound workload

Prepare command

Point SELECTs

OLTP

IO bound workload

Prepare command

Point SELECTs

OLTP