… Performance Cluster Compute instance type? http://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…
Comment: What Linux Distribution do you use to run MySQL ?
I voted for RHEL and CentOS, but would add another RH derivative – Amazon Linux. If you’re in AWS anyway, it’s relevant, and it’s definitely not stock RHEL or CentOS. Now, if only we could get Percona Server in RDS… is there any chance of that partnership happening?
Comment: Troubleshooting MySQL Memory Usage
… suspecting it could be a memory leak. I am using Amazon‘s RDS, I dont have access to the VM where MySQL…
Comment: The Math of Automated Failover
… it with Amazon instance (Multi AZ) and it took an hour to detect the issue and failover scenario; and then RDS support…
Comment: Cache Miss Storm
Wow this was useful. Take a look at our issue as reported on server fault: http://serverfault.com/questions/429013/mysql-server-hitting-100-unexpectedly-amazon-aws-rds It may have a proper name but the technique we used was very effective. Benchmark results are much better!
Comment: MySQL performance on EC2/EBS versus RDS
I am not sure where the page is located, but Amazon‘s suggested best practice for database servers is RAID-10 over EBS, and this is apparently what RDS is built on. The client for whom these benchmarks were run uses this as their standard setup.

