Load balancing. -- sql server clustering

Rodney R. Fournier [MVP]
8/19/2005 6:10:14 PM

SQL 2000 Clustering is not capable of load balancing a database.

Cheers,

Rod

MVP - Windows Server - Clustering
http://www.nw-america.com - Clustering Website
http://www.msmvps.com/clustering - Blog
http://www.clusterhelp.com - Cluster Training
http://msmvps.com/clustering/archive/2005/07/20/58233.aspx NYC Clustering
class

[quoted text, click to view]

Carl-Johan Wik
8/20/2005 1:03:48 AM

Hi!

I have two sql servers. One raid rack in the middle for them both.

I installe two cluster groups, with two sql installation.

Now I can put a db on one server and it can fail over to the other one and
the other way around. Fine.

But how can I set it up so the same db is located one both cluster groups
(on the raid and shared by both cluster groups) and use some kind of load
balacing system to harvest the power of both servers for one db.

The only ways I have found so far is DTC and replikation. DTC no slack in
time for having the db exactly the same on both servers, but needs knowledge
and rewrite of code to use DTC transactions. Replikation, slack in time in
update between the cluster groups.

Is there another way to do this? We want to use the power of both servers in
a normal situation, have the fail over if one goes down, only one copy of
the db. No slack in time between the both servers.

regards

cj

sql server clustering : Load balancing.