#1  
Old 4th April 2007, 15:15
caveman85 caveman85 is offline
Junior Member
 
Join Date: Apr 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default Error (?) MySQL Cluster

Hello,

Thanks for the great howto - How To Set Up A Load-Balanced MySQL Cluster. We completed it almost succesfully, but... We got an error on our (active) loadb1 server. The error is:

DBI connect('database=ldirectordb;host=10.10.20.11;por t=3306','ldirector',...) failed: Can't connect to MySQL server on '10.10.20.11' (110) at /etc/ha.d/resource.d/ldirectord line 1950

and

DBI connect('database=ldirectordb;host=10.10.20.12;por t=3306','ldirector',...) failed: Can't connect to MySQL server on '10.10.20.12' (110) at /etc/ha.d/resource.d/ldirectord line 1950

We've set up everything as told in the howto. Does anyone have any idea what this error could mean and how it is need to be solved?

Our setup is the following:

loadb1 : 10.10.20.1 (We called it x1clmng)
loadb2 : 10.20.20.2 (We called it x2clmng)
sql1 : 10.10.20.11 (We called it x1mysql)
sql2 : 10.10.20.12 (We called it x2clmng)
virtual ip sql : 10.10.20.10

Last edited by caveman85; 10th April 2007 at 09:48.
Reply With Quote
Sponsored Links
  #2  
Old 5th April 2007, 17:22
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,715 Times in 2,557 Posts
Default

What's in /etc/ha.d/haresources?

Are there any error messages in your syslog?
__________________
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 10th April 2007, 09:47
caveman85 caveman85 is offline
Junior Member
 
Join Date: Apr 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Hello!

/etc/ha.d/haresources gives:

x1clmng \
ldirectord::ldirectord.cf \
LVSSyncDaemonSwap::master \
IPaddr2::10.10.20.10/24/eth0/10.10.20.255


And syslog writes no errors at all..
Reply With Quote
  #4  
Old 11th April 2007, 15:47
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,715 Times in 2,557 Posts
Default

Try this instead:

Code:
x1clmng \
    ldirectord::ldirectord.cf \
    LVSSyncDaemonSwap::master \
    IPaddr2::10.10.20.10/8/eth0/10.255.255.255
__________________
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 11th April 2007, 15:53
caveman85 caveman85 is offline
Junior Member
 
Join Date: Apr 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
Default

Falko,

Thanks for the reply. We will try and see what happends.

We use an Debian Sarge template in a XenSource environment. Is it possible that we miss some crucial packages that aren't installed in the template? Do you have any idea which packages are needed for Ultramonkey and the Cluster? I could send you a list of installed packages on our system, maybe that you see something missing...

We hope to hear from you soon!

Greetz

Last edited by caveman85; 11th April 2007 at 17:13.
Reply With Quote
  #6  
Old 12th April 2007, 16:50
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,715 Times in 2,557 Posts
Default

All needed packages are mentioned in the tutorial, so the packages should be present on your systems.
__________________
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
  #7  
Old 12th April 2007, 18:15
caveman85 caveman85 is offline
Junior Member
 
Join Date: Apr 2007
Posts: 5
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Hello,

We've changed the subnet to 8 as you said and till now we don't have any problems at all, so we hope that it's the right solution!

Thanks again!
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
Installed nfs cluster, now only 1 connection out of two 2 works Jan VdV HOWTO-Related Questions 3 23rd February 2007 20:31
MySQL Cluster HOWTO - Cannot load Virtual IP address samu HOWTO-Related Questions 6 11th January 2007 10:19
MySQL Cluster On FC5 : error while unpacking from engine asyadiqin HOWTO-Related Questions 7 28th October 2006 17:37
Loadbalanced Apache Cluster Help brianwebb01 Installation/Configuration 2 18th October 2006 17:01
Load-Balanced MySQL Cluster Error with Cluster stylez HOWTO-Related Questions 12 1st October 2006 04:55


All times are GMT +2. The time now is 19:26.


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