Thanks a lot !! Could you please suggest good design for Read - Only data base load balancing sing HAProxy.
Thanks Siva On Fri, Oct 15, 2010 at 8:21 PM, Brett Delle Grazie < [email protected]> wrote: > 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 > ______________________________________________________________________ > -- - Prakash.
