N+1 | SQL Server Performance Forums

SQL Server Performance Forum – Threads Archive


Few questions about clustering: Can i have 3 active nodes and one passive node? If yes,
what’s the advantage of this setup? What is N+1? Also how do i setup a 3 active and passive node? Is there any step-by-step documentation on this? Appreciated some advice. Many thanks,
Yes, you can have 3 active nodes and one passive node…
Now MS changed the terminology… not any more active/active and active/passive cluster…it is called multi node cluster… In 3 active and one passive cluster… you will have one server doing nothing and waiting some other server to failover…. You have to configure cluster in such a way that it should fail first to the passive node if it is not available then it should go the other node… BOL is the best friend in this regard…you install one node or 4 node.. it is the same…. MohammedU.
SQL-Server-Performance.com All postings are provided “AS IS” with no warranties for accuracy.

Thanks a lot for your reply. I shall look into our best friend (BOL) and see, what they advice. Thank you MohammedU.
http://www.microsoft.com/technet/technetmag/issues/2005/05/SQLCluster/ Satya SKJ
Microsoft SQL Server MVP
Writer, Contributing Editor & Moderator
This posting is provided AS IS with no rights for the sake of knowledge sharing. Knowledge is of two kinds. We know a subject ourselves or we know where we can find information on it.