On Wednesday 07 April 2010 12:53:55 pm Max Schubert wrote:
> Just found this article last night on circular replication with
> auto-recovery from single node in chain failures:
>
> http://onlamp.com/pub/a/onlamp/2006/04/20/advanced-mysql-replication.html?p
>age=1
>
> Uses federated tables for 'is my peer alive' along with SQL scheduler
> and a stored procedure to do the alive check and then reconnect a peer
> to the peer+1 server if a replication peer goes away.
I'll have to do some more reading about federated tables. However, I'm
thinking it might be easier to script the recovery process and integrate
the "is my master alive?" polling with my network/server monitoring system,
thus eliminating the need for the SQL scheduler. The SQL scheduler is really
cool sounding, but still beta.
I think that for now, I'm going to go with the A<->B->C scheme. I can move to
a fully circular scheme, later.
In the mean time, I have to migrate all of this from Postgres....
--
Take care and have fun,
Mike Diehl.
