Amazon RDS Switch to MySQL 5.5
Upgrading your Amazon RDS instance from MySQL version 5.1 to MySQL 5.5 has never been easier, as Amazon Web Services announced earlier this week. Now you can modify your MySQL RDS instance using feature called Major Feature Upgrade . MySQL 5.5 includes several features and performance benefits over MySQL that may be of interest to you including enhanced multi-core scaling, better use of I/O capacity , and enhanced monitoring by means of the performance schema . MySQL 5.5 defaults to version 1.1 of the InnoDB Plugin, which improves on version 1.0 (the default for MySQL 5.1) by adding faster recovery, multiple buffer pool instances, and asynchronous I/O. Here's how you can upgrade your RDS instance: Log in to your AWS Console Go to RDS, and select your instance From Instance Actions drop down, choose Modify Select latest version of MySQL 5.5 from the drop down, To upgrade immediately, select the Apply Immediately check box. To delay the upgrade to the next maintenance wi...