Say If I build a 4 node cluster where 3 nodes are active and 1 is passive ,
is it possible theoretically for the 1 node to take over the 3 active nodes
onto itself should all 3 nodes fail ?
Or is clustering setup only enabled for just one node to failover at a time
?
Where can I read more ?
Linchi Shea - 28 May 2006 18:16 GMT
Sure, the spare node can be configured to take all three instances. But in
this particular sceanrio, there will likely be performance hit and the
performance hit could be severe.
Typically, in a 3+1 cluster (i.e. three nodes are configured to run an
instance each in a normal operationg mode, and the fourth node is left
standby), we write the SLA to support failure on a single node at any given
time. If the business is not okay with the performance of running two or more
instances on the spare node, you should condsider having multiple two-node
clusters, each of which runs a single SQL instance.
Linchi
> Say If I build a 4 node cluster where 3 nodes are active and 1 is passive ,
> is it possible theoretically for the 1 node to take over the 3 active nodes
[quoted text clipped - 4 lines]
>
> Where can I read more ?
Russ Kaufmann [MVP] - 30 May 2006 17:41 GMT
> Say If I build a 4 node cluster where 3 nodes are active and 1 is passive
> , is it possible theoretically for the 1 node to take over the 3 active
[quoted text clipped - 4 lines]
>
> Where can I read more ?
Maybe, maybe not.
For example, in Exchange, the answer is absolutely no. For file shares, the
answer is an asolutely maybe (depending on computing resources).

Signature
Russ Kaufmann
MVP - Windows Server - Clustering
ClusterHelp.com, a Microsoft Certified Gold Partner
Web http://www.clusterhelp.com
Blog http://msmvps.com/clusterhelp