Reason to Upgrade Your RDS MySQL instance to Provisioned IOPS
High-performance, provisioned IOPS storage was available in Amazon RDS for more than a year ago, as you can read from AWS article published on 9/25/2012. Recently our MySQL database has grown and contains more than 200 databases, with some of them containing millions of rows (and growing rapidly). Our Multi-AZ RDS instance is db.m1.large which provides pretty decent performance even when it is not EBS optimized. Squeezing more performance was one of my goals when decided to take the road to enable IOPS. You can start from 1000 IOPS with 1000 IOPS increments. I decided to go with 1000 for a start. Process for upgrading Multi-AZ instance is far from complicated - after making your selections through the dashboard UI and deciding to apply changes immediately, instance performs automated fail-over which minimizes the downtime for merely minute or so until DNS reacts to changes. Total upgrade took about 5 hours but system was never down and I did not notice any slowness. Once done, ...