Edwin DeSouza Wrote:
-------------------------------------------------------
> Can you help us understand more on:
> "But what about HA for the proxy itself. I would
> have preferred that the proxy was an
> implementation of a VRRP router.
http://en.wikipedia.org/wiki/Vrrp
This way it would
> take care of HA for itself automatically. The idea
> is that all upstream clients would use a VIP to
Virtual IP Address
> address the proxy. You would install two
or more
> proxies
> on different machines and assign one of these the
> VIP. Being a VRRP router the failover router would
> monitor the active router and if it could not make
> contact it would then take over the VIP and
> continue service for upstream clients. The
> upstream clients would never know that they had
> been switched to the failover proxy. So this is
> what MySQL Proxy needs for its own HA. Now I've
> only been working with MySQL Proxy for two days so
> maybe it has a way to do this that is transparent
> to upstream clients. The issue is that it is not
> enough that MySQL Proxy provide HA to mysqld. It
> must also make sure that it does not become a SPOF
> and therefore must provide HA for itself. In the
> alternative, I have been mapping out some ways
> that I could externally provide HA for MySQL Proxy
> but things get ugly quickly when you have to
> provide complete transparency to upstream
> clients."
What I may do is implement a VRRP load balancer that will just load balance multiple instances of MySQL-Proxy and achieve HA for MySQL-Proxy in this way.
Gerry