Post reply

Alter Active/passive two nodes to Active/Active cluster

  • December 10, 2014 at 8:43 am

    #295823

    Hi -

    I have 2 nodes (node 1 and node 2) in active/passive mode. Node 1, which is the active node, runs 2 instances (PROD and DEV).

    We have a need to make both nodes active/active cluster from the current Active/passive cluster setting, and migrate DEV instance to node 2. That way we will have node 1 running PROD instance and node 2 running DEV instance.

    Can you please briefly list me the steps I need to take to ensure minimum down time and have a successful setup.

  • December 10, 2014 at 8:49 am

    #1763816

    just move the DEV group to node 2

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • December 10, 2014 at 8:56 am

    #1763820

    As I stated, node 2 is passive. I understand you can just right click on the instance and tell it to move to second node.

    The goal is to make these two nodes active/active.

  • December 10, 2014 at 9:01 am

    #1763823

    lsalih (12/10/2014)

    As I stated, node 2 is passive. I understand you can just right click on the instance and tell it to move to second node.

    The goal is to make these two nodes active/active.

    By moving the instance to node 2 that then represents what was previously known as an active\active configuration.

    Nowadays in Windows Server Failover Clustering they're simply known as multi instance clusters.

    -----------------------------------------------------------------------------------------------------------

    "Ya can't make an omelette without breaking just a few eggs" 😉

  • December 10, 2014 at 9:22 am

    #1763831

    Perry -

    Thanks for the clarification, I will then propose moving the instance.

  • December 10, 2014 at 2:20 pm

    #1763906

    Active-active never meant that both nodes were serving the same databases. That's never been how SQL clustering works. Active-active, before it went out of favour, used to mean two nodes each running their own instance of SQL, serving different databases.

    Gail Shaw
    Microsoft Certified Master: SQL Server, MVP, M.Sc (Comp Sci)
    SQL In The Wild: Discussions on DB performance with occasional diversions into recoverability

    We walk in the dark places no others will enter
    We stand on the bridge and no one may pass

  • December 10, 2014 at 6:36 pm

    #1763941

    Gail, I initially was confused but now I am clear. I already suggested moving the instance to other node. Thank you very much for clarification.

Viewing 7 posts - 1 through 6 (of 6 total)

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