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 < li...@olindata.com> 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 <daisleyj...@googlemail.com> > 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 <vegiv...@tuxera.be > >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=prajapat...@gmail.com > >