Hi Vossel, Thanks for the information. I have tried to put mysql un-managed, but in this situation, when I shutdown mysqld or make as standby of the node which the IP resource is on, the cluster will put the IP resource as stopped other than failing over. Also, if I shutdown mysqld on the other node, the cluster doesn't even know the mysql service is stopped.
Does the cluster only monitor resource on the active node? -- Dongdong On Thu, 2012-07-26 at 13:54 -0400, David Vossel wrote: > ----- Original Message ----- > > From: "Dongdong Zhou" <[email protected]> > > To: [email protected] > > Sent: Thursday, July 26, 2012 4:41:36 AM > > Subject: [Pacemaker] IP fail over without controlling the services > > > > Hi, > > > > I'm trying to set up IP auto fail over on a two-way master-slave > > MySQL > > replication cluster. What I'm trying to achieve is to only fail over > > the > > IP when there's a problem on the mysqld service. I don't want > > pacemaker > > to control the mysqld service. > > Make the mysql resource an un-managed resource... meaning pacemaker won't > stop/start it, but it will monitor to see if it is alive or not. If it > fails, your constraints for the IP should work like you expect. > > look at the is-managed option at this link. > http://www.clusterlabs.org/doc/en-US/Pacemaker/1.1/html/Pacemaker_Explained/s-resource-options.html > > -- Vossel > > > > > With my current configuration, pacemaker will always keep the service > > running on the active node and the service stopped on the passive > > node. > > > > Any help would be much appreciated. > > > > primitive VIP ocf:heartbeat:IPaddr2 \ > > params ip="109.68.38.75" cidr_netmask="24" \ > > op monitor interval="30" > > primitive mysqld lsb:mysqld \ > > op monitor interval="10" timeout="30" > > group mysql mysqld VIP > > property $id="cib-bootstrap-options" \ > > dc-version="1.1.7-6.el6-148fccfd5985c5590cc601123c6c16e966b85d14" \ > > cluster-infrastructure="openais" \ > > expected-quorum-votes="2" \ > > stonith-enabled="false" \ > > no-quorum-policy="ignore" \ > > last-lrm-refresh="1343214667" > > rsc_defaults $id="rsc-options" \ > > resource-stickiness="100" > > _______________________________________________ > > Pacemaker mailing list: [email protected] > > http://oss.clusterlabs.org/mailman/listinfo/pacemaker > > > > Project Home: http://www.clusterlabs.org > > Getting started: > > http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > > Bugs: http://bugs.clusterlabs.org > > > > _______________________________________________ > Pacemaker mailing list: [email protected] > http://oss.clusterlabs.org/mailman/listinfo/pacemaker > > Project Home: http://www.clusterlabs.org > Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf > Bugs: http://bugs.clusterlabs.org _______________________________________________ Pacemaker mailing list: [email protected] http://oss.clusterlabs.org/mailman/listinfo/pacemaker Project Home: http://www.clusterlabs.org Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf Bugs: http://bugs.clusterlabs.org
