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

[Dejan Muhamedagic]

Hi,

On Fri, Mar 12, 2010 at 10:31:15AM -0500, Arthur Franke wrote:
> 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?

Take a look at the logs. corosync should've started cib, but for
some reason couldn't.

Thanks,

Dejan

> 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" \

> _______________________________________________
> Pacemaker mailing list
> Pacemaker at oss.clusterlabs.org
> http://oss.clusterlabs.org/mailman/listinfo/pacemaker