[Pacemaker] MySQL configuration/error Pacemaker

Shurbann Martes shurbann at gmail.com
Wed Jan 19 14:26:29 UTC 2011


Hi Pacemaker guru's

I have installed pacemaker successfully and I have setup a cluster with the
following configuration:

node tsparxdb01
node tsparxdb02
primitive ClusterIP ocf:heartbeat:IPaddr2 \
params ip="192.168.1.254" cidr_netmask="32" \
op monitor interval="30s" \
meta target-role="Started"
primitive Data ocf:linbit:drbd \
params drbd_resource="data" \
op monitor interval="60s" \
op start interval="0" timeout="240s" \
op stop interval="0" timeout="240s"
primitive DataFS ocf:heartbeat:Filesystem \
params device="/dev/drbd/by-res/data" directory="/data" fstype="ext4" \
op start interval="0" timeout="60s" \
op stop interval="0" timeout="60s"
primitive MySQL lsb:mysql \
op monitor interval="60s" timeout="120s" \
op start interval="20" timeout="120s" \
op stop interval="20s" timeout="120s"
group Server-MySQL DataFS MySQL ClusterIP
ms DataMaster Data \
meta master-max="1" master-node-max="1" clone-max="2" clone-node-max="1"
notify="true"
colocation DataFS_on_DataMaster inf: Server-MySQL DataMaster:Master
order DataFS-after-DataMaster inf: DataMaster:promote Server-MySQL:start
property $id="cib-bootstrap-options" \
dc-version="1.0.8-042548a451fce8400660f6031f4da6f0223dd5dd" \
cluster-infrastructure="openais" \
expected-quorum-votes="2" \
stonith-enabled="false" \
no-quorum-policy="ignore"
rsc_defaults $id="rsc-options" \
resource-stickiness="100"


Everything except the MySQL resource is working correctly (state 1):

============
Last updated: Wed Jan 19 10:15:51 2011
Stack: openais
Current DC: tsparxdb02 - partition with quorum
Version: 1.0.8-042548a451fce8400660f6031f4da6f0223dd5dd
2 Nodes configured, 2 expected votes
2 Resources configured.
============

Online: [ tsparxdb01 tsparxdb02 ]

 Master/Slave Set: DataMaster
     Masters: [ tsparxdb02 ]
     Slaves: [ tsparxdb01 ]
 Resource Group: Server-MySQL
     DataFS     (ocf::heartbeat:Filesystem):    Started tsparxdb02
     MySQL      (lsb:mysql):    Stopped
     ClusterIP  (ocf::heartbeat:IPaddr2):       Started tsparxdb02


The MySQL resource keeps trying to start, but after a while I will see this
(state 2):

 ============
Last updated: Wed Jan 19 10:17:18 2011
Stack: openais
Current DC: tsparxdb02 - partition with quorum
Version: 1.0.8-042548a451fce8400660f6031f4da6f0223dd5dd
2 Nodes configured, 2 expected votes
2 Resources configured.
============

Online: [ tsparxdb01 tsparxdb02 ]

 Master/Slave Set: DataMaster
     Masters: [ tsparxdb02 ]
     Slaves: [ tsparxdb01 ]
 Resource Group: Server-MySQL
     DataFS     (ocf::heartbeat:Filesystem):    Started tsparxdb02
     MySQL      (lsb:mysql):    Stopped
     ClusterIP  (ocf::heartbeat:IPaddr2):       Started tsparxdb02

Failed actions:
    MySQL_monitor_60000 (node=tsparxdb02, call=62, rc=7, status=complete):
not running

And then it will go back to the previous state 1.

I have tried to use both RA ocf:heartbeat:mysql and lather the lsb:mysql.

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.

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.

Hoping you can help me.

Regards,
Shurbann Martes
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20110119/c1430995/attachment-0001.html>
-------------- next part --------------
A non-text attachment was scrubbed...
Name: corosync.log
Type: text/x-log
Size: 29194 bytes
Desc: not available
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20110119/c1430995/attachment-0003.bin>


More information about the Pacemaker mailing list