Load Balance Clustering

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Leila - 24 Apr 2006 06:52 GMT

Hi,
Are there any solution to implement load balancing on one database between
two nodes of cluster?
Thanks in advance,
Leila

Reply to this Message

Geoff N. Hiten - 24 Apr 2006 13:59 GMT

There is no native Microsoft SQL load balancing tool for clusters.
Microsoft SQL clustering is an availability solution only and has no
scale-out benefit.

Signature

Geoff N. Hiten
Senior Database Administrator
Microsoft SQL Server MVP

> Hi,
> Are there any solution to implement load balancing on one database between
> two nodes of cluster?
> Thanks in advance,
> Leila

Reply to this Message

Nils Loeber - 26 Apr 2006 09:34 GMT

While this is true, you could implement a scenario using n instances on n
nodes with distributed partitioned views. That means you horizontally split
up a database table and distribute the parts on different instances which
you switch to different nodes. You virtually join the table partitions by a
view on every instance. Voilà, you get "load balancing" and failover. This
solution is difficult to implement, though.

Best regards,
Nils Loeber

> There is no native Microsoft SQL load balancing tool for clusters.
> Microsoft SQL clustering is an availability solution only and has no
[quoted text clipped - 5 lines]
>> Thanks in advance,
>> Leila

Reply to this Message

Leila - 26 Apr 2006 14:56 GMT

Thanks Nils,
But DPVs do not necessarily need clustering environment.

> While this is true, you could implement a scenario using n instances on n
> nodes with distributed partitioned views. That means you horizontally
[quoted text clipped - 15 lines]
>>> Thanks in advance,
>>> Leila

Reply to this Message

Rodney R. Fournier [MVP] - 24 Apr 2006 19:39 GMT

If you have a web application you can load balance the web servers and
cluster the SQL backend.

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner

> Hi,
> Are there any solution to implement load balancing on one database between
> two nodes of cluster?
> Thanks in advance,
> Leila

Reply to this Message

Leila - 24 Apr 2006 19:24 GMT

Hi Rodney,

> ... and cluster the SQL backend...

You mean a failover cluster?

> If you have a web application you can load balance the web servers and
> cluster the SQL backend.
[quoted text clipped - 14 lines]
>> Thanks in advance,
>> Leila

Reply to this Message

Rodney R. Fournier [MVP] - 24 Apr 2006 20:28 GMT

Correct, I can't explain or understand any other of SQL clustering - no clue
on clustered-indexes for example!

Cheers,

Rodney R. Fournier

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
ClusterHelp.com is a Microsoft Certified Gold Partner

> Hi Rodney,
>
[quoted text clipped - 19 lines]
>>> Thanks in advance,
>>> Leila

Reply to this Message