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)?
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 |
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/.
© 2006-2014 RightScale, Inc. All rights reserved.
RightScale is a registered trademark of RightScale, Inc. All other products and services may be trademarks or servicemarks of their respective owners.