MySQL on Amazon benchmarks : RDS vs EC2
May 4th, 2010 | by Guillaume Plessis |On May 3rd, I gave a talk for the french Amazon Web Services user group about hosting MySQL on Amazon. Two solutions exist :
- using RDS, a “Database as a Service”
- running your own MySQL server on a EC2 instance, with an EBS volume attached, a snapshot-enabled filesystem…
The comparison is made on features, cost and performances. I used the same MySQL version as RDS (5.1.42) and the same config. Performances are measured by tpcc-mysql from Percona and they are charted using Google Fusion Tables.
You’ll se that, altough MySQL + EC2 requires some additionnal DBA or sysadmin skills, it allows a lot of more tuning and a real performance boost (+270%).
So, if you’re planning to host MySQL databases on Amazon, feel free to take a look at these slides :
Note for french-speaking people : la présentation est disponible en français.
Tags: Amazon, Cloud Computing, google-perftools, InnoDB, MySQL
2 Trackback(s)