Post reply

3 Node 2014 AlwaysOn - Automatic Failover?

  • June 30, 2015 at 4:39 am

    #302131

    I have a 3 node 2014 AlwaysOn setup. The primary and secondary are set for automatic failover. The third node, of course, is manual (until 2016). The 2 nodes with are automatic are sitting in one datacenter, the third is in another. If the first datacenter was to go down, I would manually have to failover to the third node? What's the normal process here for having two datacenters and ensuring the availability group is always available?

    Thanks

  • June 30, 2015 at 5:27 am

    #1809063

    ItsDaveTime (6/30/2015)

    I have a 3 node 2014 AlwaysOn setup. The primary and secondary are set for automatic failover. The third node, of course, is manual (until 2016). The 2 nodes with are automatic are sitting in one datacenter, the third is in another. If the first datacenter was to go down, I would manually have to failover to the third node? What's the normal process here for having two datacenters and ensuring the availability group is always available?

    Thanks

    To start with this all depends on the client connectivity across site.

    To make the group available across site, as I'm sure you're aware, you'll need to set one partner in each datacentre as a synch auto partner. In the event of a primary datacentre failure in the current state you'd be required to force quorum on the remote partner to start the cluster service and then manually bring the asynch database online accepting the possible data loss.

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

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

  • July 1, 2015 at 7:55 am

    #1809487

    Given the scenario, if the first datacenter was to go down, I would manually have to failover to the second datacenter? That doesn't make sense for high availability. Am I missing something?

    Thanks

  • July 1, 2015 at 10:12 am

    #1809584

    ItsDaveTime (7/1/2015)

    Given the scenario, if the first datacenter was to go down, I would manually have to failover to the second datacenter? That doesn't make sense for high availability. Am I missing something?

    Thanks

    if you set the remote database to manual failover that is exactly what you'll get.

    If you want the second site to automatically takeover in the event of a failure then set it to synch commit and switch the auto failover option to this replica

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

    "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