Amazon‘s Relational Database Service (RDS) is a cloud-hosted MySQL solution. I’ve had some clients hitting performance limitations on standard EC2 servers… this series, we will see how the Amazon RDS instance performed at various thread counts on the OLTP benchmark. Update Vadim and Peter…
Post: MySQL on Amazon RDS part 2: Determining Peak Throughput
March 28, 2011 By 4 Comments
… continuation of my series of benchmark posts comparing Amazon RDS to a server running on Amazon EC2. Upcoming posts (probably 6 or 8 in total) will extend the scope of the benchmark to include data on… important to note that these are the results I achieved on this RDS server, from this EC2 “driver” machine, at this specific…
Post: MySQL performance on EC2/EBS versus RDS
August 4, 2011 By 10 Comments
… series of posts showing benchmark results on Amazon EC2 servers with RAID’ed EBS volumes and MySQL, versus RDS machines. For reasons that won…. It is widely speculated on the Internet, and seems reasonable from my own observations, that Amazon RDS is built on EC2 machines and EBS… stock MySQL 5.1. This leads me to a second unverifiable speculation, that Amazon RDS‘s version of MySQL is probably closer to stock MySQL…
Post: Death match! EBS versus SSD price, performance, and QoS
February 21, 2011 By 54 Comments
…. This application is a popular blogging service, running on a generic midrange Dell-class server. The disks …is a popular online retail store, running in the Amazon cloud. It’s a quadruple extra large EC2 server…we can see non-aggregated statistics: #ts device rd_mb_s rd_cnc rd_rt wr_mb_s wr_cnc wr_…
Comment: Should MySQL update the default innodb_log_file_size?
November 22, 2011 By 37 Comments
… don’t even use the provided my.cnf variants. Even Amazon RDS has some undersized defaults (the log file size is 128MB… science fiction in 1998. But the majority of MySQL instances are probably installed on more modest hardware, for example as development instances… user’s hardware could hurt the XAMPPiness of MySQL. (b) All MySQL instances are on dedicated database servers. I do encounter db servers…
Post: Percona Announces Drizzle Support
April 15, 2011 By 2 Comments
As you might have heard, at the MySQL Conference this earlier this week we announced our launch of … database servers that is covered under our MySQL support contracts. This includes MySQL, Percona Server, Amazon RDS, MariaDB, and the XtraBackup and Maatkit tools… you can watch this blog for much more technical content on Drizzle.
Comment: Death match! EBS versus SSD price, performance, and QoS
February 22, 2011 By 54 Comments
We were seeing similar things and then just for fun tried out Amazon RDS. You don’t get access to the disks but we saw MySQL performance go up by about 10x on a simple large import (Went from ~3hrs to ~14 minutes).
Comment: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…://aws.amazon.com/ec2/hpc-applications/ Not available for RDS (yet) but this would look to be a good path to optimize MySQL performance for in the amazon environment. App servers and replication slaves could all be running on HPC instances in…
Comment: MySQL on Amazon RDS part 1: insert performance
March 15, 2011 By 37 Comments
…://aws.amazon.com/ec2/hpc-applications/ Not available for RDS (yet) but this would look to be a good path to optimize MySQL performance for in the amazon environment. App servers and replication slaves could all be running on HPC instances in…
