View Single Post
  #1  
Old 10th January 2007, 12:47
samu samu is offline
Junior Member
 
Join Date: Jan 2007
Posts: 4
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySQL Cluster HOWTO - Cannot load Virtual IP address

Hi, I followed the MySQL Cluster HOWTO (many compliments to the author!).
The cluster nodes and the management node are set up correctly in fact from ndb_mgmd I'm able to see all the nodes connected to the cluster manager.

I'm running Ubuntu 6.10 and I installed via apt-get the packages heartbeat-2 and ldirectord-2 from Ubuntu repositories (I need version 2 because with the packages available from ultramonkeys my system hangs).

My problem comes when I try to configure the load balancer, my system doesn't show the virtual IP address when I run: ip addr sh.

My configuration files are listed below:

ha.cf
*******************************
logfacility local0
auto_failback off
bcast eth0
mcast eth0 225.0.0.1 694 1 0
node ron
respawn hacluster /usr/lib/heartbeat/ipfail
apiauth ipfail gid=haclient uid=hacluster

haresources
*********************************
ron \
LVSSyncDaemonSwap::master \
ldirectord::ldirectord.cf \
IPaddr2::192.168.1.65/24/eth0/192.168.1.255

authkeys
*********************************
auth 3
3 md5 myauthpassword

ldirectord.cf
*********************************
# Global Directives
checktimeout=10
checkinterval=2
autoreload=no
logfile="local0"
quiescent=yes

virtual=192.168.1.65:3306
service=mysql
real=192.168.0.62:3306 gate
real=192.168.0.100:3306 gate
checktype=negotiate
login="root"
passwd="mysqlrootpassword"
database="ldirectord"
request="SELECT * FROM connectioncheck"
scheduler=wrr

I also set in /etc/sysctl.conf, net.ipv4.ip_forward=1.

I have the cluster manager on 192.168.1.61 and I want the virtual IP to be 192.168.1.65.
But I'm not able to see any virtual IP address.

#ip addr sh
...
2: eth0: <BROADCAST,MULTICAST,UP,10000> mtu 1500 qdisc pfifo_fast qlen 1000
link/ether 00:02:3f:be:13:95 brd ff:ff:ff:ff:ff:ff
inet 192.168.1.61/24 brd 192.168.1.255 scope global eth0
inet6 fe80::202:3fff:febe:1395/64 scope link
valid_lft forever preferred_lft forever


Someone has any ideas of where is the problem?

Thanks for any help,
Samuele.
Reply With Quote
Sponsored Links