My only feedback is that haproxy has a lot of features that make it useful as a MySQL frontend. The stats are great for sizing and monitoring purposes. Timeouts and queuing are also great for managing load etc. I used to run haproxy in front of a single MySQL instance for those features alone ala:
http://flavio.tordini.org/a-more-stable-mysql-with-haproxy If you are looking to load balance multiple database servers, I think haproxy is a good choice for doing that. It will work great as long as everything is functioning normally, but you will need to put a lot of work into handling failures and master migration etc. These things haproxy has nothing directly to do with. Here is some information on handling failure cases etc. using a simple agent along with haproxy. It is old information, but should be useful. http://www.alexwilliams.ca/blog/2009/08/10/using-haproxy-for-mysql-failover-and-redundancy/ On Thu, Apr 24, 2014 at 9:46 AM, Alexandre <[email protected]> wrote: > Hello everyone, > > I'm looking for documentation to make a load balancer for mysql. > > I found this article : > https://www.digitalocean.com/community/articles/how-to-use- > haproxy-to-set-up-mysql-load-balancing--3 > > What do you think? > > We also perform a test with LVS load balancing for mysql. > > Have you feedback of this load balancer. > > > Thank you > > Alexandre > >
