[Pacemaker] MySQL-resource won't migrate properly.

Patric Falinder patric.falinder at omg.nu
Tue Dec 28 03:57:01 EST 2010


Hi,

I'm setting up a HA-cluster with Corosync and Pacemaker with DRBD and 
MySQL as resources.
Right now I just want everything to run smoothly before I implement 
STONITH and stuff like that.

The problem I have is when I turn of the "Master"-node everything jumps 
over to the secodary-node just fine except mysqld. I get this error:

mysqld     (lsb:mysql):    Started dbcluster1 (unmanaged) FAILED

Failed actions:
mysqld_stop_0 (node=dbcluster1, call=70, rc=1, status=complete): unknown 
error


And if I run: crm resource cleanup mysqld
it starts running normally again.

I noticed that it migrates over just fine sometimes but then fails when 
it migrates back over again.

Master-node:    dbcluster1
Secondary-node: dbcluster2

This is my configuration:

crm(live)configure# show
node dbcluster1 \
         attributes standby="off"
node dbcluster2
primitive drbd_mysql ocf:linbit:drbd \
         params drbd_resource="dbcluster" \
         op monitor interval="15s"
primitive fs_mysql ocf:heartbeat:Filesystem \
         params device="/dev/drbd/by-res/dbcluster" 
directory="/mnt/mysql/" fstype="ext3"
primitive ip_mysql ocf:heartbeat:IPaddr2 \
         params ip="10.0.0.203" nic="eth1"
primitive mysqld lsb:mysql \
         meta target-role="Started"
group mysql fs_mysql ip_mysql mysqld \
         meta target-role="Started" is-managed="true"
ms ms_drbd_mysql drbd_mysql \
         meta master-max="1" master-node-max="1" clone-max="2" 
clone-node-max="1" notify="true"
location cli-prefer-mysql mysql \
         rule $id="cli-prefer-rule-mysql" inf: #uname eq dbcluster1
colocation mysql_on_drbd inf: mysql ms_drbd_mysql:Master
order mysql_after_drbd inf: ms_drbd_mysql:promote mysql:start
property $id="cib-bootstrap-options" \
         no-quorum-policy="ignore" \
         stonith-enabled="false" \
         expected-quorum-votes="2" \
         dc-version="1.0.9-74392a28b7f31d7ddc86689598bd23114f58978b" \
         cluster-infrastructure="openais" \
         last-lrm-refresh="1293451501"


What is the problem here and how can I fix it?

And also, where can I find documentation about the different resources? 
For example ocf:heartbeat:IPaddr2 and others?

Thanks,
-Patric




More information about the Pacemaker mailing list