The short answer is this: You need special software outside of MySQL to do
this. This software has to
- Keep a heartbeat going between the two servers. Whether or not you do this
by checking only MySQL, or the machines themselves, depends upon what other
applications might be running (web server, etc.)
- In the event of a failure, it should cause a shutdown of the primary server
- The secondary MACHINE should adopt the IP address of the failed primary.
Switching the machines back to the original configuration is done (or at least
initiated) by hand, because you need to identify and fix whatever the problem
Global Information Incorporated
195 Farmington Ave.
Farmington, CT 06032
860.674.8796 / FAX: 860.674.8341
Web site: www.the-infoshop.com
>From: Machiel Richards [mailto:machielr@stripped]
>Sent: Tuesday, October 19, 2010 5:15 AM
>To: mysql mailing list
>Subject: Failover on master/slave replication
>Good day all
> I am hoping someone has had some experience in this to assist
> I have been going through lots of forums and documentation and
>can find a lot of information on how to setup a master/slave replication
> The question I have however is how do you fail over to the slave
>server in the event that the master server is unavailable and then how
>to revert back to the master server once the server is available again.
> This is one thing I can't seem to get much info on unless I am
>looking in the wrong places.
> I would really appreciate help on this one.