Windows 2003 - Majority Node Set Quorum (MNS), is an optional feat

Discussion in 'Clustering' started by SUGAR, Jul 20, 2005.

  1. SUGAR

    SUGAR Guest

    As the title says:
    i read in this internet aricle:
    http://www.wown.com/articles_tutorials/Cluster-Quorums.html
    and they says that Windows 2003 ntroduced a new type of quorum called the
    Majority Node Set Quorum (MNS). Well... in a nutshell with MNS you must have
    at least three nodes in the cluster.
    Im planning to install windows 2003 with 2 nodes and 1 quorum... do I have
    other option than MNS in order to use only 2 nodes instead of 3 at least?

    thanks
     
    SUGAR, Jul 20, 2005
    #1
    1. Advertisements

  2. Rodney R. Fournier [MVP], Jul 20, 2005
    #2
    1. Advertisements

  3. SUGAR

    SUGAR Guest

    Thanks that answered my question af all.
    Just need an advice. This is my first time with clustering.
    I think i have the resources for set up a sqlserver2000 with a windows2003
    failover cluster server.
    My question is where can i buy my quorum and what kind of quorum is the most
    commercial / or ease to use/install.
    NOTE: I have a 320UltraSCSI ouput in my server.

    thanks in advance.
     
    SUGAR, Jul 20, 2005
    #3
  4. MNS requires that you maintain a majority. Using only two nodes will not
    allow you to maintain a majority in the event of the failure of a single
    node.

    What are you trying to do that you think MNS will be a good solution?

    --
    Russ Kaufmann

    MVP - Windows Server - Clustering
    http://spaces.msn.com/members/russkaufmann - Blog
    http://www.itsummitseries.com/summits/clustering/mscs.htm - Cluster Summit
     
    Russ Kaufmann [MVP], Jul 20, 2005
    #4
  5. SUGAR

    SUGAR Guest

    As i said in the top post question, I just want to know id MNS is an
    Optional Component of Win2003 when clustering. I didnt say that I would like
    to use it.
    In the other hand, i want to install the RMS (retail management system, by
    Microsoft) in a 2 node faiorver cluster with 1 quorum.

    Other thing (i think i have to post the follow elsewhere) is if i have to
    install SqlServer2000 in order to approach the failover capabilities of
    hardware/sofware or it can works with MSDE too.

    thanks all.
     
    SUGAR, Jul 20, 2005
    #5
  6. See the Cluster HCL for info.
    http://www.microsoft.com/windows/ca...duct&pgn=8b712458-b91c-4a7d-8695-23e9cd3ae95b
     
    Russ Kaufmann [MVP], Jul 20, 2005
    #6
  7. It is not an option for only 2 nodes. You must have at least three nodes to
    allow a failure and still maintain a majority.
    If you want to use a server cluster to host SQL, it must have shared disks.

    --
    Russ Kaufmann

    MVP - Windows Server - Clustering
    http://spaces.msn.com/members/russkaufmann - Blog
    http://www.itsummitseries.com/summits/clustering/mscs.htm - Cluster Summit
     
    Russ Kaufmann [MVP], Jul 20, 2005
    #7
  8. You will need SQL Server 2000 Enterprise for failover clustering.

    --
    Chuck Timon, Jr.
    Microsoft Corporation
    CCE Beta Engineer
    This posting is provided "AS IS" with no
    warranties, and confers no rights.
     
    Chuck Timon [MSFT], Jul 21, 2005
    #8
  9. hi Sugar!

    There is no way to cluster msde. only sql2000enterprise is clusteraware.
    however with sql2005standard edition a two node cluster will be supported.

    gerald aigenbauer.
     
    Gerald Aigenbauer, Jul 21, 2005
    #9
    1. Advertisements

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments (here). After that, you can post your question and our members will help you out.