Re: Need Help on HAProxy Load Balancing

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 
______________________________________________________________________