patternsqlMinor
SQL Server 2012 Availability Group is it "AlwaysON"?
Viewed 0 times
2012groupsqlavailabilityserveralwayson
Problem
In a traditional SQL Server cluster when failover occurs, all clients that are connected to the SQL Server failed instance lose connections and each client must re-establish a new connection to failover cluster instance.
Does AlwaysON Availability Group mitigate this problem? Is failover in case of SQL Server 2012 AlwaysON availability group transparent to clients connecting to the SQL Server?
Does AlwaysON Availability Group mitigate this problem? Is failover in case of SQL Server 2012 AlwaysON availability group transparent to clients connecting to the SQL Server?
Solution
For those reading this post later as a result of a web search. It is indeeded described in SQL Server BOL here. Doh... I could not find it earlier....
Behavior of Client Connections on Failover
When an availability group failover occurs, existing persistent connections to the availability group are terminated and the client must establish a new connection in order to continue working with the same primary database or read-only secondary database. While a failover is occurring on the server side, connectivity to the availability group may fail, forcing the client application to retry connecting until the primary is brought fully back online.
If the availability group comes back online during a client application’s connection attempt but before the connect timeout period, the client driver may successfully connect during one of its internal retry attempts and no error will be surfaced to the application in this case.
Behavior of Client Connections on Failover
When an availability group failover occurs, existing persistent connections to the availability group are terminated and the client must establish a new connection in order to continue working with the same primary database or read-only secondary database. While a failover is occurring on the server side, connectivity to the availability group may fail, forcing the client application to retry connecting until the primary is brought fully back online.
If the availability group comes back online during a client application’s connection attempt but before the connect timeout period, the client driver may successfully connect during one of its internal retry attempts and no error will be surfaced to the application in this case.
Context
StackExchange Database Administrators Q#25124, answer score: 4
Revisions (0)
No revisions yet.