Hi, I recently had the experience of assisting with a migration of a customer MySQL installation to Amazon RDS (Relational Database Service). Amazon RDS is a great platform for hosting your MySQL installation and offers the following list of pros and cons:
- You can scale your CPU, IOPS, and storage space separately by using Amazon RDS. Otherwise you need to take downtime and upgrade physical components of a rack-mounted server.
- Backups, software version patching, failure detection, and (some) recovery is automated with Amazon RDS.
- You lose shell access to your DB instance
- You lose SUPER privilege for regular users. Many SUPER-type statements and commands are provided for as a Stored Procedure.
- It is easy to set up multiple read