June 12, 2018 at 1:45 pm
I have a 2 node AlwaysOn Availability group I want to create. One node will be in one data center and the other node will be in a second data center. If the connection to the primary data center is severed, then the primary server would be unable to communicate to the secondary to tell it to make itself active. How would I configure this installation so that if the primary data center connection was severed, the secondary would become active?
June 13, 2018 at 1:21 am
Set it to synchronous and automatic failover, just remember to have a script that will periodically copy users/jobs/credentials etc to the secondary.
June 13, 2018 at 7:03 am
Make sure you have a file-share witness at a third site.
June 28, 2018 at 9:34 am
You'd need a quorum - either file share, or disk (or even a third node!).
June 28, 2018 at 9:55 am
The latency between the data centers should determine if you choose synchronous or asynchronous. In synchronous mode, the commits occur at the secondary first, and then are committed at the primary. If the latency is too high, this will cause the application to appear to be "hung". Automatic failover is not possible with async, so in the event of a disaster, you will need to manually perform the failover.
Are the IP addresses of the servers in different subnets? If so, you will need to add two IP addresses to the listener, and modify the applications connect string to include "MultiSubnetFailover=True". When a connection is attempted to the listener, it will attempt to connect to both IP's, and whichever is active it will connect to.
I suggest reading this series of articles.
http://www.sqlservercentral.com/stairway/112556/
Michael L John
If you assassinate a DBA, would you pull a trigger?
To properly post on a forum:
http://www.sqlservercentral.com/articles/61537/
June 29, 2018 at 2:30 am
Sorry to hijack the thread, but in a File Share witness, what permissions are required in the file share and who too?
https://www.sqlservercentral.com/Forums/1971491/SQL-2017-FCI-with-File-Share-Witness-permissions
qh
Viewing 6 posts - 1 through 5 (of 5 total)
You must be logged in to reply to this topic. Login to reply