if you set migration-thresold=2 after two operation fail-count it's reached your resource trys to switch to an other node
http://www.clusterlabs.org/doc/en-US/Pacemaker/1.0/html/Pacemaker_Explained/s-failure-migration.html Il giorno 22 marzo 2012 13:51, coma <coma....@gmail.com> ha scritto: > Ah yes thank you, the service status mysql is now monitored, but the > failover is not performed? > > > > > 2012/3/22 emmanuel segura <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> ha >> scritto: >> >> I think you missed the op monitor operetion you primitive definition >>> >>> Il giorno 22 marzo 2012 11:33, coma <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 >>>> 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 >> 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 > > -- esta es mi vida e me la vivo hasta que dios quiera
_______________________________________________ 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
