Good day all
I am hoping someone has had some experience in this to assist
me.
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
on MySQL.
The question I have however is how do you fail
Quoting Machiel Richards machi...@rdc.co.za:
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.
Hi,
to fail over to the
That's pretty much it, indeed. You need to make absolutely sure that no more
connections can be made to the old, broken master, though - even if you have
to physically pull the network or power cable. Failover services refer to
this as STONITH: Shoot The Other Node In The Head.
Don't think but it
You may also want to take a look at MySQL MMM which makes use of
Active/passive masters to makes MySQL failover very simple.
On 19 October 2010 11:45, Johan De Meersman vegiv...@tuxera.be wrote:
That's pretty much it, indeed. You need to make absolutely sure that no
more
connections can be
...@rdc.co.za]
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
me.
I have been going through lots of forums and documentation and
can find a lot
On Tue, Oct 19, 2010 at 19:06, John Daisley daisleyj...@googlemail.com wrote:
You may also want to take a look at MySQL MMM which makes use of
Active/passive masters to makes MySQL failover very simple.
+1 We could not do much of our daily work without MMM. It makes
the whole HA/Failover