[Pacemaker] MySQL Replication Setup: Can't connect to CIB after reboot

Arthur Franke arthurjfranke at gmail.com
Fri Mar 12 15:31:15 UTC 2010


Hi,

Complete Pacemaker newbie here, etc., etc...  Any advice is appreciated.

I'm trying to get a cluster running with a master/master MySQL replication
configuration.  I've been following a combination of the Debian Lenny HowTo
and the DRBD MySQL Howto as guides.

I had the two nodes up and running, but when I rebooted a node, it would no
longer connect to the cluster.  A ps aux call shows that corosync is still
running, but attempting "crm node online" or even "crm_mon -1" both return
the message "Error signing on to the CIB service: connection failed".
Having now restarted both nodes, this is happening on both.  Below is the
configuration that I use.

Any suggestions for how to debug this?  or obvious things that I might be
doing wrong?

Thanks.

-Arthur

primitive mysql_ip ocf:heartbeat:IPaddr2 \
      params ip="10.44.1.120" nic="eth0"
primitive mysqlserver ocf:heartbeat:mysql \
      params binary="/usr/bin/mysqld_safe" config="/etc/mysql/my.cnf"
datadir="/var/lib/mysql" user="mysql" pid="/var/lib/mysql/mysql.pid"
socket="/var/run/mysql/mysql.sock" test_passwd="haha"
test_table="ldirectord.connectioncheck" test_user="replicant" \
      op monitor interval="20s" timeout="10s" \
      meta migration-threshold="10" target-role="Started"
group mysql-resources mysql_ip mysqlserver
location prefer-pop mysql-resources \
     rule $id="prefer-pop-rule" 100: #uname eq pop
property no-quorum-policy="ignore"
property $id="cib-bootstrap-options" \
        dc-version="1.0.7-54d7869bfe3691eb723b1d47810e5585d8246b58" \
    cluster-infrastructure="openais" \
    stonith-enabled="false" \
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.clusterlabs.org/pipermail/pacemaker/attachments/20100312/806238d4/attachment-0002.html>


More information about the Pacemaker mailing list