Go Back   HowtoForge Forums | HowtoForge - Linux Howtos and Tutorials > Linux Forums > HOWTO-Related Questions

Do you like HowtoForge? Please consider supporting us by becoming a subscriber.
 
 
Thread Tools Display Modes
Prev Previous Post   Next Post Next
  #1  
Old 10th January 2007, 11: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
 

Bookmarks

Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is Off

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Mysql cluster issues. elguapo Server Operation 2 2nd November 2006 12:46
MySQL Cluster On FC5 : error while unpacking from engine asyadiqin HOWTO-Related Questions 7 28th October 2006 17:37
Load-Balanced MySQL Cluster Error with Cluster stylez HOWTO-Related Questions 12 1st October 2006 04:55
Problem with Virtual Users And Domains With Postfix, Courier And MySQL Howto fenix Server Operation 4 11th March 2006 02:53
postfix config jmroth Installation/Configuration 6 18th September 2005 15:58


All times are GMT +2. The time now is 11:43.


Powered by vBulletin® Version 3.8.7
Copyright ©2000 - 2014, vBulletin Solutions, Inc.