[Pacemaker] mysql resource can't start

[Li, Chen]

For addition,
I have already tried to start resource in crm shell.
Nothing happened, and there is no log in mysql.

Thanks.
-Chen



在 2013-5-9，17:10，"Li, Chen" <chen.li at intel.com<mailto:chen.li at intel.com>> 写道：

Hi list,

I’m a new user to pacemaker.
I’m trying to using pacemaker to set up a HA for mysql in active/slave mode.
My configuration is:

node api01
node api02
primitive p_drbd_mysql ocf:linbit:drbd \
        params drbd_resource="mysql" \
        op start interval="0" timeout="90s" \
        op stop interval="0" timeout="180s" \
        op promote interval="0" timeout="180s" \
        op demote interval="0" timeout="180s" \
        op monitor interval="30s" role="Slave" \
        op monitor interval="29s" role="Master"
primitive p_fs_mysql ocf:heartbeat:Filesystem \
        params device="/dev/drbd/by-res/mysql" directory="/var/lib/mysql" fstype="ext4" options="relatime" \
        op start interval="0" timeout="60s" \
        op stop interval="0" timeout="180s" \
        op monitor interval="60s" timeout="60s"
primitive p_ip_mysql ocf:heartbeat:IPaddr2 \
        params ip="192.168.11.13" cidr_netmask="16" \
        op monitor interval="30s" \
        meta is-managed="true"
primitive p_mysql ocf:heartbeat:mysql \
        params additional_parameters="--bind-address=192.168.11.13" config="/etc/mysql/my.cnf" pid="/var/run/mysqld/mysqld.pid" socket="/var/run/mysqld/mysqld.sock" log="/var/log/mysql/mysqld.log" \
        op monitor interval="20s" timeout="10s" \
        op start interval="0" timeout="120s" \
        op stop interval="0" timeout="120s" \
        meta is-managed="true"
group g_mysql p_ip_mysql p_fs_mysql p_mysql \
        meta target-role="Started" is-managed="true"
ms ms_drbd_mysql p_drbd_mysql \
        meta notify="true" clone-max="2"
colocation c_mysql_on_drbd inf: g_mysql ms_drbd_mysql:Master
order o_drbd_before_mysql inf: ms_drbd_mysql:promote g_mysql:start
property $id="cib-bootstrap-options" \
        dc-version="1.1.6-9971ebba4494012a93c03b40a2c58ec0eb60f50c" \
        cluster-infrastructure="openais" \
        expected-quorum-votes="2" \
        stonith-enabled="false" \
        no-quorum-policy="ignore" \
        maintenance-mode="true" \
        last-lrm-refresh="1368118902" \
        stop-all-resources="false"



But, the resource p_mysql  never start. And all resource have a “unmanaged” mark in status:

crm resource status
Resource Group: g_mysql
     p_ip_mysql (ocf::heartbeat:IPaddr2) Started  (unmanaged)
     p_fs_mysql (ocf::heartbeat:Filesystem) Started  (unmanaged)
     p_mysql    (ocf::heartbeat:mysql) Stopped  (unmanaged)
Master/Slave Set: ms_drbd_mysql [p_drbd_mysql] (unmanaged)
     p_drbd_mysql:0     (ocf::linbit:drbd) Master  (unmanaged)
     p_drbd_mysql:1     (ocf::linbit:drbd) Slave  (unmanaged)
Anyone can help me ?


Thanks.
-chen