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
Old 6th October 2006, 18: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:
heartbeat: 2006/10/06_16:00:01 ERROR: mcast [eth0] bad addr []
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:
logfacility     local0
bcast           eth0
mcast eth0 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


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

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

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