Set the timeout to near 0 and have mysql_connect retry on the other on
failure.
OR
Set a haproxy in front of the MySQL servers to connect to whichever one
responds.
On Tue, 18 Jan 2011, David Filion wrote:
Date: Tue, 18 Jan 2011 08:49:20 -0500
From: David Filion <[email protected]>
Reply-To: Montreal Linux Users Group <[email protected]>
To: Montreal Linux Users Group <[email protected]>
Subject: [MLUG] Mysql server ring for redundancy
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
