Understanding availability group configurations

The below diagram shows a Windows Server Failover Cluster (WSFC) with 4 nodes. Each node hosts a standalone SQL Server instance. This windows cluster contains 2 roles, a SQL Server Availability group and a SQL Server Failover cluster instance. The availability group consists of 3 replicas, and the Failover cluster instance consists of 2 nodes.

SQL Server AG Overview Architecture

Suppose the cluster setup shown above is healthy and it is already discovered on the Delphix Engine. In this case, when an AG Virtual database container “AgVdb” is provisioned on availability group “AG1” with database name “MyAgDatabase”, following components will be created in the Delphix engine -

AG Virtual Database Container

Name

VDB Operations

Availability Database

AgVdb

Allowed

MyAgDatabase

 

Replica Database Containers associated with AG Virtual Database Container

Name VDB operations Primary database container Secondary database container
RAgVdb_ABC Not Allowed Yes No
RAgVdb_MFD Not Allowed No No
RAgVdb_KIU Not Allowed No Yes
Replica database container is named as R<AG_VDB_NAME>_<3 Random Characters>