MySQL Forums
Forum List  »  Router & Proxy

Re: MySQL Proxy: Scenarios
Posted by: Gerry Reno
Date: July 10, 2007 12:17PM

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

Options: ReplyQuote


Subject
Views
Written By
Posted
21458
July 09, 2007 11:35PM
7972
July 10, 2007 12:01AM
8097
July 10, 2007 11:21AM
5709
July 10, 2007 12:05PM
Re: MySQL Proxy: Scenarios
5801
July 10, 2007 12:17PM
5193
July 10, 2007 02:37PM
5176
July 10, 2007 04:07PM
4637
February 21, 2008 11:26PM
5026
July 10, 2007 11:55AM
4255
February 13, 2008 02:04PM
3839
September 24, 2008 02:44AM


Sorry, you can't reply to this topic. It has been closed.

Content reproduced on this site is the property of the respective copyright holders. It is not reviewed in advance by Oracle and does not necessarily represent the opinion of Oracle or any other party.