Hi all, We are moving our site and wanted to find out if anyone has done this and what is the best solution. We have a 2 web server farm now with 1 being Mysql that we are hsoting at an ISP.
Want to know the best way to move the live database to our new server farm with 2 database servers. Hopefully not have the users miss anything or have the site down at all if possible. 1. Is it better to shut down the existing Mysql server and do a database dump and then use this to create the new database 2. Set up the new database to be a slave of the live database we have now so it gets replicated and then when we turn off the old site the slave can become the master for the new site. I will have to still get a dump of the data on the old server and also turn on logging on it so the new server can catch up. I am reading more about this process and need to find out if the lod db must be down for a bit while we get the dump. Thanks in advance. Joe --------------------------------------------------------------------- Before posting, please check: http://www.mysql.com/manual.php (the manual) http://lists.mysql.com/ (the list archive) To request this thread, e-mail <[EMAIL PROTECTED]> To unsubscribe, e-mail <[EMAIL PROTECTED]> Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
