[Pacemaker] Issue getting mysql to start up with HeartBeat/Pacemaker

[Michael Szilagyi]

I've recently started taking a look at pacemaker to get some kind of HA in a
mysql test environment.  The grouping has a ocf:heartbeat:IPaddr2 and a
ocf:heartbeat:mysql monitor in it.  The IP monitor spins up fine and
properly jumps around the cluster depending on which node is active.  I'm
having issues getting mysql to spin up, however.

Basically (so far) I've:

Here is the definitions you can view when doing a crm configure edit:

primitive p_novaSQL_IP ocf:heartbeat:IPaddr2 \
        params ip="172.17.0.96" nic="eth0" \
        op monitor interval="10s"
primitive p_mysql ocf:heartbeat:mysql \
        params binary="/usr/bin/mysqld_safe" config="/etc/mysql/my.cnf"
socket="/var/run/mysqld/mysock.sock" datadir="/var/lib/mysql" \
        op monitor interval="10s" timeout="30s" \
        op start interval="0" timeout="120" \
        op stop interval="0" timeout="120" \
        meta target-role="Started"
group g_sqlMonitor p_sql_IP p_mysql
property $id="cib-bootstrap-options" \
        dc-version="1.0.9-da7075976b5ff0bee71074385f8fd02f296ec8a3" \
        cluster-infrastructure="Heartbeat" \
        stonith-enabled="false" \
        last-lrm-refresh="1312926142" \
        no-quorum-policy="ignore"


Error reported from crm_mon:
p_novasql_start_0 (node=sql1, call=74, rc=-2, status=Timed Out): unknown
exec error

Error reported from sql (/var/log/mysql/error.log)
110809 14:57:22 [ERROR] Can't start server : Bind on unix socket: Permission
denied
110809 14:57:22 [ERROR] Do you already have another mysqld server running on
socket: /var/run/mysqld/mysock.sock ?
110809 14:57:22 [ERROR] Aborting


I've dug around but can't seem to find a resolution to this error.  I've
looked at a couple quick & dirty examples for getting mysql up and running
with Pacemaker and the above seems to match with the config data.  Any
ideas/suggestions would be greatly appreciated.

-Mike.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.clusterlabs.org/pipermail/pacemaker/attachments/20110809/02389a06/attachment-0002.html>