Thank You, I am almost there. How do have both servers running mysqld? And have a collocation resource between the 2.
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Andrew Beekhof Sent: Wednesday, April 01, 2009 8:00 AM To: General Linux-HA mailing list Subject: Re: [Linux-HA] 1 ip resource fail between master master mysql instance help add a colocation constraint between the ip and mysql. On Wed, Apr 1, 2009 at 08:43, Martin Suehowicz <[email protected]> wrote: > I am setting up a master/master mysql instance with 2 arrays. I would > like to setup a address to fail between the two of them. > I can setup a ip resource ok and I can get to fail over ok. I do have 2 > problems. > > 1. I cannot figure out how to fail the ip resource if mysql goes down. > Also since it is master master I need both mysql resources running. > 2. I also want to disable auto fail back. "auto_failback off" in > /etc/ha.d/ha.cf does not work. Help! Here is my cib.xml: > > > > <cib generated="true" admin_epoch="0" have_quorum="true" > ignore_dtd="false" ccm_transition="5" num_peers="1" > cib_feature_revision="2.0" crm_feature_set="2.0" > dc_uuid="480621cf-cb29-4ac4-887f-8572da0d92d7" epoch="7" num_updates="2" > cib-last-written="Sat Oct 11 09:13:11 2008"> > <configuration> > <crm_config> > <cluster_property_set id="cib-bootstrap-options"> > <attributes> > <nvpair id="cib-bootstrap-options-dc-version" > name="dc-version" value="2.1.4-node: > 74d736e8f667fae1e4a904ccd13ad6553c5c010c"/> > </attributes> > </cluster_property_set> > </crm_config> > <nodes> > <node id="480621cf-cb29-4ac4-887f-8572da0d92d7" > uname="qsql01.lax.rubi" type="normal"/> > <node id="8d771dd1-ba9a-43ef-b2cc-1573ad90c02e" > uname="qsql02.lax.rubi" type="normal"/> > </nodes> > <resources> > <primitive id="R_10.10.30.167" class="ocf" type="IPaddr2" > provider="heartbeat"> > <instance_attributes id="RA_R_10.10.30.167"> > <attributes> > <nvpair id="R_ip_P_ip" name="ip" value="10.10.30.167"/> > <nvpair id="R_ip_P_nic" name="nic" value="eth0"/> > </attributes> > </instance_attributes> > </primitive> > </resources> > <constraints/> > </configuration> > </cib> > > _______________________________________________ > 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 _______________________________________________ Linux-HA mailing list [email protected] http://lists.linux-ha.org/mailman/listinfo/linux-ha See also: http://linux-ha.org/ReportingProblems
