Hi Pacemaker guru's<div><br></div><div>I have installed pacemaker successfully and I have setup a cluster with the following configuration:</div><div><br></div><div><div><font class="Apple-style-span" size="1" face="'courier new', monospace">node tsparxdb01</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace">node tsparxdb02</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace">primitive ClusterIP ocf:heartbeat:IPaddr2 \</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>params ip="192.168.1.254" cidr_netmask="32" \</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>op monitor interval="30s" \</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>meta target-role="Started"</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace">primitive Data ocf:linbit:drbd \</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>params drbd_resource="data" \</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>op monitor interval="60s" \</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>op start interval="0" timeout="240s" \</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>op stop interval="0" timeout="240s"</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace">primitive DataFS ocf:heartbeat:Filesystem \</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>params device="/dev/drbd/by-res/data" directory="/data" fstype="ext4" \</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>op start interval="0" timeout="60s" \</font></div><div>
<font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>op stop interval="0" timeout="60s"</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace">primitive MySQL lsb:mysql \</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>op monitor interval="60s" timeout="120s" \</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>op start interval="20" timeout="120s" \</font></div><div>
<font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>op stop interval="20s" timeout="120s"</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace">group Server-MySQL DataFS MySQL ClusterIP</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace">ms DataMaster Data \</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1" notify="true"</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace">colocation DataFS_on_DataMaster inf: Server-MySQL DataMaster:Master</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace">order DataFS-after-DataMaster inf: DataMaster:promote Server-MySQL:start</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace">property $id="cib-bootstrap-options" \</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>dc-version="1.0.8-042548a451fce8400660f6031f4da6f0223dd5dd" \</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>cluster-infrastructure="openais" \</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>expected-quorum-votes="2" \</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>stonith-enabled="false" \</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>no-quorum-policy="ignore"</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace">rsc_defaults $id="rsc-options" \</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace"><span class="Apple-tab-span" style="white-space:pre"> </span>resource-stickiness="100"</font></div>
</div><div><br></div><div><br></div><div>Everything except the MySQL resource is working correctly (state 1):</div><div><br></div><div><div><div><font class="Apple-style-span" face="'courier new', monospace" size="1">============</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace" size="1">Last updated: Wed Jan 19 10:15:51 2011</font></div><div><font class="Apple-style-span" face="'courier new', monospace" size="1">Stack: openais</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace" size="1">Current DC: tsparxdb02 - partition with quorum</font></div><div><font class="Apple-style-span" face="'courier new', monospace" size="1">Version: 1.0.8-042548a451fce8400660f6031f4da6f0223dd5dd</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace" size="1">2 Nodes configured, 2 expected votes</font></div><div><font class="Apple-style-span" face="'courier new', monospace" size="1">2 Resources configured.</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace" size="1">============</font></div><div><font class="Apple-style-span" face="'courier new', monospace" size="1"><br></font></div><div><font class="Apple-style-span" face="'courier new', monospace" size="1">Online: [ tsparxdb01 tsparxdb02 ]</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace" size="1"><br></font></div><div><font class="Apple-style-span" face="'courier new', monospace" size="1"> Master/Slave Set: DataMaster</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace" size="1"> Masters: [ tsparxdb02 ]</font></div><div><font class="Apple-style-span" face="'courier new', monospace" size="1"> Slaves: [ tsparxdb01 ]</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace" size="1"> Resource Group: Server-MySQL</font></div><div><font class="Apple-style-span" face="'courier new', monospace" size="1"> DataFS (ocf::heartbeat:Filesystem): Started tsparxdb02</font></div>
<div><font class="Apple-style-span" face="'courier new', monospace" size="1"> MySQL (lsb:mysql): Stopped</font></div><div><font class="Apple-style-span" face="'courier new', monospace" size="1"> ClusterIP (ocf::heartbeat:IPaddr2): Started tsparxdb02</font></div>
</div></div><div><br></div><div><br></div><div>The MySQL resource keeps trying to start, but after a while I will see this (state 2):</div><div><br></div><div> <font class="Apple-style-span" size="1" face="'courier new', monospace">============</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace">Last updated: Wed Jan 19 10:17:18 2011</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace">Stack: openais</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace">Current DC: tsparxdb02 - partition with quorum</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace">Version: 1.0.8-042548a451fce8400660f6031f4da6f0223dd5dd</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace">2 Nodes configured, 2 expected votes</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace">2 Resources configured.</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace">============</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace"><br></font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace">Online: [ tsparxdb01 tsparxdb02 ]</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace"><br></font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace"> Master/Slave Set: DataMaster</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace"> Masters: [ tsparxdb02 ]</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace"> Slaves: [ tsparxdb01 ]</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace"> Resource Group: Server-MySQL</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace"> DataFS (ocf::heartbeat:Filesystem): Started tsparxdb02</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace"> MySQL (lsb:mysql): Stopped</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace"> ClusterIP (ocf::heartbeat:IPaddr2): Started tsparxdb02</font></div>
<div><font class="Apple-style-span" size="1" face="'courier new', monospace"><br></font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace">Failed actions:</font></div><div><font class="Apple-style-span" size="1" face="'courier new', monospace"> MySQL_monitor_60000 (node=tsparxdb02, call=62, rc=7, status=complete): not running</font></div>
<div><br></div><div>And then it will go back to the previous state 1.</div><div><br></div><div>I have tried to use both RA ocf:heartbeat:mysql and lather the lsb:mysql.</div><div><br></div><div>My MySQL startup script seems to be LSB compliant since, it gives on all the start/stop/status commands the correct result 0 or 3.</div>
<div><br></div><div>Anyone any idea what could be wrong. Attached you will find the snippet of corosync.log that show when the switch between state 1 and state 2 occurs.</div><div><br></div><div>Hoping you can help me.</div>
<div><br></div><div>Regards,</div><div>Shurbann Martes</div>