Hi, On Fri, 2010-10-15 at 17:33 +0530, Sivaprakash wrote: > Hi > > This is Sivaprakash working as a Technology Specialist. I'm kind of > exploring HAProxy to load balance the calls betweek multiple data > bases with regarding this I've few questions. Could you please clarify > them > - Will it support Windows ? I'm not a developer on this project but I doubt it.
> > - If not Windows, I'll bring up a Linux based server infront of > Windows Servers and deploy HAProxy there to load balance the called > between all the Windows machines behind it. I think this is a bad idea. Usually you need to use a database driver that explicitly supports connection load balancing between multiple servers. Some will support balancing only read-only queries, others will support both read and write statements. With the right driver, you don't need a load balancer. That is - the driver acts as an application (layer 7) load balancer. You could use HAproxy in TCP only (layer 4) mode but I think this is inferior to a proper load-balancing driver if one is available. HAproxy has no understanding of the database protocol and therefore cannot act as an application (layer 7) load balancer in this case. > > - If i bring up the above model how my connection string will get > change from my application? I'm not sure I understand the question properly. > > > Is there any good case study for Windows? Is so pelase send it across. > > Thanks > Siva > ______________________________________________________________________ > This email has been scanned by the MessageLabs Email Security System. > For more information please visit http://www.messagelabs.com/email > ______________________________________________________________________ -- Best Regards, Brett Delle Grazie ______________________________________________________________________ This email has been scanned by the MessageLabs Email Security System. For more information please visit http://www.messagelabs.com/email ______________________________________________________________________
