Geek Answers Handbook

How do you migrate Amazon RDS from MySQL 5.1 to MySQL 5.5?

RDS supports MySQL 5.5 and offers many automatic features, such as scaling, expanding disk space and updating a younger version of the database (for example, from 5.1.49 to 5.1.50). However, is there a way to upgrade from 5.1.x to 5.5 either using the command line tools or using the web interface?

+4
source share
3 answers

RDS Frequently Asked Questions :

A direct upgrade from MySQL 5.1 to MySQL 5.5 is currently not supported.

so you have to do it in a more traditional way.

For example, a simplified approach would be to start an instance of RDS 5.5 and transfer the 5.1 database to it as follows:

mysqldump -h mysql5.1.database.host database_name|mysql -h mysql5.5.database.host

then switch to using instance 5.5.

Of course, this will be slow for a large database, and you will need to avoid writing to the original database during the transition.

+4
source

Migration from 5.1 to 5.5 is now available through the AWS Management Console.

I don't know when it was added, but it must have changed recently.

+1
source

More articles:


All Articles