[Pacemaker] Problem with ocf:heartbeat:mysql

Michal michal at sonet.internetdsl.pl
Sun Aug 16 18:58:05 EDT 2009

When I try to start mysql with config:
primitive drbd1 ocf:heartbeat:drbd \
params drbd_resource=db \
op monitor role=Master interval=59s timeout=30s \
op monitor role=Slave interval=60s timeout=30s

ms ms-drbd1 drbd1 \
meta clone-max=2 master-max="1" master-node-max="1" clone-node-max="1" 
notify=true globally-unique=false

primitive fs0 ocf:heartbeat:Filesystem \
params fstype=reiserfs directory=/home/data device=/dev/drbd1 \
meta migration-threshold="50"

primitive mysql ocf:heartbeat:mysql \
    params binary="/usr/bin/mysqld_safe" config="/etc/mysql/my.cnf" 
socket"/var/run/mysqld/mysqld.sock" \
    pid="/var/run/mysqld/mysqld.pid" op monitor interval="60s" 
timeout="30s" \
    meta target-role="Started"

primitive virtual-ip ocf:heartbeat:IPaddr2 \
params ip="x" broadcast="x" nic="eth0"cidr_netmask="24" \
op monitor interval=21s timeout=5s

group server-mysql fs0 mysql virtual-ip

order ms-drbd1-before-fs0 inf: ms-drbd1:promote fs0:start

colocation res-group-on-ms-drbd1 inf: server-mysql ms-drbd1:Master

location ms-drbd1-master-on-node2 ms-drbd1 \
rule id="ms-drbd1-master-on-node2-rule" role="master" 100: #uname eq node2

everything is ok, but when I add "order virtual-ip-before-mysql inf: 
virtual-ip:promote mysql:start" (to be sure that first start virtual ip 
on which mysql should work) mysql won't start.

crm_mon --one-shot :

Last updated: Mon Aug 17 00:56:56 2009
Stack: openais
Current DC: node2 - partition with quorum
Version: 1.0.4-2ec1d189f9c23093bf9239a980534b661baf782d
2 Nodes configured, 2 expected votes
2 Resources configured.

Online: [ node1 node2 ]

Resource Group: server-mysql
    fs0 (ocf::heartbeat:Filesystem):    Started node2
    mysql       (ocf::heartbeat:mysql): Stopped
    virtual-ip  (ocf::heartbeat:IPaddr2):       Stopped
Master/Slave Set: ms-drbd1
        Masters: [ node2 ]
        Slaves: [ node1 ]

Can anybody help ?

More information about the Pacemaker mailing list