Once server 1 is down you should be able to set server 2 master and then point dns to server 2 and all should be good for server 1 to come back as slave. If you did not set server 2 as slave it would still work as a master the only problem is how to point the questions to server 2! Dynamic DNS?
Simon -----Original Message----- From: Stephen Patterson [mailto:[EMAIL PROTECTED]] Sent: 04 December 2002 23:27 To: mysql list Subject: Replication - if the master fails... We're currently operating 1 MySQL server and are investigating methods for having a primary and secondary server (with the secondary taking over if the primary fails). I know about replication in MySQL, and was thinking of using that to keep the secondary in sync, if the primary should fail, is it possible to set up the secondary in its place? The docs don't seem to clear on that. --------------------------------------------------------------------- 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 --------------------------------------------------------------------- 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
