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
