Clustering / AlwaysOn Availability Groups

  • Morning All,

    I might be in the wrong forum here, but let's see.

    I am building a 4 Node cluster for AlwaysOn Availability Groups - this is a shared nothing cluster. Importantly this is spread across two data centers.

    Windows Server 2012 R2 is the OS on each node.

    I've been allocated an IP range:

    In Colo1: 172.16.7.N

    In Colo2: 172.18.7.N

    When creating the cluster in Cluster Manager, it asks me to specify an Admin Access Point, where typically when I have done this is asks for IP Address to manage the cluster on. But in this instance it's asking for two. One in each Subnet I listed above.

    And so I create 2 of them and continue.

    All work, so far, however it only brings one of the Admin Access points IP's online.

    Is this to be expected? Should I have specified two IP's at this point in the set up? Could I have assigned them both the same IP?

    In this case, I gave them the following IPs for the Admin Access points:

    172.16.7.101

    172.18.7.101

    Any help would be appreciated, as I am struggling to get a hit using google, the search terms just seem a bit vague and take me off on tangents..

    Cheers

    Alex

  • alex.sqldba (2/4/2016)


    Morning All,

    I might be in the wrong forum here, but let's see.

    I am building a 4 Node cluster for AlwaysOn Availability Groups - this is a shared nothing cluster. Importantly this is spread across two data centers.

    A good cluster design should have an odd number of nodes, more and more you see clusters designed with an even number of nodes. Forcing you to implement disk or fileshare witness resources

    alex.sqldba (2/4/2016)


    Windows Server 2012 R2 is the OS on each node.

    This is the best choice, R2 offers improvements in the clustering subsystem to help maintain cluster resilience.

    alex.sqldba (2/4/2016)


    I've been allocated an IP range:

    In Colo1: 172.16.7.N

    In Colo2: 172.18.7.N

    When creating the cluster in Cluster Manager, it asks me to specify an Admin Access Point, where typically when I have done this is asks for IP Address to manage the cluster on. But in this instance it's asking for two. One in each Subnet I listed above.

    And so I create 2 of them and continue.

    You have a multi subnet cluster so you'll need an access point from each location.

    Can you post the results of this Powershell query please (substitute xxx for the resource name of the cluster networkname)

    get-clusterresource "xxx" | get-clusterparameter

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

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

  • Cheers Perry! You reply highlighted something I was missing - more so in my head than elsewhere! I am now having a problem with Read only routing but ill put that in another post as not really relevant in this thread! Cheers again!

    Alex

  • alex.sqldba (2/8/2016)


    I am now having a problem with Read only routing but ill put that in another post as not really relevant in this thread

    post up a much detail as possible and we'll take a look

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

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

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

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