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
[ndbd(NDB)] 2 node(s)
id=2 (not connected, accepting connect from 10.100.100.102)
id=3 (not connected, accepting connect from 10.100.100.103)
[ndb_mgmd(MGM)] 1 node(s)
id=1 @10.100.100.101 (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 10.100.100.105:3306 wrr
-> 10.100.100.103:3306 Route 0 0 0
-> 10.100.100.102:3306 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 10.100.100.105 -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 .....