Hia all, im working on setting up loadbalanced mysql cluster.
atm it is just to see if it works. I'm using 3 servers.
1 ndb manager with the loadbalancer
2 mysql servers
I have been following this guide:
Everything works great except the loadbalancing.. =)
The mysql servers are upp and running, i can connect to them localy or remote to their real ip.
But i can not connect to them trough the Vip.
virtual = 192.168.0.21:3306
service = mysql
real = 192.168.0.24:3306 gate
real = 192.168.0.25:3306 gate
checktype = negotiate
login = "ldirector"
passwd = "test"
database = "ldirectordb"
request = "SELECT * FROM connectioncheck"
scheduler = wrr
IP Virtual Server version 1.2.1 (size=4096)
Prot LocalAddress:Port Scheduler Flags
-> RemoteAddress:Port Forward Weight ActiveConn InActConn
TCP 192.168.0.21:mysql wrr
-> 192.168.0.25:mysql Route 0 0 0
-> 192.168.0.24:mysql Route 0 0 0
All other services are upp and running.
Anyone have a clue why it doesent work?