Location: SQL Server Whitepapers

Discussion: Active/Active Clustering

Keyword tags: database microsoft Query sql

Watch
brian_summers
brian_summers
Active/Active Clustering
Jul 17 2008, 9:37 AM EDT
Can someone point me to whitepapers and/or reference architecture info on active/active clustering with SQL 05?
Does this amount to an HPC?

--Brian
2  out of 2 found this valuable. Do you?    
todd_muirhead
todd_muirhead
RE: Active/Active Clustering
Jul 17 2008, 1:44 PM EDT
An active/active SQL Server 2005 cluster is really two active/passive clusters. Meaning that each node has an active instance and acts as the passive instance for it's cluster partner. It is not HPC, it is not load balancing, it is still a fail over clustering model to maintain availablity in the event of a failed node.

The problem with active/active is that after a failure the remaining node will have to run all of the load by itself. So if the nodes are running at over 40% each, you could end up with a real performance problem after a failover. This is why some consider the active/active/passive scenario! (Or other varations with more than three nodes in the cluster)

Todd
2  out of 2 found this valuable. Do you?    
brian_summers
brian_summers
RE: Active/Active Clustering
Jul 17 2008, 5:24 PM EDT
Perfect! Makes total sense now.
Much appreciated :-)

--Brian
2  out of 2 found this valuable. Do you?    
Top Contributors
Browse by Keywords
Loading...