> -----Original Message----- > From: [EMAIL PROTECTED] [mailto:linux-ha- > [EMAIL PROTECTED] On Behalf Of Andreas Kurz > Sent: Wednesday, February 20, 2008 12:43 PM > To: General Linux-HA mailing list > Subject: Re: [Linux-HA] how to mysql circular replication move IP > > On Feb 20, 2008 8:09 PM, Damon Estep <[EMAIL PROTECTED]> wrote: > > I am trying to; > > > > > > > > Run mysql on a two node cluster (active/active) with circular > > replication enabled <- I have already set this setup > > > > > > > > Run two virtual IPs, one on each node when both nodes are healthy and > > mysql is running <- also apready running > > > > > > > > Move the IP from the failed node to the good node if the node fails > > (easy enough) or if mysql fails <- my challenge > > > > > > > > How can I create a constraint that says; > > > > > > > > Run this ip resource on this node if mysql is running, but move it to > > the other node if it is not? So that the IP prefers one node only if > my > > sql is running ,but will gotohe other node if it is not. > > I did a similar setup some times ago but I solved it by using two > mysql lsb scripts ... one for each instance: > > * on node1 "mysql_01" was responsible for starting the first mysql > instance and "mysql_02" was only a dummy > * on node2 "mysql_02" was responsible for starting the second mysql > instance and "mysql_01" was only a dummy > > So only two simple groups and two location constrainst were needed. > > Regards, > Andreas >
[Damon Estep] Makes sense, there is no reason a start cannot be sent to the mysql service as it appears it will not start a second instance as a result. Thanks for the tip. Damon _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
