November 17, 2016 at 1:05 am
Hi Guys,
I was recently reading a very good article on Distributed Availability Groups by http://www.sqlservercentral.com/Authors/Articles/Jennifer_Brocato/1972242/
However it's dawned on me since reading it that I am not entirely sure when one would use it?
Does anyone have a link to a case study or just an example?
If I had a 2014 'normal' Availability Group with each replica in a different data center, what gap does 2016's Distributed ability plug?
Also, reading this: https://msdn.microsoft.com/en-US/library/mt651673.aspx I am getting confused with the references to a Failover Cluster -- I know that Availability Groups uses the WSFC functionality but I didn't think it was referred as a Failover Cluster per se -- that could just be terminology though.
Cheers All
Alex
November 17, 2016 at 1:54 am
I haven't managed to set up a test environment for myself yet (I might try to do it in Azure), but some use cases that interest me are;
- you can span multiple WSFCs
- your AGs can be on different versions of Windows Server, so you could use one when performing an operating system upgrade - presumably it would be one-way).
November 17, 2016 at 2:30 am
Based on this recording https://channel9.msdn.com/Events/Connect/2016/136, I think it may be possible to use Distributed AGs to migrate from Windows to Linux, too.
November 17, 2016 at 7:26 am
Hiya!
[quoteyou can span multiple WSFCs
It's precisely this aspect that is confusing me! What is the benefit of spanning a group of multiple clusters?
And I thought Availability Groups were meant to remove the cluster from clustering?
Cheers!
November 17, 2016 at 7:30 am
alex.sqldba (11/17/2016)
Hiya!It's precisely this aspect that is confusing me! What is the benefit of spanning a group of multiple clusters?
Well, I wasn't sure either but I recently spoke to somebody who has two clusters, each in different datacentres, because their organisation won't allow one cluster to span both. On SQL 2012 & 2014 they couldn't use AGs across the two datacentres, but on 2016 they could.
And I thought Availability Groups were meant to remove the cluster from clustering?
Cheers!
Can you expand a little on that?
November 17, 2016 at 9:19 am
Uha!!!! Now that makes perfect sense!
Ignore my last comment, I think it was a Brain-Fart.
Cheers!
November 21, 2016 at 7:15 pm
It would be cool for AG clusters to be in different domains.
Anyone know if distributed AG groups work on different domains?
I can't find it here:
https://msdn.microsoft.com/en-us/library/mt651673.aspx
November 22, 2016 at 1:52 am
I don't think so.
Viewing 8 posts - 1 through 7 (of 7 total)
You must be logged in to reply to this topic. Login to reply