[ULTRAMONKEY-USERS] problems with hc-ha-lb architecture

[Jordi Garcia]

Yes, it works from frontends and lb backup, but not from the lb master.
I need that all servers execute a perl querys to database, and I use VIP
address in connect string.

'ipvsadm -L -n' command don't show my test. I don't arrive to ipvsadm
table. Routing problem? but, it's the same machine.... I don't use
iptables filters either.



Jordi

El jue, 06-09-2007 a las 16:21 +0200, diego escribió:
> First of all, try to connect to 172.16.17.11 from an other machine.
> 
> As I can see from your "copy paste", you want to connect to virtual ip 11 from localhost 
> (ip 7) wich is also the balancer.
> 
> I don't know if it will solve but it's easy to try...
> 
> 
> Then while connecting, keep a terminal opened on
> "watch -n1 ipvsadm -L -n"
> 
> to see if the number of active (or inactive at least) connections growth to 1
> 
> 
> Let me know.
> 
> Diego
> 
> Jordi Garcia ha scritto:
> > Hello,
> > 
> > I have this architecture:
> > 
> > 2 fronteds with Debian 4.0
> > 2 backends with CentOS 5.0
> > 2 lb with CentOS 5.0
> > 
> > I balance a MySQL service running in backend servers. With a MySQL
> > client in frontends, I can connect to backend trought lb process
> > without problems. The lb backup server, don't have problems to connect
> > via VIP address with the same MySQL client.
> > 
> > My problem is with lb master server, I cannot use VIP address by connect
> > to db backend:
> > 
> > 
> > ss2:~# ipvsadm -L -n
> > IP Virtual Server version 1.2.1 (size=4096)
> > Prot LocalAddress:Port Scheduler Flags
> >   -> RemoteAddress:Port           Forward Weight ActiveConn InActConn
> > TCP  172.16.17.11:3306 wrr
> >   -> 172.16.17.9:3306             Route   1      0          0
> >   -> 172.16.17.8:3306             Route   1      0          0
> > 
> > ss2:~# mysql -h 172.16.17.11 -u email -p
> > Enter password:
> > ERROR 2003 (HY000): Can't connect to MySQL server on
> > '172.16.17.11' (111)
> > 
> > ss2:~# mysql -h 172.16.17.9 -u email -p
> > Enter password:
> > Welcome to the MySQL monitor.  Commands end with ; or \g.
> > [...]
> > 
> > ss2:~# ip addr
> > 1: lo: <LOOPBACK,UP,LOWER_UP> mtu 16436 qdisc noqueue
> >     link/loopback 00:00:00:00:00:00 brd 00:00:00:00:00:00
> >     inet 127.0.0.1/8 scope host lo
> >     inet6 ::1/128 scope host
> >        valid_lft forever preferred_lft forever
> > 2: eth0: <BROADCAST,MULTICAST,UP,LOWER_UP> mtu 1500 qdisc pfifo_fast
> > qlen 1000
> >     link/ether 00:30:05:fb:61:cd brd ff:ff:ff:ff:ff:ff
> >     inet 172.16.17.7/27 brd 172.16.17.31 scope global eth0
> >     inet 172.16.17.11/27 brd 172.16.17.31 scope global secondary eth0
> >     inet6 fe80::230:5ff:fefb:61cd/64 scope link
> >        valid_lft forever preferred_lft forever
> > 4: sit0: <NOARP> mtu 1480 qdisc noop
> >     link/sit 0.0.0.0 brd 0.0.0.0
> > 
> > ss2:~# route -n
> > Kernel IP routing table
> > Destination     Gateway         Genmask         Flags Metric Ref    Use
> > Iface
> > 172.16.17.0     0.0.0.0         255.255.255.224 U     0      0        0
> > eth0
> > 169.254.0.0     0.0.0.0         255.255.0.0     U     0      0        0
> > eth0
> > 0.0.0.0         172.16.17.1     0.0.0.0         UG    0      0        0
> > eth0
> > 
> > I follow this doc:
> > http://www.ultramonkey.org/3/topologies/hc-ha-lb-eg.html
> > 
> > 
> > Any ideas?
> > 
> > Thanks
> > Jordi
> > 
> > Advertencia importante
> > Este mensaje contiene informacion confidencial y/o privilegiada. Si usted no es el destinatario o una persona expresamente autorizada por el destinatario para recibir este mensaje no debe utilizar, copia, reenviar, distribuir o, en general, disponer en ninguna forma de la informacion incluida en el mismo. Si se hubiera recibido este mensaje por error, sirvase informar al emisor en tal sentido mediante una respuesta inmediata y borrelo, por favor. Gracias por su colaboracion. 
> > 
> > Important notice
> > This message contains confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, forward, disclose or take any action based on this message or any information herein. If you receive this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation. 
> > 
> > _______________________________________________
> > Ultramonkey-users mailing list
> > Ultramonkey-users at vergenet.net
> > http://lists.vergenet.net/listinfo/ultramonkey-users
> > 
> 


Advertencia importante
Este mensaje contiene informacion confidencial y/o privilegiada. Si usted no es el destinatario o una persona expresamente autorizada por el destinatario para recibir este mensaje no debe utilizar, copia, reenviar, distribuir o, en general, disponer en ninguna forma de la informacion incluida en el mismo. Si se hubiera recibido este mensaje por error, sirvase informar al emisor en tal sentido mediante una respuesta inmediata y borrelo, por favor. Gracias por su colaboracion. 

Important notice
This message contains confidential and/or privileged information. If you are not the addressee or authorized to receive this for the addressee, you must not use, copy, forward, disclose or take any action based on this message or any information herein. If you receive this message in error, please advise the sender immediately by reply e-mail and delete this message. Thank you for your cooperation.