Actually I have to setup a 3 node cluster.

  • 2 node cluster is easy.

    What to do either its a 3 node or 16 node cluster.What concept we should follow?

    Actually I have to setup a 3 node cluster.

    Is there any technet link for 3 node cluster creation.

    Thanks

  • forsqlserver (11/29/2011)


    2 node cluster is easy.

    What to do either its a 3 node or 16 node cluster.What concept we should follow?

    Actually I have to setup a 3 node cluster.

    Is there any technet link for 3 node cluster creation.

    I'm not quite following you here. Are you trying to decide between a 3 node cluster and a 16 node cluster? The "concept" of clustering is the same between a 3 node and a 16 node cluster (or a 6 node and a 2 node). but, you "..have to setup a 3 node cluster" so what's your question?

    You should be able to find an article on technet for adding a node to an existing cluster. Setup a 2 node cluster, and add a third node.

  • If I add a third node what it will be considered as: Active or Passive

    Thanks

  • active or passive doesn't depend on number of nodes. It depends on the number of sql instances.

    2 node cluster with 1 sql instance is active/passive.

    2 node cluster with 2 sql instance is active/active.

    3 node cluster with 1 sql instance is active/passive/passive.

    3 node cluster with 2 sql instance is active/active/passive.

    3 node cluster with 3 sql instance is active/active/active.

    How many sql instances are you installing?

  • Thats True Spring Thanks.

    Thanks

Viewing 5 posts - 1 through 4 (of 4 total)

You must be logged in to reply to this topic. Login to reply