MySQL Forums
Forum List  »  MySQL Administrator

Re: Mysql Server move
Posted by: Ronan Cashell
Date: August 28, 2012 07:51AM

One of the easiest ways of doing this is using replication. If you lock all tables and identify the latest binary log file and position and then take a complete backup. No writes should be performed until the backup has completed. Once we have a successful backup then restore the backup onto your extra server. When restoring the tables you can recreate these as MyISAM engines. Then you setup replication using the log file and position noted previously and start replication to the extra server. At a pre-determined point, stop transactions to your production server, allow remaining replicated transactions to be migrated across and then make the extra server the production server. This will minimize the amount of downtime.

Ronan Cashell
Senior Oracle/MySQL Administrator
IT Integrated Business Solutions
http://www.it-iss.com

Options: ReplyQuote


Subject
Written By
Posted
August 25, 2012 04:00PM
Re: Mysql Server move
August 28, 2012 07:51AM


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.