Hi, I think this should be a very trivial problem but I just don't know how to solve it. I have followed the instruction to setup ldirector to load balance on two sql nodes. Ldirector thinks that both the sql nodes are down but in fact they are up. I can even mysql into those two urls. Iptables are all turned off. Could someone please give me some suggestion? Any help will be greatly appreciated.
[EMAIL PROTECTED] ha.d]# ipvsadm -L -n IP Virtual Server version 1.2.1 (size=4096) Prot LocalAddress:Port Scheduler Flags -> RemoteAddress:Port Forward Weight ActiveConn InActConn TCP 192.168.1.120:80 <http://192.168.1.120/> rr -> 192.168.1.114:80 <http://192.168.1.114/> Route 1 0 0 -> 192.168.1.113:80 <http://192.168.1.113/> Route 1 0 0 TCP 192.168.1.120:3306 rr -> 192.168.1.117:3306 Local 0 0 0 -> 192.168.1.114:3306 Route 0 0 0 [EMAIL PROTECTED] ha.d]# /usr/local/mysql/bin/mysql -h 192.168.1.114 -uldirector -p Enter password: Welcome to the MySQL monitor. Commands end with ; or \g. Your MySQL connection id is 15 Server version: 5.1.23-ndb-6.2.15 MySQL Community Server (GPL) Type 'help;' or '\h' for help. Type '\c' to clear the buffer. mysql> use ldirectordb Reading table information for completion of table and column names You can turn off this feature to get a quicker startup with -A Database changed mysql> SELECT * FROM connectioncheck -> ; +------+ | i | +------+ | 1 | +------+ 1 row in set (0.00 sec) mysql> Here is my ldirector.cf: checktimeout=3 checkinterval=5 autoreload=yes logfile="/var/log/ldirectord.log" quiescent=yes virtual=192.168.1.120:80 fallback=127.0.0.1:80 real=192.168.1.113:80 gate real=192.168.1.114:80 gate service=http request="test.html" receive="Still alive" scheduler=rr protocol=tcp checktype=negotiate virtual=192.168.1.120:3306 service=mysql real=192.168.1.114:3306 gate real=192.168.1.117:3306 gate checktype=negotiate login="ldirector" passwd="ldirectorpassword" database="ldirectordb" request="SELECT * FROM connectioncheck" scheduler=rr ~ ~ Regards, Pete _______________________________________________ LinuxVirtualServer.org mailing list - [email protected] Send requests to [EMAIL PROTECTED] or go to http://lists.graemef.net/mailman/listinfo/lvs-users
