Has anyone setup something like this before:
Quote:
"Setting up ring replication, where both machoines are masters and
slaves to each other solves the problem of failing back to the original
master. The setup is not too difficult either. Have unique server-ids on
both machines, log-bin and log-slave-updates on all machines, and then
set up replication normally. The designated slave machine would point to
the designated master, and then the designated master would point to the
designated slave, forming a replication ring. If any machine fails, or
is taken out of service, then it would be easy to put it back in service
at the appropriate time. Since it was already a slave, then it can catch
up on all of the missed transactions when it re-establishes connectivity
to the original slave." - Partha Dutta
(Source: http://forums.mysql.com/read.php?26,35499,36109#msg-36109)
I'm looking for a redundant MySQL setup with two servers that can fail
over cleanly without intervention.
David
_______________________________________________
mlug mailing list
[email protected]
https://listes.koumbit.net/cgi-bin/mailman/listinfo/mlug-listserv.mlug.ca
