January 9, 2014 at 4:08 am
Hello Friends,
First a very happy new year to the whole community.
As the new year opened, I have been given a challenge to create a two node SQL FCI (Production Site) and 3rd node in the DR site. The production cluster will host 3 instances and 3 availability groups, 1 each from an instance replicating asynchronously to DR site.
My questions :
1) Is it possible to have such a configuration ?
2) what are the "gotchas" I would need to keep in mind ?
Regards,
Dee
January 10, 2014 at 12:24 pm
I'm not entirely clear on your setup from the post. What it sounds like you would want is a SQL 2012 Availability Group environment involving three different nodes (2 at your production site, and another at your DR site).
In that case, you'll want to setup synchronous replication between your production servers and asynchronous to your DR site. I would also highly recommend removing the DR site as a quorum vote in the underlying cluster as you don't want your DR site dictating quorum and potentially shutting down your production environment due to network latency or outage.
Does that answer your questions?
January 12, 2014 at 12:24 pm
deepak.uniyal (1/9/2014)
Hello Friends,First a very happy new year to the whole community.
As the new year opened, I have been given a challenge to create a two node SQL FCI (Production Site) and 3rd node in the DR site. The production cluster will host 3 instances and 3 availability groups, 1 each from an instance replicating asynchronously to DR site.
You want to create an FCI across the 2 Live site nodes and a stand alone instance on the DR node. You then want to add both replicas to 3 AlwaysOn groups, is this correct?
deepak.uniyal (1/9/2014)
My questions :1) Is it possible to have such a configuration ?
Yes, need to clarify a few things first.
deepak.uniyal (1/9/2014)
2) what are the "gotchas" I would need to keep in mind ?Regards,
Dee
When an FCI is added to an AlwaysOn group there is no automatic failover available, it is done manually.
Adding an FCI to an AlwaysOn group requires extra nodes than would normally be necessary to support the AlwaysOn group
-----------------------------------------------------------------------------------------------------------
"Ya can't make an omelette without breaking just a few eggs" 😉
January 14, 2014 at 2:43 am
Thanks for the reply.
What I am planning to do is to have a normal FCI on production site with 3 instances and then a standalone DR box as DR. I want to use one AG per instance to DR it to the standalone. It will be an Async replica.
is it possible ?
Regards,
Dee
Viewing 4 posts - 1 through 4 (of 4 total)
You must be logged in to reply to this topic. Login to reply