View Single Post
Old 9th April 2007, 09:57
lychee_lch lychee_lch is offline
Junior Member
Join Date: May 2006
Posts: 12
Thanks: 0
Thanked 0 Times in 0 Posts
Question mysql-cluster load balancing problem !!

I have follow every step of how to mysql cluster and load balancing, But when i reach the page 7 "prepare the mysql cluster node for load balancing",after i type "ifup lo:0" .. Then i check the management node typed "ndb_mgm" >> "show". It show

Cluster Configuration
[ndbd(NDB)] 2 node(s)
id=2 (not connected, accepting connect from
id=3 (not connected, accepting connect from

[ndb_mgmd(MGM)] 1 node(s)
id=1 @ (Version: 5.0.27)

[mysqld(API)] 2 node(s)
id=4 (not connected, accepting connect from any host)
id=5 (not connected, accepting connect from any host)

This show all the node have been disconnected when i typed "ifup lo:0"

1) Is this normal when i typed ifup lo:0 the mysql cluster will disconnected, i cant even online with the both sql node ....????

I donno this situation is normal or not, so i proceed to nex step. Everything look same in the tutorial except i came to a step where i typed "ipvsadm -L -n" and the result is ...

IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddress:Port Scheduler Flags
-> RemoteAddress:Port Forward Weight ActiveConn InActConn
TCP wrr
-> Route 0 0 0
-> Route 0 0 0

whereby, the "weight" is "0" and in tutorial is "1" (actually i not really understand what does the weight means... ) T_T

so without any choice, i still proceed to another step until "mysql -h -u ldirector -p " with the correct password. But after i login, i try to use the "select all from connectioncheck table" and it say

"Error 1105 (HY000): Failed to open 'connectioncheck', error while unpacking from engine"

2) Is there other way to check the whole cluster-load balancer configured right ?
3) Can i use the same one of the my four pc to access mysql ??
4) The same network other pc that mentioned must installed mysql to access my virtual ip mysql ?

Please help and give some advise !!!!! thanks .....
Reply With Quote
Sponsored Links