SQL Server Performance

N+1

Discussion in 'SQL Server 2005 Clustering' started by california6, Jun 18, 2007.

  1. california6 New Member

    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,
    Cali
  2. MohammedU New Member

    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.
    Moderator
    SQL-Server-Performance.com

    All postings are provided “AS IS” with no warranties for accuracy.
  3. california6 New Member

    Thanks a lot for your reply. I shall look into our best friend (BOL) and see, what they advice.

    Thank you MohammedU.
    Cali
  4. satya Moderator

    http://www.microsoft.com/technet/technetmag/issues/2007/03/sqlclusters/default.aspx
    http://www.microsoft.com/technet/technetmag/issues/2005/05/SQLCluster/

    Satya SKJ
    Microsoft SQL Server MVP
    Writer, Contributing Editor & Moderator
    http://www.SQL-Server-Performance.Com
    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.

Share This Page