On 03/22/2012 01:51 PM, coma wrote: > Ah yes thank you, the service status mysql is now monitored, but the > failover is not performed?
As long as local restarts are successful there is no need for a failover ... there is migration-treshold to limit local restart tries. Regards, Andreas -- Need help with Pacemaker? http://www.hastexo.com/now > > > > 2012/3/22 emmanuel segura <emi2f...@gmail.com <mailto:emi2f...@gmail.com>> > > sorry > I think you missed the op monitor operetion in your primitive definition > > > > Il giorno 22 marzo 2012 11:52, emmanuel segura <emi2f...@gmail.com > <mailto:emi2f...@gmail.com>> ha scritto: > > I think you missed the op monitor operetion you primitive definition > > Il giorno 22 marzo 2012 11:33, coma <coma....@gmail.com > <mailto:coma....@gmail.com>> ha scritto: > > Hello, > > I have a question about mysql service monitoring into a > MySQL HA cluster with pacemaker and DRBD, > I have set up a configuration to allow a failover between > two nodes, it work fine when a node is offline (or standby), > but i want to know if it is possible to monitor the mysql > service to perform a failover if mysql is stopped or > unavailable? > > Thank you in advance for any response. > > My crm configuration: > > node node1 \ > attributes standby="off" > node node2 \ > attributes standby="off" > primitive Cluster-VIP ocf:heartbeat:IPaddr2 \ > params ip="x.x.x.x" broadcast="x.x.x.x" nic="eth0" > cidr_netmask="21" iflabel="VIP1" \ > op monitor interval="10s" timeout="20s" \ > meta is-managed="true" > primitive datavg ocf:heartbeat:LVM \ > params volgrpname="datavg" exclusive="true" \ > op start interval="0" timeout="30" \ > op stop interval="0" timeout="30" > primitive drbd_mysql ocf:linbit:drbd \ > params drbd_resource="drbd-mysql" \ > op monitor interval="15s" > primitive fs_mysql ocf:heartbeat:Filesystem \ > params device="/dev/datavg/data" directory="/data" > fstype="ext3" > primitive mysqld lsb:mysqld > group mysql datavg fs_mysql Cluster-VIP mysqld > ms ms_drbd_mysql drbd_mysql \ > meta master-max="1" master-node-max="1" > clone-max="2" clone-node-max="1" notify="true" > location master-prefer-node-1 Cluster-VIP 25: node1 > colocation mysql_on_drbd inf: mysql ms_drbd_mysql:Master > order mysql_after_drbd inf: ms_drbd_mysql:promote mysql:start > property $id="cib-bootstrap-options" \ > > > dc-version="1.1.5-1.1.el5-01e86afaaa6d4a8c4836f68df80ababd6ca3902f" > \ > cluster-infrastructure="openais" \ > expected-quorum-votes="2" \ > stonith-enabled="false" \ > no-quorum-policy="ignore" \ > last-lrm-refresh="1332254494" > rsc_defaults $id="rsc-options" \ > resource-stickiness="100" > > > _______________________________________________ > Pacemaker mailing list: Pacemaker@oss.clusterlabs.org > <mailto:Pacemaker@oss.clusterlabs.org> > 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 > > > > > -- > esta es mi vida e me la vivo hasta que dios quiera > > > > > -- > esta es mi vida e me la vivo hasta que dios quiera > > _______________________________________________ > Pacemaker mailing list: Pacemaker@oss.clusterlabs.org > <mailto:Pacemaker@oss.clusterlabs.org> > 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: Pacemaker@oss.clusterlabs.org > 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
signature.asc
Description: OpenPGP digital signature
_______________________________________________ Pacemaker mailing list: Pacemaker@oss.clusterlabs.org 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
