Home > Clouds > AWS > AWS FAQs > What are the performance differences between MySQL Database S3 vs. EBS?
What are the performance differences between MySQL Database S3 vs. EBS?
What are the performance differences between MySQL Database S3 vs. EBS?
Table of Contents
Background Information
What kind of read/write performance can be expected from MySQL servers running on EC2? What are the performance differences between EBS and instance-based storage (with Amazon S3 backups)?
Answer
Here are some basic comparisons between a database stored locally on the MySQL server instance (and backing up to S3) versus Amazon-EBS-based storage. Generally, the performance gains on EBS are significant, especially with larger instance types. This uses MySQL Version 5.0.44.
| Instance Type | S3 Read | S3 R/W | EBS Read | EBS R/W |
| EC2 small | 231 | 116 | 247 | 175 |
| EC2 large | 466 | 333 | 526 | 402 |
| EC2 x-large-4.5GB | 620 | 483 | 814 | 642 |
All numbers are transactions per second as printed by sysbench. Several runs were done and the results averaged.
For more information on the benchmarking setup used, see http://blog.rightscale.com/tag/benchmark/.
- © Copyright 2015 RightScale Technical Support