SQLTeam.com | Weblogs | Forums

Alwayson on Cluster


#1

Hi all,
I tested that you cannot have alwayson availability group set to auto failover with a 2-node cluster + a stanalone server, eg, Cluster Node A & B with standalone instance C. A+B can setup to have availability group to C with sync mode but it cannot be set to auto failover on SQL 2014 where it giving me errors and said its not supported.

Its all good and I understand its not supported, however, i don't seems to be able to find any doc online (public or MS) saying that is not supported, not too sure am i missing something here, did anyone come across any of those doc? Would be helpful if you can share that with me.
Thanks


#2

I am not following you. Availability Groups do support automatic failovers.


#3

Hi Tara,
I mean AG on WSFC (2-node cluster) + Stanealone server. Which I cannot set AG to be automatic failover on the cluster node. Let me put in more details:

Node A + Node B to form a cluster (SQL instance SQL-A)
Standalone C - SQL-C

SQL-A and SQL-C is part of the AG group

When node A fail, node B will take over (as its cluster), and AG will work in Node B
If Node B fails afterwards, meaning SQL-A will go offline, AG will not failover to SQL-C.

Hope this means it more clear. And I understand the behavior, I just want to see where I can find a doc from MS saying its not supported.


#4

Yes that is not supported. Availability Groups are done on standalone instances. Turn your current cluster into an AG cluster, meaning each node has its own instance.


#5

Hi Tara,
I understand its not supported, but do you aware of any doc from MS saying the same? I would like to find that.
Thanks