Already a member?
Sign in
Location: SQL Server Whitepapers
Discussion: Active/Active Clustering
Watch
|
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 |
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 |
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? |

