Re: Mysql-Proxy Return prior to Execution

Managed to solve, just in case anyone else needs the same: function read_query( packet ) if string.byte(packet) == proxy.COM_QUERY then condition. if (condition) then print("replaced with " .. query ) proxy.queries:append(1, string.char(proxy.COM_QUERY)

Re: Mysql-Proxy Return prior to Execution

Hi Martin, Application benchmarking purposes - i don't want any latency for updates to complete. Still, data is needed. But i don't want application nor server to handle the logic wether sql went fine or not. The idea is: Fire an update / insert, return ok to application, execute query - while ap

Re: mysql proxy in production?

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

Re: mysql proxy in production?

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 f

Re: mysql proxy in production?

On Thu, Mar 11, 2010 at 4:49 PM, 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. > > s

Re: mysql proxy in production?

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_

Re: mysql proxy in production?

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://openq

Re: mysql proxy in production?

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?

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 > S

Re: mysql proxy in production?

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 your

Re: mysql proxy in production?

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 < prajap

Re: mysql proxy in production?

Hi Brent You can visit the below link. 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 wrote:

Re: MySQL proxy

Hi Right now I'm happy. Sorry for spam. I had an error in mys socket coke. By P.S. Proxy works well and gives many possibilities. Daniel Łaś wrote: > > Hi > > I follow this list for long time. This is first time I have to ask the > question. > > I'm developing something like proxy for mysq