SQL Server AG supported configurations for provisioning an AG VDB
This section covers the AG configurations which are supported by Delphix Engine for provisioning an AG VDB. For this configuration, we will refer to the availability group setup shown in the previous section. We will first see the possible parameters on the SQL Server and then the resulting mapping between the containers created on the Delphix Engine and the SQL Server availability group replicas.
Availability group configuration 1
| Properties | Primary availability replica (PAR) | Secondary availability replica (SAR1) | Secondary availability replica (SAR2) |
|---|---|---|---|
| Server instance | Standalone Instance (SI1) | Standalone Instance (SI2) | Standalone Instance (SI3) |
| Availability mode | Synchronous-commit | Synchronous-commit | Asynchronous-commit |
| Failover mode | Automatic | Automatic | Manual |
| Readable Secondary | Yes/No | Yes/No | Yes/No |
On provisioning an AG VDB on the above configuration, Delphix Engine will create 3 replica database containers.
The below table shows the mapping between these containers and the SQL Server availability group replicas.
| Replica database container | Replica server name | Availability group name | Database name | Is primary replica | Synchronization state |
|---|---|---|---|---|---|
| RAgVdb_ABC | PAR | AG1 | MyAgDatabase | Yes | SYNCHRONIZED |
| RAgVdb_MFD | SAR1 | AG1 | MyAgDatabase | No | SYNCHRONIZED |
| RAgVdb_KIU | SAR2 | AG1 | MyAgDatabase | No | SYNCHRONIZING |
This configuration supports all VDB operations highlighted in Support Matrix for VDB operations across different VDB types with backupBased set to true. It also supports Fast Enable (backupBased = false) operation.
For more information on Fast Enable, refer the following sections:
Availability group configuration 2
| Properties | Primary availability replica (PAR) | Secondary availability replica (SAR1) | Secondary availability replica (SAR2) |
|---|---|---|---|
| Server instance | Standalone instance (SI1) | Standalone instance (SI2) | Standalone instance (SI3) |
| Availability mode | Asynchronous-commit | Asynchronous-commit | Synchronous-commit |
| Failover mode | Manual | Manual | Automatic |
| Readable secondary | Yes/No | Yes/No | Yes/No |
On provisioning an AG VDB on the above configuration, Delphix engine will create 3 replica database containers. The below table shows the mapping between these containers and the SQL Server availability group replicas.
| Replica database container | Replica server name | Availability group name | Database name | Is primary replica | Synchronization state |
|---|---|---|---|---|---|
| RAgVdb_ABC | PAR | AG1 | MyAgDatabase | Yes | SYNCHRONIZED |
| RAgVdb_MFD | SAR1 | AG1 | MyAgDatabase | No | SYNCHRONIZING |
| RAgVdb_KIU | SAR2 | AG1 | MyAgDatabase | No | SYNCHRONIZING |
This configuration supports all VDB operations highlighted in Support Matrix for VDB operations across different VDB types with backupBased set to true. However, it does not support Fast Enable (backupBased = false) operation as for Fast enable to work we need the availability mode for primary replica and at least one healthy secondary replica to be Synchronous commit.