Network Load Balancing in SQL 2005 Cluster

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Ankur - 25 Aug 2008 13:31 GMT

Hi,

A server which is configured as SQL 2005 Cluster as an Active/Passive
node.
I have a query, if I can configure SQL 2005 Cluster as an Active/Active node
with Network load balance and can use same SQL virtual IP address.

I have 27 applications which connects a single DB, which is working in my
Active/Passive configuration.

Pls. help me if there is possibility in my scenario.

Thanks & Regards,
Ankur

Reply to this Message

Geoff N. Hiten - 25 Aug 2008 15:20 GMT

It doesn't work that way.

Active/Active is two separate instances with completely different IP
addresses and database sets.

Signature

Geoff N. Hiten
Principal SQL Infrastructure Consultant
Microsoft SQL Server MVP

> Hi,
>
[quoted text clipped - 11 lines]
> Thanks & Regards,
> Ankur

Reply to this Message

Pascal Deliot - 27 Aug 2008 12:30 GMT

Cluster is not designed for load balancing.
Cluster is only designed for hight availibility.

And direct network load balancing between SQL Server is not a recommended
...

> Hi,
>
[quoted text clipped - 11 lines]
> Thanks & Regards,
> Ankur

Reply to this Message

Linchi Shea - 27 Aug 2008 23:10 GMT

It's not that it's not recommended, it simply does not.

Linchi

> Cluster is not designed for load balancing.
> Cluster is only designed for hight availibility.
[quoted text clipped - 17 lines]
> > Thanks & Regards,
> > Ankur

Reply to this Message