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 > > > > I am currently using the lsb RA to monitor both instances of mysql (on > resource on each node) > > > > Does the ofc RA support active active mysql and is there a way to move > the Ip as desired? > > > > Thanks > > > > _______________________________________________ > Linux-HA mailing list > [email protected] > http://lists.linux-ha.org/mailman/listinfo/linux-ha > See also: http://linux-ha.org/ReportingProblems > _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
