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.
Reply
 
Thread Tools Display Modes
  #1  
Old 6th October 2006, 17:04
MvdB MvdB is offline
Junior Member
 
Join Date: Oct 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default problem with load-balanced mysql cluster

I'm having some problem with configuren load-balanced mysql-cluster setup.

I've followed the setps in How to set up A load-balanced Mysql Cluster.

The first problem is with hearbeat. A get te following error:
Code:
heartbeat: 2006/10/06_16:00:01 ERROR: mcast [eth0] bad addr [255.0.0.1]
heartbeat: 2006/10/06_16:00:01 ERROR: Illegal directive [respawm] in /etc/ha.d/ha.cf
heartbeat: 2006/10/06_16:00:01 ERROR: Heartbeat not started: configuration error.
heartbeat: 2006/10/06_16:00:01 ERROR: Configuration error, heartbeat not started.
when I comment these lines out in the ha.cf heartbeat will start and it looks like the load-balancers are running and all tests in the how-to are showing the right response.
But when I want te connect from a other mahine with a mysql-client, I can't connect. After a portscan on the virtual ip of the loadbalancer I see that te mysql port is filtered (I'm not using a firewall).

I've really no idea what is wrong? And if the first problem affects the second problem that I can't connect.

This is my ha.cf file:
Code:
logfacility     local0
bcast           eth0
mcast eth0 255.0.0.1 694 1 0
auto_failback   off
node            loadb1
node            loadb2
respawm hacluster /usr/lib/heartbeat/ipfail
apiauth ipfail gid=haclient uid=hacluster
Some help will be very nice!
Reply With Quote
Sponsored Links
  #2  
Old 7th October 2006, 13:54
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Quote:
Originally Posted by MvdB
Code:
logfacility     local0
bcast           eth0
mcast eth0 255.0.0.1 694 1 0
auto_failback   off
node            loadb1
node            loadb2
respawm hacluster /usr/lib/heartbeat/ipfail
apiauth ipfail gid=haclient uid=hacluster
You have a typo there. It must be
Code:
respawn hacluster /usr/lib/heartbeat/ipfail
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #3  
Old 11th October 2006, 11:10
MvdB MvdB is offline
Junior Member
 
Join Date: Oct 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Aha Tnx! :P

But has the error:

Code:
heartbeat: 2006/10/06_16:00:01 ERROR: mcast [eth0] bad addr [255.0.0.1]
Anything to do with this typo?
Reply With Quote
  #4  
Old 12th October 2006, 17:50
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,711
Thanks: 1,899
Thanked 2,702 Times in 2,545 Posts
Default

Quote:
Originally Posted by MvdB
Aha Tnx! :P

But has the error:

Code:
heartbeat: 2006/10/06_16:00:01 ERROR: mcast [eth0] bad addr [255.0.0.1]
Anything to do with this typo?
You have another error in your ha.cf. It must be

Code:
mcast eth0 225.0.0.1 694 1 0
instead of
Code:
mcast eth0 255.0.0.1 694 1 0
__________________
Falko
--
Download the ISPConfig 3 Manual! | Check out the ISPConfig 3 Billing Module!

FB: http://www.facebook.com/howtoforge

nginx-Webhosting: Timme Hosting | Follow me on:
Reply With Quote
  #5  
Old 16th October 2006, 11:15
MvdB MvdB is offline
Junior Member
 
Join Date: Oct 2006
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
 
Thumbs up

Tnx man!

It works Great!

It were the 2 typo's and a config error with iproute on the sql servers.

Reply With Quote
Reply

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
postfix problems with smtp linkdeb Server Operation 13 15th March 2014 17:58
Load-Balanced MySQL Cluster Error with Cluster stylez HOWTO-Related Questions 12 1st October 2006 04:55
Howto suggestion suse PhP ver 4 + Ver 5 wwparrish Suggest HOWTO 11 7th August 2006 13:29
Mandriva 10.2 Perfect Setup Install Problems... ctroyp Installation/Configuration 12 30th December 2005 16:04
Problem installing ISPConfig, then with MySQL... ctroyp Installation/Configuration 7 26th September 2005 16:37


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


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