MySQL Forums
Forum List  »  MySQL Administrator

Mysql Server move
Posted by: king shaz
Date: August 25, 2012 04:00PM

We have an active 500GB standalone OLTP mysql database that has all of

its tables stored in the Innodb engine. We have determined that we must

convert it all to Myisam for performance reasons. The problem is that

our cost of downtime is very high $20,000 an hour and we would like this

migration to use the least down time possible. Your task here is to

devise a project plan, including detail steps, that describes how you

would accomplish this project especially highlighting the steps in the

plan that require downtime.



We have an extra server which is identical to production as well as an

Innodb Backup license which is used in nightly backups which can be made

available if required.

Options: ReplyQuote


Subject
Written By
Posted
Mysql Server move
August 25, 2012 04:00PM
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.