Re: mysql proxy in production?

2010-03-12 Thread Krishna Chandra Prajapati
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/

Re: mysql proxy in production?

2010-03-12 Thread Johan De Meersman
On Thu, Mar 11, 2010 at 4:49 PM, Brent Clark brentgclarkl...@gmail.comwrote: On 11/03/2010 16:52, Krishna Chandra Prajapati wrote: Hi Brent You can visit the below link. http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/ Well thats

Re: mysql proxy in production?

2010-03-12 Thread Krishna Chandra Prajapati
Hi all, The below link shows the benchmark between different web servers ( apache, niginx, cherokee). http://lists.octality.com/pipermail/cherokee/2009-May/010343.html *http://nerdbynature.de/benchmarks/ab/2009-05-16/* Conclusion of Above Benchmarks *It seems that Cherokee continues being the

Re: mysql proxy in production?

2010-03-12 Thread Johan De Meersman
On Fri, Mar 12, 2010 at 3:05 PM, Krishna Chandra Prajapati prajapat...@gmail.com wrote: The below link shows the benchmark between different web servers ( apache, niginx, cherokee). Irrelevant to this list, but I'll bite: there is no detail whatsoever on the configuration of the various

mysql proxy in production?

2010-03-11 Thread Brent Clark
Hiya I work for a pretty large hosting company, and we have some clients that you could call in demand clients (Well here where I live anyway :) ). We already making use of heartbeat for high availability etc. But the one area that we have not tackled is load balancing. I just read the

Re: mysql proxy in production?

2010-03-11 Thread Krishna Chandra Prajapati
Hi Brent You can visit the below link. http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/ http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/ Thanks, Krishna On Thu, Mar 11, 2010 at 7:56 PM, Brent Clark

Re: mysql proxy in production?

2010-03-11 Thread Johan De Meersman
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. On Thu, Mar 11, 2010 at 3:52 PM, Krishna Chandra Prajapati

Re: mysql proxy in production?

2010-03-11 Thread Brent Clark
On 11/03/2010 16:52, Krishna Chandra Prajapati wrote: Hi Brent You can visit the below link. http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/ Well thats disappointing. sigh So what are we supposed to use for loadbalancing mysql. Thank you for

Re: mysql proxy in production?

2010-03-11 Thread Mark Matthews
On Mar 11, 2010, at 9:49 AM, Brent Clark wrote: On 11/03/2010 16:52, Krishna Chandra Prajapati wrote: Hi Brent You can visit the below link. http://www.mysqlperformanceblog.com/2009/06/09/mysql-proxy-urgh-performance-and-scalability/ Well thats disappointing. sigh So what are we

Re: mysql proxy in production?

2010-03-11 Thread John Daisley
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

Re: mysql proxy in production?

2010-03-11 Thread Walter Heck - OlinData.com
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 |