it&#39;s done,<br><br>Here is the log from the second node, thank for your help, it very apreciated!:<br><br>Mar 23 13:54:53 node2 attrd: [3102]: info: find_hash_entry: Creating hash entry for last-failure-mysqld<br>Mar 23 13:54:53 node2 attrd: [3102]: info: attrd_perform_update: Delaying operation last-failure-mysqld=&lt;null&gt;: cib not connected<br>
Mar 23 13:54:53 node2 attrd: [3102]: info: find_hash_entry: Creating hash entry for fail-count-mysqld<br>Mar 23 13:54:53 node2 attrd: [3102]: info: attrd_perform_update: Delaying operation fail-count-mysqld=&lt;null&gt;: cib not connected<br>
Mar 23 13:54:53 node2 lrmd: [3101]: debug: on_msg_add_rsc:client [3104] adds resource mysqld<br>Mar 23 13:54:53 node2 crmd: [3104]: info: do_lrm_rsc_op: Performing key=10:46:7:1f6f7a59-8e04-46d9-8a47-4b1ada0e6ea1 op=mysqld_monitor_0 )<br>
Mar 23 13:54:53 node2 lrmd: [3101]: debug: on_msg_perform_op:2359: copying parameters for rsc mysqld<br>Mar 23 13:54:53 node2 lrmd: [3101]: debug: on_msg_perform_op: add an operation operation monitor[6] on ocf::mysql::mysqld for client 3104, its parameters: socket=[/var/lib/mysql/mysql.sock] binary=[/usr/bin/mysqld_safe] group=[mysql] CRM_meta_timeout=[20000] crm_feature_set=[3.0.5] pid=[/var/run/mysqld/mysqld.pid] user=[mysql] config=[/etc/my.cnf] datadir=[/data/mysql/databases]  to the operation list.<br>
Mar 23 13:54:53 node2 lrmd: [3101]: info: rsc:mysqld:6: probe<br>Mar 23 13:54:53 node2 lrmd: [3101]: WARN: Managed mysqld:monitor process 3223 exited with return code 1.<br>Mar 23 13:54:53 node2 lrmd: [3101]: info: RA output: (mysqld:monitor:stderr) /usr/lib/ocf/resource.d//heartbeat/mysql: line 45: /usr/lib/ocf/lib/heartbeat/ocf-shellfuncs: No such file or directory<br>
Mar 23 13:54:53 node2 crmd: [3104]: debug: create_operation_update: do_update_resource: Updating resouce mysqld after complete monitor op (interval=0)<br>Mar 23 13:54:53 node2 crmd: [3104]: info: process_lrm_event: LRM operation mysqld_monitor_0 (call=6, rc=1, cib-update=10, confirmed=true) unknown error<br>
Mar 23 13:54:54 node2 crmd: [3104]: info: do_lrm_rsc_op: Performing key=3:47:0:1f6f7a59-8e04-46d9-8a47-4b1ada0e6ea1 op=mysqld_stop_0 )<br>Mar 23 13:54:54 node2 lrmd: [3101]: debug: on_msg_perform_op: add an operation operation stop[7] on ocf::mysql::mysqld for client 3104, its parameters: crm_feature_set=[3.0.5]  to the operation list.<br>
Mar 23 13:54:54 node2 lrmd: [3101]: info: rsc:mysqld:7: stop<br><span style="color:rgb(255,0,0)">Mar 23 13:54:54 node2 lrmd: [3101]: info: RA output: (mysqld:stop:stderr) /usr/lib/ocf/resource.d//heartbeat/mysql: line 45: /usr/lib/ocf/lib/heartbeat/ocf-shellfuncs: No such file or directory</span> <span style="color:rgb(255,0,0)">-&gt; </span><span style="color:rgb(255,0,0)" id="result_box" class="short_text" lang="en"><span class="hps">I just saw</span> <span class="hps">it</span><span class="">,</span> <span class="hps">I will look</span> <span class="hps">over</span></span><br>
Mar 23 13:54:54 node2 lrmd: [3101]: WARN: Managed mysqld:stop process 3241 exited with return code 1.<br>Mar 23 13:54:54 node2 crmd: [3104]: debug: create_operation_update: do_update_resource: Updating resouce mysqld after complete stop op (interval=0)<br>
Mar 23 13:54:54 node2 crmd: [3104]: info: process_lrm_event: LRM operation mysqld_stop_0 (call=7, rc=1, cib-update=12, confirmed=true) unknown error<br>Mar 23 13:54:54 node2 attrd: [3102]: debug: attrd_local_callback: update message from node1: fail-count-mysqld=INFINITY<br>
Mar 23 13:54:54 node2 attrd: [3102]: debug: attrd_local_callback: New value of fail-count-mysqld is INFINITY<br>Mar 23 13:54:54 node2 attrd: [3102]: info: attrd_trigger_update: Sending flush op to all hosts for: fail-count-mysqld (INFINITY)<br>
Mar 23 13:54:54 node2 attrd: [3102]: info: attrd_perform_update: Delaying operation fail-count-mysqld=INFINITY: cib not connected<br>Mar 23 13:54:54 node2 attrd: [3102]: debug: attrd_local_callback: update message from node1: last-failure-mysqld=1332507294<br>
Mar 23 13:54:54 node2 attrd: [3102]: debug: attrd_local_callback: New value of last-failure-mysqld is 1332507294<br>Mar 23 13:54:54 node2 attrd: [3102]: info: attrd_trigger_update: Sending flush op to all hosts for: last-failure-mysqld (1332507294)<br>
Mar 23 13:54:54 node2 attrd: [3102]: info: attrd_perform_update: Delaying operation last-failure-mysqld=1332507294: cib not connected<br>Mar 23 13:54:54 node2 attrd: [3102]: info: attrd_trigger_update: Sending flush op to all hosts for: last-failure-mysqld (1332507294)<br>
Mar 23 13:54:54 node2 cib: [3100]: debug: cib_process_xpath: cib_query: //cib/status//node_state[@id=&#39;node2&#39;]//transient_attributes//nvpair[@name=&#39;last-failure-mysqld&#39;] does not exist<br>Mar 23 13:54:54 node2 attrd: [3102]: info: attrd_perform_update: Sent update 4: last-failure-mysqld=1332507294<br>
Mar 23 13:54:54 node2 attrd: [3102]: info: attrd_trigger_update: Sending flush op to all hosts for: fail-count-mysqld (INFINITY)<br>Mar 23 13:54:54 node2 cib: [3100]: debug: cib_process_xpath: cib_query: //cib/status//node_state[@id=&#39;node2&#39;]//transient_attributes//nvpair[@name=&#39;fail-count-mysqld&#39;] does not exist<br>
Mar 23 13:54:54 node2 attrd: [3102]: info: attrd_perform_update: Sent update 11: fail-count-mysqld=INFINITY<br>Mar 23 13:54:54 node2 attrd: [3102]: debug: attrd_cib_callback: Update 4 for last-failure-mysqld=1332507294 passed<br>
Mar 23 13:54:54 node2 attrd: [3102]: debug: attrd_cib_callback: Update 11 for fail-count-mysqld=INFINITY passed<br><br><br><br><div class="gmail_quote">2012/3/23 emmanuel segura <span dir="ltr">&lt;<a href="mailto:emi2fast@gmail.com">emi2fast@gmail.com</a>&gt;</span><br>
<blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">The first thing you can do it&#39;s eliminate this &quot;location master-prefer-node-1 Cluster-VIP 25: node1&quot;<br><br>
because you have your virtual in group and i would like to see the log from the second node<br><br>Thanks :-)<br>
<br><div class="gmail_quote">Il giorno 23 marzo 2012 13:42, coma <span dir="ltr">&lt;<a href="mailto:coma.inf@gmail.com" target="_blank">coma.inf@gmail.com</a>&gt;</span> ha scritto:<div><div class="h5"><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">

Thank you for your responses, <br><br>i have fixed my migration-treshold problem with lsb:mysqld ressource (i can see migration-threshold=2 with crm_mon failcounts so its ok) bu failover still doesn&#39;t work when mysql fail (but work fine when node fail or standby).<br>



So i&#39;ve tried with the ocf ressource agent, it&#39;s work fine on my first node but fail on my second node with unknown error. <br><br>crm_mon --failcount:<br><br>Failed actions:<br>    mysqld_monitor_0 (node=node2, call=6, rc=1, status=complete): unknown error<br>



    mysqld_stop_0 (node=node2, call=7, rc=1, status=complete): unknown error<br><br><br>I have exactly the same mysql packages version and configuration on my two nodes (with proper permissions), also corosync/heartbeat and pacemaker are in the same version too:<br>



<br>corosynclib-1.2.7-1.1.el5<br>corosync-1.2.7-1.1.el5<br>pacemaker-libs-1.1.5-1.1.el5<br>pacemaker-1.1.5-1.1.el5<br>heartbeat-3.0.3-2.3.el5<br>heartbeat-libs-3.0.3-2.3.el5<br>heartbeat-debuginfo-3.0.2-2.el5<br><br>So i don&#39;t andersand wy it&#39;s works on one node but not on the second?<br>



<br><br>ressource config:<br><br>primitive mysqld ocf:heartbeat:mysql \<br>        params binary=&quot;/usr/bin/mysqld_safe&quot; config=&quot;/etc/my.cnf&quot; \<br>        user=&quot;mysql&quot; group=&quot;mysql&quot; pid=&quot;/var/run/mysqld/mysqld.pid&quot; \<br>



        datadir=&quot;/data/mysql/databases&quot; socket=&quot;/var/lib/mysql/mysql.sock&quot; \<br>        op start interval=&quot;0&quot; timeout=&quot;120&quot; \<br>        op stop interval=&quot;0&quot; timeout=&quot;120&quot; \<br>



        op monitor interval=&quot;30&quot; timeout=&quot;30&quot; depth=&quot;0&quot; \<br>        target-role=&quot;Started&quot;<br><br><br>And same with (i have created test database / table + grant test user on it):<br>



<br>primitive mysqld ocf:heartbeat:mysql \<br>        params binary=&quot;/usr/bin/mysqld_safe&quot; config=&quot;/etc/my.cnf&quot; \<br>        datadir=&quot;/data/mysql/databases&quot; user=&quot;mysql&quot; \<br>        pid=&quot;/var/run/mysqld/mysqld.pid&quot; socket=&quot;/var/lib/mysql/mysql.sock&quot; \<br>



        test_passwd=&quot;test&quot; test_table=&quot;Cluster.dbcheck&quot; test_user=&quot;test&quot; \<br>        op start interval=&quot;0&quot; timeout=&quot;120&quot; \<br>        op stop interval=&quot;0&quot; timeout=&quot;120&quot; \<br>



        op monitor interval=&quot;30s&quot; timeout=&quot;30s&quot; OCF_CHECK_LEVEL=&quot;1&quot; \<br>        meta migration-threshold=&quot;3&quot; target-role=&quot;Started&quot;<br><br><br>Full config:<br><br>node node2 \<br>



        attributes standby=&quot;off&quot;<br>node node1 \<br>        attributes standby=&quot;off&quot;<br>primitive Cluster-VIP ocf:heartbeat:IPaddr2 \<br>        params ip=&quot;x.x.x.x&quot; broadcast=&quot;x.x.x.x&quot; nic=&quot;eth0&quot; cidr_netmask=&quot;21&quot; iflabel=&quot;VIP1&quot; \<br>



        op monitor interval=&quot;10s&quot; timeout=&quot;20s&quot; \<br>        meta is-managed=&quot;true&quot;<br>primitive datavg ocf:heartbeat:LVM \<br>        params volgrpname=&quot;datavg&quot; exclusive=&quot;true&quot; \<br>



        op start interval=&quot;0&quot; timeout=&quot;30&quot; \<br>        op stop interval=&quot;0&quot; timeout=&quot;30&quot;<br>primitive drbd_mysql ocf:linbit:drbd \<br>        params drbd_resource=&quot;drbd-mysql&quot; \<br>



        op monitor interval=&quot;15s&quot;<br>primitive fs_mysql ocf:heartbeat:Filesystem \<br>        params device=&quot;/dev/datavg/data&quot; directory=&quot;/data&quot; fstype=&quot;ext3&quot;<br>primitive mysqld ocf:heartbeat:mysql \<br>



        params binary=&quot;/usr/bin/mysqld_safe&quot; config=&quot;/etc/my.cnf&quot; user=&quot;mysql&quot; group=&quot;mysql&quot; pid=&quot;/var/run/mysqld/mysqld.pid&quot; datadir=&quot;/data/mysql/databases&quot; socket=&quot;/var/lib/mysql/mysql.sock&quot; \<br>



        op start interval=&quot;0&quot; timeout=&quot;120&quot; \<br>        op stop interval=&quot;0&quot; timeout=&quot;120&quot; \<br>        op monitor interval=&quot;30&quot; timeout=&quot;30&quot; depth=&quot;0&quot;<br>



group mysql datavg fs_mysql Cluster-VIP mysqld<br>ms ms_drbd_mysql drbd_mysql \<br>        meta master-max=&quot;1&quot; master-node-max=&quot;1&quot; clone-max=&quot;2&quot; clone-node-max=&quot;1&quot; notify=&quot;true&quot;<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=&quot;cib-bootstrap-options&quot; \<br>



        dc-version=&quot;1.1.5-1.1.el5-01e86afaaa6d4a8c4836f68df80ababd6ca3902f&quot; \<br>        cluster-infrastructure=&quot;openais&quot; \<br>        expected-quorum-votes=&quot;2&quot; \<br>        stonith-enabled=&quot;false&quot; \<br>



        no-quorum-policy=&quot;ignore&quot; \<br>        last-lrm-refresh=&quot;1332504626&quot;<br>rsc_defaults $id=&quot;rsc-options&quot; \<br>        resource-stickiness=&quot;100&quot;<br><br><br><br><br><br><div class="gmail_quote">



2012/3/22 Andreas Kurz <span dir="ltr">&lt;<a href="mailto:andreas@hastexo.com" target="_blank">andreas@hastexo.com</a>&gt;</span><br><blockquote class="gmail_quote" style="margin:0 0 0 .8ex;border-left:1px #ccc solid;padding-left:1ex">


<div>
On 03/22/2012 03:23 PM, coma wrote:<br>
&gt; Thank you for your responses,<br>
&gt;<br>
&gt; I have added the migration-treshold on my mysqld ressource, when i kill<br>
&gt; or manually stop mysql on one node, there is not failover on the second<br>
&gt; node.<br>
&gt; Also, when i look crm_mon --failcounts, i can see &quot;mysqld:<br>
&gt; migration-threshold=1000000 fail-count=1000000&quot;, so i don&quot;t anderstand<br>
&gt; why migration-threshold not equal 2?<br>
&gt;<br>
&gt; Migration summary:<br>
&gt; * Node node1:<br>
&gt;    mysqld: migration-threshold=1000000 fail-count=1000000<br>
&gt; * Node node2:<br>
&gt;<br>
&gt; Failed actions:<br>
&gt;     mysqld_monitor_10000 (node=node1, call=90, rc=7, status=complete):<br>
&gt; not running<br>
&gt;     mysqld_stop_0 (node=node1, call=93, rc=1, status=complete): unknown<br>
&gt; error<br>
<br>
</div>The lsb init script you are using seems to be not LSB compliant ...<br>
looks like it returns an error on stopping an already stopped mysql.<br>
<br>
<a href="http://clusterlabs.org/doc/en-US/Pacemaker/1.1/html-single/Pacemaker_Explained/index.html#ap-lsb" target="_blank">http://clusterlabs.org/doc/en-US/Pacemaker/1.1/html-single/Pacemaker_Explained/index.html#ap-lsb</a><br>




<br>
Fix the script ... or better use the ocf resource agent.<br>
<div><br>
Regards,<br>
Andreas<br>
<br>
--<br>
Need help with Pacemaker?<br>
<a href="http://www.hastexo.com/now" target="_blank">http://www.hastexo.com/now</a><br>
<br>
&gt;<br>
&gt;<br>
&gt;<br>
</div><div><div>&gt; configuration:<br>
&gt;<br>
&gt; node node1 \<br>
&gt;         attributes standby=&quot;off&quot;<br>
&gt; node node2 \<br>
&gt;         attributes standby=&quot;off&quot;<br>
&gt; primitive Cluster-VIP ocf:heartbeat:IPaddr2 \<br>
&gt;         params ip=&quot;x.x.x.x&quot; broadcast=&quot;x.x.x.x&quot; nic=&quot;eth0&quot;<br>
&gt; cidr_netmask=&quot;21&quot; iflabel=&quot;VIP1&quot; \<br>
&gt;         op monitor interval=&quot;10s&quot; timeout=&quot;20s&quot; \<br>
&gt;         meta is-managed=&quot;true&quot;<br>
&gt; primitive datavg ocf:heartbeat:LVM \<br>
&gt;         params volgrpname=&quot;datavg&quot; exclusive=&quot;true&quot; \<br>
&gt;         op start interval=&quot;0&quot; timeout=&quot;30&quot; \<br>
&gt;         op stop interval=&quot;0&quot; timeout=&quot;30&quot;<br>
&gt; primitive drbd_mysql ocf:linbit:drbd \<br>
&gt;         params drbd_resource=&quot;drbd-mysql&quot; \<br>
&gt;         op monitor interval=&quot;15s&quot;<br>
&gt; primitive fs_mysql ocf:heartbeat:Filesystem \<br>
&gt;         params device=&quot;/dev/datavg/data&quot; directory=&quot;/data&quot; fstype=&quot;ext3&quot;<br>
&gt; primitive mysqld lsb:mysqld \<br>
&gt;         op monitor interval=&quot;10s&quot; timeout=&quot;30s&quot; \<br>
&gt;         op start interval=&quot;0&quot; timeout=&quot;120&quot; \<br>
&gt;         op stop interval=&quot;0&quot; timeout=&quot;120&quot; \<br>
&gt;         meta target-role=&quot;Started&quot; migration-threshold=&quot;2&quot;<br>
&gt; failure-timeout=&quot;20s&quot;<br>
&gt; group mysql datavg fs_mysql Cluster-VIP mysqld<br>
&gt; ms ms_drbd_mysql drbd_mysql \<br>
&gt;         meta master-max=&quot;1&quot; master-node-max=&quot;1&quot; clone-max=&quot;2&quot;<br>
&gt; clone-node-max=&quot;1&quot; notify=&quot;true&quot;<br>
&gt; location master-prefer-node-1 Cluster-VIP 25: node1<br>
&gt; colocation mysql_on_drbd inf: mysql ms_drbd_mysql:Master<br>
&gt; order mysql_after_drbd inf: ms_drbd_mysql:promote mysql:start<br>
&gt; property $id=&quot;cib-bootstrap-options&quot; \<br>
&gt;<br>
&gt; dc-version=&quot;1.1.5-1.1.el5-01e86afaaa6d4a8c4836f68df80ababd6ca3902f&quot; \<br>
&gt;         cluster-infrastructure=&quot;openais&quot; \<br>
&gt;         expected-quorum-votes=&quot;2&quot; \<br>
&gt;         stonith-enabled=&quot;false&quot; \<br>
&gt;         no-quorum-policy=&quot;ignore&quot; \<br>
&gt;         last-lrm-refresh=&quot;1332425337&quot;<br>
&gt; rsc_defaults $id=&quot;rsc-options&quot; \<br>
&gt;         resource-stickiness=&quot;100&quot;<br>
&gt;<br>
&gt;<br>
&gt;<br>
</div></div>&gt; 2012/3/22 Andreas Kurz &lt;<a href="mailto:andreas@hastexo.com" target="_blank">andreas@hastexo.com</a> &lt;mailto:<a href="mailto:andreas@hastexo.com" target="_blank">andreas@hastexo.com</a>&gt;&gt;<br>


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