List:General Discussion« Previous MessageNext Message »
From:Krishna Chandra Prajapati Date:March 12 2010 8:05am
Subject:Re: mysql proxy in production?
View as plain text  
Hi Walter,

I have tried and tested haproxy (ver 1.3). But it doesn't work to my
expectation. May be newer version (1.4) works better.

Brent try and check

http://sqlrelay.sourceforge.net/sqlrelay/

http://www.cherokee-project.com/
http://www.alobbs.com/1344/MySQL_asynchronous_balancing_with_HTTP_JSON.html


Thanks,
Krishna

On Fri, Mar 12, 2010 at 10:32 AM, Walter Heck - OlinData.com <
lists@stripped> wrote:

> Take a look at haProxy. It can be combined with some scripts to
> loadbalance mysql.
>
>
> http://www.alexwilliams.ca/blog/2009/08/10/using-haproxy-for-mysql-failover-and-redundancy/
> We use it at Open Query for a similar case.
>
> Cheers,
>
> Walter Heck
>
> Engineer @ Open Query
> http://openquery.com | http://openquery.com/blog |
>
> On Fri, Mar 12, 2010 at 02:09, John Daisley <daisleyjohn@stripped>
> wrote:
> > Has MySQL Proxy been improved since that article was released?
> >
> > I ask because although I have no personal experience with it I do know of
> a
> > big UK based online payment processing company who use MySQL Proxy with
> > MySQL 5.1 in production very successfully.
> >
> >
> > On Thu, Mar 11, 2010 at 3:34 PM, Johan De Meersman <vegivamp@stripped
> >wrote:
> >
> >> Bah, just spilled coffee on my keyboard.
> >>
> >> I never was a big fan of mysqlproxy, but this is almost inconceivable.
> The
> >> next genius to suggest it for our environment had better have asbestos
> >> underwear.
> >>
> >> Thanks for the link, Krishna.
> >>
> >>
>
> --
> MySQL General Mailing List
> For list archives: http://lists.mysql.com/mysql
> To unsubscribe:
> http://lists.mysql.com/mysql?unsub=1
>
>

Thread
mysql proxy in production?Brent Clark11 Mar
  • Re: mysql proxy in production?Krishna Chandra Prajapati11 Mar
    • Re: mysql proxy in production?Johan De Meersman11 Mar
      • Re: mysql proxy in production?John Daisley11 Mar
        • Re: mysql proxy in production?Walter Heck - OlinData.com12 Mar
          • Re: mysql proxy in production?Krishna Chandra Prajapati12 Mar
    • Re: mysql proxy in production?Brent Clark11 Mar
      • Re: mysql proxy in production?Mark Matthews11 Mar
      • Re: mysql proxy in production?Johan De Meersman12 Mar
        • Re: mysql proxy in production?Krishna Chandra Prajapati12 Mar
          • Re: mysql proxy in production?Johan De Meersman12 Mar