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 29th June 2007, 11:21
arsh79 arsh79 is offline
Junior Member
 
Join Date: Jun 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default MySQL balanced cluster howto and Ubuntu server 6.10

Hello everyone,
following the (great) howto I've been able to get the MySQL cluster up and running flawlessy, but I found some problems configuring UltraMonkey.

I followed the howto step by step (aka "cut and paste") and all check commands are replying as expected with a notable exception: if i disable ldirectord as a daemon I can't see weights shifting with "ipvsadm -L -n" (both servers are weight 0) like this:

Code:
IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddress:Port Scheduler Flags
  -> RemoteAddress:Port           Forward Weight ActiveConn InActConn
TCP  192.168.10.15:mysql wrr
  -> 192.168.10.11:mysql           Local   0      0          0
  -> 192.168.10.12:mysql           Route   0      0          0
If i issue a "/etc/init.d/ldirectord start" weights start shifting as expected as one or the other server fails.

My real problem is that if I stop the MySQL sql node on the active master I can't connect to the database anymore, thus not routing requests to the backup sql node.

I can see in the output of ipvsadm the correct server weights (mysql stopped weight 0, the active one weight 1)

Any suggestions?
I can provide logs and/or conf files if you need them.

Thank you for your time in advance
Reply With Quote
Sponsored Links
  #2  
Old 30th June 2007, 16:00
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Are there any errors in your logs?
__________________
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 2nd July 2007, 09:34
arsh79 arsh79 is offline
Junior Member
 
Join Date: Jun 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
Default

No, it doesn't report any error in logs...
I found out that if I'm trying to connect from a third server the whole system works as expected.

I take it that the service isn't balanced when one of the hosting servers is trying to access it. I have only 2 servers in my setup, with a web application (that resides on the same servers) accessing the database cluster.
Do you think is possible to have a failover cluster with only 2 servers or I must have at least 3?
Reply With Quote
  #4  
Old 3rd July 2007, 15:17
falko falko is offline
Super Moderator
 
Join Date: Apr 2005
Location: Lüneburg, Germany
Posts: 41,701
Thanks: 1,900
Thanked 2,740 Times in 2,575 Posts
Default

Quote:
Originally Posted by arsh79
I take it that the service isn't balanced when one of the hosting servers is trying to access it. I have only 2 servers in my setup, with a web application (that resides on the same servers) accessing the database cluster.
What IP address does your web application use to connect to MySQL? It should be the virtual IP address.
__________________
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 3rd July 2007, 15:59
arsh79 arsh79 is offline
Junior Member
 
Join Date: Jun 2007
Posts: 3
Thanks: 0
Thanked 0 Times in 0 Posts
 
Default

Yes, in my setup i have (192.168.0...) .11 and .12 as SQL interfaces and .15 as virtual IP for the balanced mysql to listen to.
Now if i shutdown mysql on server .11 and try connect to server .15 i get the "unable to connect" error...
Probably that's happening because of the lo:0 interface I configured
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
Mailbox instead of Maildir (in Postfix - Mysql - Courier Ubuntu 6.10 Edgy Efty) Lukather Installation/Configuration 1 1st May 2007 20:44
My first server.. mysql. problems /w Ubuntu Lamp Server mwburris Installation/Configuration 2 20th March 2007 04:28
MySQL Cluster HOWTO - Cannot load Virtual IP address samu HOWTO-Related Questions 6 11th January 2007 10:19
MySql on Ubuntu 6.06 LTS Server Bubo Server Operation 7 5th January 2007 16:23
VMWare Server Howto and Ubuntu Questions crudolphy HOWTO-Related Questions 11 25th July 2006 20:11


All times are GMT +2. The time now is 10:08.


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