MS SQL AAA Clustering Config

Setup – Key aspects to note –

Replica– The replica is a server. There are one primary replica and multiple additional (secondary) replicas. SQL Server 2012 supports up to 4 secondary replicas, while SQL Server 2014 supports up to 8 replicas.

The primary replica is  primary source server or production server. A secondary replica is a server which maintain a backup copy of the primary server availability database. On the Primary replica, it allows to perform Read and write operations while on the secondary replica only read operations.

For example, typically, SQL1 as primary replica and SQL2 a secondary replica is  configured as follows:

Initial Role – It specifies the role of the replica ( Primary or secondary).

Automatic Failover – It failovers the functional role from primary replica to secondary replica by an automated method with no data loss.

Synchronous Commit – In the Synchronous-commit mode, failover can happen by either Automatic or manual way with no data loss. So, in this case, we will use synchronous commit with automatic failover.

Security / authentication –

ADFS can be configured for a highly available geo-distributed scenario.