Post reply

Please help with SQL 2008 R2 Active\Active Cluster installation

  • March 13, 2012 at 9:00 am

    #252440

    Hi friends,

    I need to know how many Virtual Names i need to order to successfully setup an Active/Active SQL Cluster between two nodes.

    I have node1, and node2 and want each of them to be an active/passive node to one another.

    Please tel that's possible or i need additional nodes for this?

  • March 13, 2012 at 9:57 am

    #1458611

    if you want to run two instances one on each node then you need two virtual names SQL01\INSTANCE01 and SQL02\INSTANCE02 for example, then if they are resources in the same cluster, when one fails it will move between the nodes.

    i would put some checking in place as you would want to be notified as soon as it fails over to fail it back as you wouldnt want to run two instances on the same node if they are both set to use 90% of the hosts memory for example.

  • March 13, 2012 at 10:47 am

    #1458658

    You'll also need to have a virtual name for the cluster itself (if you've not taken that into account)


    Shamless self promotion - read my blog http://sirsql.net

  • March 13, 2012 at 11:28 am

    #1458704

    Hi,

    Thanks for the input.

    My worry is once the first instance is setup and 1 node is added to it.

    How do i setup the Second instance? do i follow the same steps or i have to add more nodes to existing setup?

  • March 13, 2012 at 12:24 pm

    #1458743

    THE-FHA (3/13/2012)

    Hi,

    Thanks for the input.

    My worry is once the first instance is setup and 1 node is added to it.

    How do i setup the Second instance? do i follow the same steps or i have to add more nodes to existing setup?

    how many nodes are part of the windows cluster at present?

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

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

  • March 13, 2012 at 11:15 pm

    #1458987

    two nodes and there will not be more than them.

  • March 14, 2012 at 9:10 am

    #1459270

    THE-FHA (3/13/2012)

    two nodes and there will not be more than them.

    ok, so install first instance on node a and then run add node wizard on node b

    Then install second instance on node b and run add node wizard on node a

    or

    just install both instancers on one node run add node on node b for each instance and then move the groups to the desired node

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

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

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

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