none
Multi Instance or Active/ Active Cluster

    Question

  • In an multi instance cluster where you have two nodes with separate SQL Server instances, what's the MS best practice for naming SQL Server instances?

    Can both instances be default? or do they have to be named instances? Also if you were to add a third server in the mix to act as a passive server would that also be named or default? will we have to create two instances on the passive? 

    Please advice.

    Thanks


    SQL Pro

    Friday, October 18, 2013 3:32 PM

Answers

  • You can only have one default instance per cluster, so you should make them both named instances.  Adding a third cluster node would not require an additional SQL instance.  You would add the third cluster node, install each of the two Failover Cluster Instances on the new node and configure the cluster failover policies.

    David


    David http://blogs.msdn.com/b/dbrowne/

    Friday, October 18, 2013 3:51 PM

  • I guess in the case of server A, server B will be passive, in the case of server B, server A will be passive. When we add the third server to each cluster the is server C the new passive for both A and B? and neither B is passive for A or A passive for B?

    Please confirm.

    Thanks


    SQL Pro

    Hello,

    I would like to call it as multi intance cluster first.

    Now for your question when third node will be added both SQL A and SQL B needs to be installed on it by selecting Add node to existing cluster mode.Please refer to below link,some part of it is in Chinese language but you will understand

    http://blogs.msdn.com/b/bradchen/archive/2013/01/12/add-a-node-to-an-existing-two-node-sql-server-2008-r2-cluster.aspx

    Now after you do and configure Node C will be passive for both node A and B if you configure properly.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Saturday, October 19, 2013 7:12 AM

All replies

  • You can only have one default instance per cluster, so you should make them both named instances.  Adding a third cluster node would not require an additional SQL instance.  You would add the third cluster node, install each of the two Failover Cluster Instances on the new node and configure the cluster failover policies.

    David


    David http://blogs.msdn.com/b/dbrowne/

    Friday, October 18, 2013 3:51 PM
  • Just so I can visualize this lets call First Node A, Second B and third C.

    Initially we are planning to have to two nodes A and B. So if I understand correctly both nodes will have their own named instances.

    I guess in the case of server A, server B will be passive, in the case of server B, server A will be passive. When we add the third server to each cluster the is server C the new passive for both A and B? and neither B is passive for A or A passive for B?

    Please confirm.

    Thanks


    SQL Pro

    Friday, October 18, 2013 3:57 PM
  • Is there any documentation or link that someone can point me to for Multi Instance Cluster setup.

    thanks


    SQL Pro

    Friday, October 18, 2013 6:35 PM
  • Hi,

    A similar post should help you.

    http://social.msdn.microsoft.com/Forums/sqlserver/en-US/c35fe863-3fed-4a6e-830b-b79aa032c198/sql-server-clustering-2008-multi-node


    Regards Gursethi Blog: http://gursethi.blogspot.com/ ++++ Please mark "Propose As Answer" if my answer helped ++++

    Friday, October 18, 2013 8:35 PM

  • I guess in the case of server A, server B will be passive, in the case of server B, server A will be passive. When we add the third server to each cluster the is server C the new passive for both A and B? and neither B is passive for A or A passive for B?

    Please confirm.

    Thanks


    SQL Pro

    Hello,

    I would like to call it as multi intance cluster first.

    Now for your question when third node will be added both SQL A and SQL B needs to be installed on it by selecting Add node to existing cluster mode.Please refer to below link,some part of it is in Chinese language but you will understand

    http://blogs.msdn.com/b/bradchen/archive/2013/01/12/add-a-node-to-an-existing-two-node-sql-server-2008-r2-cluster.aspx

    Now after you do and configure Node C will be passive for both node A and B if you configure properly.


    Please mark this reply as the answer or vote as helpful, as appropriate, to make it useful for other readers

    Saturday, October 19, 2013 7:12 AM