if you set migration-thresold=2 after two operation fail-count it's reached your resource trys to switch to an other node<br><br><a href="http://www.clusterlabs.org/doc/en-US/Pacemaker/1.0/html/Pacemaker_Explained/s-failure-migration.html">http://www.clusterlabs.org/doc/en-US/Pacemaker/1.0/html/Pacemaker_Explained/s-failure-migration.html</a><br>
<br><br><br><div class="gmail_quote">Il giorno 22 marzo 2012 13:51, coma <span dir="ltr"><<a href="mailto:coma.inf@gmail.com">coma.inf@gmail.com</a>></span> ha scritto:<br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
<span lang="en"><span>Ah</span> <span>yes</span> <span>thank you</span><span></span><span>,</span> <span>the service status</span> <span>mysql</span> <span>is</span> <span>now</span> <span>monitored</span><span>,</span> <span>but the</span> <span>failover</span> <span>is not performed</span><span>?</span></span><div class="HOEnZb">
<div class="h5"><br>
<br><br><br><div class="gmail_quote">2012/3/22 emmanuel segura <span dir="ltr"><<a href="mailto:emi2fast@gmail.com" target="_blank">emi2fast@gmail.com</a>></span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">
sorry <br>I think you missed the op monitor operetion in your primitive definition<br><br><br><br><div class="gmail_quote">Il giorno 22 marzo 2012 11:52, emmanuel segura <span dir="ltr"><<a href="mailto:emi2fast@gmail.com" target="_blank">emi2fast@gmail.com</a>></span> ha scritto:<div>
<div><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">I think you missed the op monitor operetion you primitive definition<br><br><div class="gmail_quote">Il giorno 22 marzo 2012 11:33, coma <span dir="ltr"><<a href="mailto:coma.inf@gmail.com" target="_blank">coma.inf@gmail.com</a>></span> ha scritto:<br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex"><div><div>Hello,<br><br>I have a question about mysql service monitoring into a MySQL HA cluster with pacemaker and DRBD, <br>
I have set up a configuration to allow a failover between two nodes, it work fine when a node is offline (or standby), <span lang="en"><span>but i want to know if it is</span> <span>possible to monitor</span> <span>the mysql service</span> <span></span></span>to perform a failover if mysql is stopped or unavailable?<br>
<br>Thank you in advance for any response.<br><br>My crm configuration:<br><br>node node1 \<br> attributes standby="off"<br>node node2 \<br> attributes standby="off"<br>primitive Cluster-VIP ocf:heartbeat:IPaddr2 \<br>
params ip="x.x.x.x" broadcast="x.x.x.x" nic="eth0" cidr_netmask="21" iflabel="VIP1" \<br> op monitor interval="10s" timeout="20s" \<br>
meta is-managed="true"<br>
primitive datavg ocf:heartbeat:LVM \<br> params volgrpname="datavg" exclusive="true" \<br> op start interval="0" timeout="30" \<br> op stop interval="0" timeout="30"<br>
primitive drbd_mysql ocf:linbit:drbd \<br> params drbd_resource="drbd-mysql" \<br> op monitor interval="15s"<br>primitive fs_mysql ocf:heartbeat:Filesystem \<br> params device="/dev/datavg/data" directory="/data" fstype="ext3"<br>
primitive mysqld lsb:mysqld<br>group mysql datavg fs_mysql Cluster-VIP mysqld<br>ms ms_drbd_mysql drbd_mysql \<br> meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1" notify="true"<br>
location master-prefer-node-1 Cluster-VIP 25: node1<br>colocation mysql_on_drbd inf: mysql ms_drbd_mysql:Master<br>order mysql_after_drbd inf: ms_drbd_mysql:promote mysql:start<br>property $id="cib-bootstrap-options" \<br>
dc-version="1.1.5-1.1.el5-01e86afaaa6d4a8c4836f68df80ababd6ca3902f" \<br> cluster-infrastructure="openais" \<br> expected-quorum-votes="2" \<br> stonith-enabled="false" \<br>
no-quorum-policy="ignore" \<br> last-lrm-refresh="1332254494"<br>rsc_defaults $id="rsc-options" \<br> resource-stickiness="100"<br><br>
<br></div></div>_______________________________________________<br>
Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org" target="_blank">Pacemaker@oss.clusterlabs.org</a><br>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a href="http://bugs.clusterlabs.org" target="_blank">http://bugs.clusterlabs.org</a><br>
<br></blockquote></div><span><font color="#888888"><br><br clear="all"><br>-- <br>esta es mi vida e me la vivo hasta que dios quiera<br>
</font></span></blockquote></div></div></div><div><div><br><br clear="all"><br>-- <br>esta es mi vida e me la vivo hasta que dios quiera<br>
</div></div><br>_______________________________________________<br>
Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org" target="_blank">Pacemaker@oss.clusterlabs.org</a><br>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a href="http://bugs.clusterlabs.org" target="_blank">http://bugs.clusterlabs.org</a><br>
<br></blockquote></div><br>
</div></div><br>_______________________________________________<br>
Pacemaker mailing list: <a href="mailto:Pacemaker@oss.clusterlabs.org">Pacemaker@oss.clusterlabs.org</a><br>
<a href="http://oss.clusterlabs.org/mailman/listinfo/pacemaker" target="_blank">http://oss.clusterlabs.org/mailman/listinfo/pacemaker</a><br>
<br>
Project Home: <a href="http://www.clusterlabs.org" target="_blank">http://www.clusterlabs.org</a><br>
Getting started: <a href="http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf" target="_blank">http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf</a><br>
Bugs: <a href="http://bugs.clusterlabs.org" target="_blank">http://bugs.clusterlabs.org</a><br>
<br></blockquote></div><br><br clear="all"><br>-- <br>esta es mi vida e me la vivo hasta que dios quiera<br>