Networking Forums

Networking Forums > Computer Networking > Linux Networking > Mysql-Cluster and Load Balancing with ldirectord

Reply
Thread Tools Display Modes

Mysql-Cluster and Load Balancing with ldirectord

 
 
rascasoft@tiscali.it
Guest
Posts: n/a

 
      05-13-2005, 12:17 PM
Hi everyody,
I set up a test environment that is the same as the one in this image :
http://www.ultramonkey.org/3/topologies/svg/lb-eg.png .
I've configured a a mysql cluster on the 2 real server and these are
listening on 3306 port, serving the same DB.
Now i would like to put everything under a Load Balancer on the third
PC. I'm using "ldirectord" from the Ultramonkey project.
I've configured the "ldirectord.cf" file in this way :

# Global Directives
checktimeout=3
checkinterval=1
fallback=127.0.0.1:80
autoreload=yes
quiescent=yes

#Sample configuration for a MySQL virtual service.
virtual = 192.168.6.240:3306
real = 192.168.7.4:3306 masq 10
real = 192.168.7.5:3306 masq 10
checktype = negotiate
login = "miouser"
passwd = "miapass"
database = "test"
request = "SELECT * FROM test"
scheduler = wrr

The Daemon starts up correctly, but in the system i can't find any
virtual address with the IP that i want, 192.168.6.240 listening to the
3306 port, so, at this moment i'm balancing anything.
For what i've understand, the daemon should create the virtual
interface, but i don't receive any error from it and i can't find out
what's wrong.
I've followed these instructions :
http://www.ultramonkey.org/3/topologies/lb-eg.html
What i am missing ?

Thank you so much,

--
RaSca
(E-Mail Removed)

 
Reply With Quote
 
 
 
 
RaSca
Guest
Posts: n/a

 
      05-14-2005, 08:54 AM
It was a problem concerning the configuration file...
Removing these lines :
login = "miouser"
passwd = "miapass"
database = "test"
request = "SELECT * FROM test"
make ldirectord working.

Bye,

--
RaSca
(E-Mail Removed)

 
Reply With Quote
 
Raqueeb Hassan
Guest
Posts: n/a

 
      05-14-2005, 02:04 PM
How are you finding this when compared to mysql-cluster as a product?



--
Raqueeb Hassan
Bangladesh

 
Reply With Quote
 
RaSca
Guest
Posts: n/a

 
      05-16-2005, 09:14 AM
Hi, Could you be more specific, please ?
I can't understand what's the question :-)

--
RaSca
(E-Mail Removed)

 
Reply With Quote
 
 
 
Reply

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
Trackbacks are On
Pingbacks are On
Refbacks are Off


Similar Threads
Thread Thread Starter Forum Replies Last Post
Network Load Balancing adds cluster IP to DNS Gaspar Windows Networking 3 04-17-2007 05:37 PM
Linux Cluster Load Balance Antoni Linux Networking 6 04-11-2007 11:36 PM
Linux Network Cluster/Load Balancing MattD Linux Networking 0 02-08-2007 10:05 PM
Load Balancing "Apache + MySQL" for online exams! Roshan Sumbaly Linux Networking 2 12-23-2006 11:52 AM
NIC Load Balancing Chicho Windows Networking 2 02-20-2004 06:55 PM



1 2 3 4 5 6 7 8 9 10 11