Re: Need Help on HAProxy Load Balancing

Hi,

On Sat, Oct 16, 2010 at 10:01:22AM +0530, Sivaprakash wrote:
> Thanks a lot !!
>
> Could you please suggest good design for Read - Only data base load
> balancing sing HAProxy.

The only reasonable use of a load balancer in front of a database is for fail-over purposes, so that you only use one node at a time. There is a very good article on the subject here :

   http://www.alexwilliams.ca/blog/2009/08/10/using-haproxy-for-mysql-failover-and-redundancy/

Concerning haproxy on Windows, some people managed to get it to work, but the performance was terribly low, with a limit on a very small number of concurrent connections (about 500). It was OK for running as a debugging tool, but not for anything close to production.

Regards,
Willy Received on 2010/10/16 08:12