MySQL Forums
Forum List  »  Other Migration

Time efficient method to migrate MySQL 5.1 to 5.6 from Solaris to Linux
Posted by: harry sheng
Date: September 19, 2014 10:16AM

Hi,

We have a 500GB MySQL 5.1 database (single schema) on Solaris server. We've been having performance issues for quite some time already. We want to move database from Solaris to Linux so that we can have a better hardware platform; at the same time, we also want to upgrade MySQL from 5.1 to 5.6.

The maintenance window we will get is about few hours, we will need to migrate MySQL to different hardware and OS platform and setup a remote master-master replication server.

Our initial test of importing 500GB database on a so-so linux server took about 2 days.

I am wondering if someone knows other time efficient method for this kind of data migration, other than the simple dump/import method.

Thanks.

Options: ReplyQuote


Subject
Views
Written By
Posted
Time efficient method to migrate MySQL 5.1 to 5.6 from Solaris to Linux
4306
September 19, 2014 10:16AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.