High Availability
Many services within Microsoft Azure provide automatic high availability by replicating to other zones with a region. Typically each region will have at least 3 zones. But services are zonal and through SKU choice or configuration the extra zones are enabled.
The following table lists the resources currently supported by SQLBuild and details the Azure and SQLBuild zone redundant options available:
| SQLBuild Resource | Azure Zone Redundancy | SQLBuild Zone Redundancy | Notes |
|---|---|---|---|
| azAdGroup | Zone Redundant | n/a | Stored in Azure Active Directory which is internally stored in a highly available CosmosDB replicated worldwide. |
| azAdUser | Zone Redundant | n/a | Stored in Azure Active Directory which is internally stored in a highly available CosmosDB replicated worldwide. |
| azAppConfigStore | Zone Redundant | n/a | Regional service automatically replicated between zones within a region. |
| azBastion | Zone Redundant | n/a | Bastion VMs are regional and therefor eMS will make available in all zones |
| azDdosProtectionPlan | Zone Redundant | n/a | A DDOS Plan covers the whole region. |
| azDisk | LRS skus = Zonal | Yes | Use Site Recovery between zones to become zone redundant, but data loss will occur. |
| ZRS skus = Zone Redundant | Yes | ZRS disks can be mounted simultaneously by VMs in multiple zones. | |
| azEventHub | Zonal | No | Use Event Hub clusters for availability zone support. |
| azKeyVault | Zone Redundant | n/a | Can take up to 20 minutes to failover, primary keyvault is in read only whilst failover occurs. |
| azLocalNetworkGateway | Zone Redundant | n/a | Local network gateways are connected to virtual network gateways which are zone redundant. |
| azManagedIdentity | Zone Redundant | n/a | Stored in Azure Active Directory which is internally stored in a highly available CosmosDB replicated worldwide. |
| azManagementGroup | Zone Redundant | n/a | Stored in Azure Active Directory which is internally stored in a highly available CosmosDB replicated worldwide. |
| azNetworkInterface | n/a | n/a | Not required, should be part of your network design in your chosen DR region. |
| azNetworkSecurityGroup | n/a | n/a | Not required, should be part of your network design in your chosen DR region. |
| azPublicIP | Zonal, Standard SKU is Zone Redundant | Yes | |
| azRecoveryServicesVault | n/a | n/a | Recovery Service Vault is a logical construct. |
| azResourceGroup | n/a | n/a | Just a logical construct. |
| azRouteTable | n/a | n/a | Not required, should be part of your network design in your chosen DR region. |
| azSqlDatabase | Basic, Standard, GP Skus = Zonal | Yes | Databases are zonal but backups are zone redundant. |
| GP Sku allows Zone Redundancy | Yes | General Purpose SKU allows ZoneRedundant option to be enabled. | |
| azSqlInstance | Zonal | n/a | Instance is only locally redundant within a zone |
| azSqlServer | n/a | n/a | Logical construct. |
| azStorage | LRS skus = Zonal | Yes | Choice of SKU dictates zonal or zone redundant |
| ZRS skus = Zone Redundant | Yes | Choice of SKU dictates zonal or zone redundant | |
| azSubnet | Zone Redundant | n/a | |
| azSubscription | Zone Redundant | n/a | Automatically highly replicated by the Azure cloud. |
| azVirtualMachine | Zonal | n/a | Site Recovery can replicate VMs to another zone. |
| azVirtualNetwork | Zone Redundant | n/a | Not required, should be part of your network design in your chosen DR region. |
| azVirtualNetworkGateway | xxx skus = Zonal | Yes | SKU dictates if gateway is zonal or zone redundant. |
| xxxAZ skus = Zone Redundant | Yes | SKU dictates if gateway is zonal or zone redundant. |