August 25, 2022 at 12:22 pm
Hi
we have several 2 node failover clusters with single storage, that I'd like to add availability groups to.
Off the top of my head I'd need to enable availability groups on the SQL engine, Create a listener, create the AG (s), and somehow convert single storage to two separate copies of the data, point the application s to the listeners.
These are live production systems. Has anyone done this before? Is there any good documentation on how to do this. I'm hoping there's a relatively easy way to layer the AG on the existing failover cluster
Cheers
Alex
August 25, 2022 at 5:58 pm
What is the reasoning behind moving from FCI to AOAG?
If your only bothered about the HA feature then why go through the pain and just leave them as an FCI.
If your doing it to add in a DR replica later on you can actually mix FCI and AOAG in the same WSFC so you don’t need to split the FCI to also have an AG.
Also what edition of SQL do you have installed Standard or Enterprise? How many databases and do they all need to fail as a group or can you have a split brain where certain databases are one one replica and others on a different replica. Do you do any cross database querying?
Understanding the reasoning behind wanting to break the setup in such a way and also what the application topology is like may give better insights into if you should do this action or not.
August 26, 2022 at 7:23 am
Hi Ant
all those issues are more detail than want to go into in a forum post. TBH I'm not looking for advice on whether I should do it. I'm more than able to make that decision. I've used both AG's and FCI for years, I just never previously added an AG to an existing FCI. I'm after technical insight on the steps to achieve it.
Thanks for the reply though
Cheers
Alex
August 29, 2022 at 5:24 am
This was removed by the editor as SPAM
Viewing 4 posts - 1 through 3 (of 3 total)
You must be logged in to reply to this topic. Login to reply