[Pacemaker] MySQL configuration/error Pacemaker

[Andrew Beekhof]

Possibly a bug in a previous version.
Try 1.0.10 ?

On Wed, Jan 19, 2011 at 3:26 PM, Shurbann Martes <shurbann at gmail.com> wrote:
> 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
> _______________________________________________
> Pacemaker mailing list: Pacemaker at oss.clusterlabs.org
> http://oss.clusterlabs.org/mailman/listinfo/pacemaker
>
> Project Home: http://www.clusterlabs.org
> Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
> Bugs:
> http://developerbugs.linux-foundation.org/enter_bug.cgi?product=Pacemaker
>
>