Home | Contact Us | FAQ | Search & Site Map | Link to Us
Sign In | Join | Other 45 Sites in Network
Home
Discussion Groups
DB Engine
SQL ServerMSDESQL Server CE
Services
Analysis (Data Mining)Analysis (OLAP)DTSIntegration ServicesNotification ServicesReporting Services
Programming
CLRConnectivitySQLXML
Other Technologies
ClusteringEnglish QueryFull-Text SearchReplicationService Broker
General
Data WarehousingPerformanceSecuritySetupSQL Server ToolsOther SQL Server Topics
DirectoryUser Groups
Related Topics
MS AccessOther DB ProductsMS Server Products.NET DevelopmentVB DevelopmentJava DevelopmentMore Topics ...

SQL Server Forum / Other Technologies / Clustering / May 2006

Tip: Looking for answers? Try searching our database.

4 node cluster

Thread view: 
Enable EMail Alerts  Start New Thread
Thread rating: 
Hassan - 28 May 2006 08:33 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 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

 
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage

Start New Thread
Enable EMail Alerts
Rate this Thread



©2009 Advenet LLC   Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.