Hi,<br><br>I'm having an issue with pacemaker, mysql and drbd that I'm not sure how to resolve and hoping for an idea how to go about it.<br><br>When i do crm_mon, i get:<br><br>[root@staging1 log]# crm_mon -1<br>============<br>
Last updated: Fri Sep 23 13:31:05 2011<br>Stack: openais<br>Current DC: staging1 - partition with quorum<br>Version: 1.1.2-f059ec7ced7a86f18e5490b67ebf4a0b963bccfe<br>2 Nodes configured, 2 expected votes<br>3 Resources configured.<br>
============<br><br>Node staging2: UNCLEAN (online)<br>Online: [ staging1 ]<br><br><br>Failed actions:<br> drbd_mysql_monitor_0 (node=staging1, call=16, rc=6, status=complete): not configured<br> mysqld_monitor_0 (node=staging2, call=5, rc=1, status=complete): unknown error<br>
mysqld_stop_0 (node=staging2, call=7, rc=4, status=complete): insufficient privileges<br><br><br>In /var/log/messages, i have the following:<br><br>Sep 23 13:33:05 staging1 pengine: [14140]: ERROR: unpack_rsc_op: Hard error - drbd_mysql_monitor_0 failed with rc=6: Preventing drbd_mysql from re-starting anywhere in the cluster<br>
<br>How i can further troubleshoot those errors?<br><br>Also, for the secondary node, should there be a mysql/mysqld script in my /etc/init.d ? Articles suggest MySQL data and config should only be on the primary node so i guess I'm not sure i understand what the secondary node should have.<br>
<br>My resource file:<br><br>resource mysqld {<br><br>protocol C;<br><br>startup { wfc-timeout 0; degr-wfc-timeout 120; }<br><br>disk { on-io-error detach; }<br><br><br>on staging1 {<br><br>device /dev/drbd0;<br><br>disk /dev/vg_staging1/lv_data;<br>
<br>meta-disk internal;<br><br>address <a href="http://10.10.20.1:7788">10.10.20.1:7788</a>;<br><br>}<br><br>on staging2 {<br><br>device /dev/drbd0;<br><br>disk /dev/vg_staging2/lv_data;<br><br>meta-disk internal;<br><br>
address <a href="http://10.10.20.2:7788">10.10.20.2:7788</a>;<br><br>}<br><br>}<br><br>My crm configuration:<br><br>crm(live)configure# show<br>node staging1<br>node staging2<br>primitive drbd_mysql ocf:linbit:drbd \<br> params drbd_resource="mysqld" \<br>
op monitor interval="15s"<br>primitive fs_mysql ocf:heartbeat:Filesystem \<br> params device="/dev/drbd/by-res/mysql" directory="/opt/data/mysql/data/mysql" fstype="ext4"<br>primitive ip_mysql ocf:heartbeat:IPaddr2 \<br>
params ip="10.10.10.31" nic="eth0"<br>primitive ipmi stonith:fence_ipmilan \<br> op monitor interval="120s" \<br> params passwd="xxxxxxxx" \<br> meta target-role="Stopped"<br>
primitive mysqld lsb:mysqld<br>group mysql fs_mysql ip_mysql 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>
property $id="cib-bootstrap-options" \<br> dc-version="1.1.2-f059ec7ced7a86f18e5490b67ebf4a0b963bccfe" \<br> cluster-infrastructure="openais" \<br> expected-quorum-votes="2" \<br>
stonith-enabled="true" \<br> last-lrm-refresh="1316788450"<br><br>Thanks,<br>Charles<br>