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 ______________________________________________________________________Received on 2010/10/15 16:51
This archive was generated by hypermail 2.2.0 : 2010/10/15 17:00 CEST