Migrating to Amazon RDS

I’ve been suffering from some scaling issues lately and since my system administration skills are fairly rudementary I decided to opt for Amazons RDS services for providing a MySQL server that is properly built with the appropriate block devices and automatically kept up to date by Amazon.

Moving my existing database over to an Amazon RDS instance was relative straight forward.

After launching an RDS instance from the Amazon AWS console.  I added my existing security groups to the security groups so they could connect to it.

Once everything had a launched I was able to easily move my existing MySQL database over to the new server.

mysqldump dbname -u root -p > dbname.sql
cat dbname.sql | mysql --host=hostname -u dbusername --password newDBname

Once that had run I was able to update my django application to connect to the new server and all was good.

Surprisingly painless. Thanks Amazon.