Add third node sql cluster

  • I have a 2 node cluster (2-physical servers) “instance1” is passive for “instance2” & “instance2” is passive for "instance1" vice versa.

    I want to add/install 3rd SQL “instance3”. No test server to test, I hope it’s just an --> Add node to a SQL server fail-over cluster. Any suggestion or prerequisites.

    SQL and Windows = 2008 R2

    Thanks for your help.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • muthukkumaran Kaliyamoorthy (11/7/2013)


    I have a 2 node cluster (2-physical servers) “instance1” is passive for “instance2” & “instance2” is passive for "instance1" vice versa.

    I want to add/install 3rd SQL “instance3”. No test server to test, I hope it’s just an --> Add node to a SQL server fail-over cluster. Any suggestion or prerequisites.

    SQL and Windows = 2008 R2

    Thanks for your help.

    You'll need to present shared storage to the nodes for the new instance and set the new disks up as cluster resources, once done you can run the wizard on one node and create a new failover clustered instance, then run the add node wizard on the remaining node.

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

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

  • Perry Whittle (11/7/2013)


    muthukkumaran Kaliyamoorthy (11/7/2013)


    I have a 2 node cluster (2-physical servers) “instance1” is passive for “instance2” & “instance2” is passive for "instance1" vice versa.

    I want to add/install 3rd SQL “instance3”. No test server to test, I hope it’s just an --> Add node to a SQL server fail-over cluster. Any suggestion or prerequisites.

    SQL and Windows = 2008 R2

    Thanks for your help.

    You'll need to present shared storage to the nodes for the new instance and set the new disks up as cluster resources, once done you can run the wizard on one node and create a new failover clustered instance, then run the add node wizard on the remaining node.

    Thanks Perry Whittle. I understand that, i need to run the wizard on passive node/server or do i need one more server for the third instance. and also is there any downtime for the existing cluster resource/server.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • I did some online searching. Here is the step I have to perform. Am I missing anything.

    > Need a Shared disk

    > Need a Third server/node

    > create a new failover windows cluster on node3

    > Install new SQL server failover cluster

    > Add node3 to other nodes 1&2

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • muthukkumaran Kaliyamoorthy (11/7/2013)


    Thanks Perry Whittle. I understand that, i need to run the wizard on passive node/server or do i need one more server for the third instance.

    No, you dont need a 3rd node.

    muthukkumaran Kaliyamoorthy (11/7/2013)


    and also is there any downtime for the existing cluster resource/server.

    Not when insalling a new instance. Unless of course you want to install on a node where an existing instance is running and there are pending reboots, an outage would be required then to reboot the server before commencing installation.

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

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

  • muthukkumaran Kaliyamoorthy (11/8/2013)


    I did some online searching. Here is the step I have to perform. Am I missing anything.

    > Need a Shared disk

    > Need a Third server/node

    > create a new failover windows cluster on node3

    > Install new SQL server failover cluster

    > Add node3 to other nodes 1&2

    No, that is incorrect. You can stay with 2 nodes and just install a 3rd instance. First thing you need is shared disks for the new instance, these must be attached to the nodes and configured as cluster resources.

    Once done, you may then move the new storage to the node wheer you want to start the install, use the option to create new failover cluster instance. Once installed, use the add node wizard on the remaining node

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

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

  • Thank you. Here is the steps:

    > Need a Shared disk should be present in the nodes and must be a cluster resource.

    http://blogs.technet.com/b/askcore/archive/2009/01/14/adding-a-new-disk-to-an-existing-windows-2008-cluster.aspx?Redirected=true

    > Use “Install new SQL server failover cluster installation” from SQL setup.exe in one of the nodes where the new drive is active/ available.

    > Use “Add node to the SQL server failover cluster” to add other nodes from SQL setup.exe.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

  • That is correct

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

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

  • Thanks Perry Whittle. It helps me.

    Muthukkumaran Kaliyamoorthy
    https://www.sqlserverblogforum.com/

Viewing 9 posts - 1 through 8 (of 8 total)

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