Mysql clustering

[hello1]

Hi All

I am trying to setup a mysql cluster with 2 data nodes and two load balancers. I have followed the same instrauctions given http://www.howtoforge.com/setting-up-a-loadbalanced-mysql-cluster-with-mysql5.1-p3 .

Issues

1. On both load balancers

/usr/sbin/ldirectord ldirectord.cf status
ldirectord stale pid file /var/run/ldirectord.ldirectord.cf.pid for /etc/ha.d/ldirectord.cf
ldirectord is stopped for /etc/ha.d/ldirectord.cf

AND

ipvsadm -L -n
IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddress:Port Scheduler Flags
-> RemoteAddress:Port Forward Weight ActiveConn InActConn
TCP 10.10.10.15:3306 wrr
-> 10.10.10.3:3306 Route 0 0 0
-> 10.10.10.2:3306 Route 0 0 0

Also, getting the following error while starting heartbeat

ldirectord stale pid file /var/run/ldirectord.ldirectord.cf.pid for /etc/ha.d/ldirectord.cf
[ OK ]

What may be the reason? BTW i have verified that failover is happening
when i stop heartbeat on active node.



~Vincent

[zer0]

i'm having exactly the same problem i', desperated, yesterday it worked just fine, pliz help!

[falko]

You might want to try MySQL master-master replication instead of a MySQL cluster. Replication is easier to manage, and with MySQL version 5, a cluster holds all data in memory only!