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 <vegivamp@stripped> wrote:
> That's pretty much it, indeed. You need to make absolutely sure that no
> connections can be made to the old, broken master, though - even if you
> 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 went down anyway, that's why I failed over" - sometimes
> the service unexpectedly manages to recover itself after you've switched;
> and any data that gets inserted into the wrong system is as good as lost,
> unless you want to go through a manual reconciliation before reinitialising
> the replication.
> On Tue, Oct 19, 2010 at 11:55 AM, <a.smith@stripped> wrote:
> > Quoting Machiel Richards <machielr@stripped>:
> >> 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 slave, you dont need to do anything (except be sure
> > that replication is off). That is, tell your apps etc to use the slave
> > IP/hostname, change the slave server IP to that of the master or update
> > so that all connections are made to the slave instead of the master.
> > To reinstate the master after a failover, you must copy your live
> > (now on slave) to the master and reinitiate replication pretty much as
> > did when replication was initially setup. Copying the live DB can be
> > achieved via restoring a backup (from the live slave) or you could look
> > Maakit which can analyse table differences and copy only changed data
> > (useful for very large DBs, Ive not personally used it tho).
> > Thats about it I think, unless anyone wants to correct me on that...
> > thanks Andy.
> > --
> > MySQL General Mailing List
> > For list archives: http://lists.mysql.com/mysql
> > To unsubscribe: http://lists.mysql.com/mysql?unsub=1
> Bier met grenadyn
> Is als mosterd by den wyn
> Sy die't drinkt, is eene kwezel
> Hy die't drinkt, is ras een ezel
Certified MySQL 5 Database Administrator
Certified MySQL 5 Developer
Cognos BI Developer
Telephone: +44 (0)7918 621621