I would love to have a setup like that.
Let me know if anyone has attempted this in a production environment
(and succeeded).
I might have a few questions.
On 18/01/2011 8:49 AM, David Filion wrote:
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
_______________________________________________
mlug mailing list
[email protected]
https://listes.koumbit.net/cgi-bin/mailman/listinfo/mlug-listserv.mlug.ca
