We have been using mysql-proxy in production for more than a year to load-balance … say that for our traffic (roughly 200 qps on average), mysql-proxy has been pretty stable and required no maintenance.
Comment: mysql-proxy, urgh performance and scalability ?
February 7, 2013 By 44 Comments
This mysql proxy documentation says MySQL proxy is in Alpha and not to use in production. Is this a typo?
Comment: mysql-proxy, urgh performance and scalability ?
March 7, 2012 By 44 Comments
… apply it fully on our application. For you i guess mysql proxy would be a suitable option, spoken to a solution architect… centre and she says most of our clients are using mysql proxy….. Are you aware of any hardware based load balancer, do…
Comment: mysql-proxy, urgh performance and scalability ?
March 5, 2012 By 44 Comments
Hi, Wanted to use mysql proxy for load balancing my slaves for read. Is there a hardware alternative to mysql proxy that i can use to distribute load between my slaves (reads). thanks..
Post: Distributed Set Processing with Shard-Query
May 14, 2011 By 27 Comments
… more chunks. Each Shard-Query instance is a essentially a proxy for the distributed set based SQL operations executed on the nodes under the proxy. The databases do 99.9% of the work, due to… of compute resource which speaks SQL, but right now only MySQL storage nodes are supported. Amdahl’s law applies to the…
Comment: State of MySQL Market and will Replication live ?
April 10, 2008 By 29 Comments
… fast system (as fast as you can get with the MySQL Proxy aproach – think of added network latency). So we concentrate on… have our application running with HSCALE in our testing environment. (MySQL Proxy is really awesome, fast and robust btw.). I think (and…
Comment: Does Slow query log logs all slow queries ?
June 25, 2007 By 3 Comments
Perhaps we can get something to handle this into the mysql-proxy. http://jan.kneschke.de/2007/6/25/mysql-proxy-0-5-0-released
Comment: Wishes for new "Pure PHP" MySQL driver
May 30, 2007 By 17 Comments
Rolf, currently there is no way to stop the running queries from client side. This could be an issue for the proxy (http://jan.kneschke.de/projects/mysql/mysql-proxy)
Comment: mysql-proxy, urgh performance and scalability ?
February 11, 2013 By 44 Comments
If Ha proxy or mysql proxy is no good for you then please look into f5 load balancers for load balancing. Read/write can be done at application level aswell. Nginx can also be used for load balancing and is quite efficient and lightweight.
Comment: mysql-proxy, urgh performance and scalability ?
February 11, 2013 By 44 Comments
Hi, Suddenly MYSQL-PROXY seems to be an hot issue here. My last comment … be that as a consultancy we moved client away from proxy because of it crashing in very busy production. Just to…
