Announcing General Availability (GA) of Zone Redundancy for Azure SQL Database Hyperscale tier

[Guest Rajesh Setlem]

We are excited to announce the General Availability (GA) of enabling Zone Redundancy for Azure SQL Hyperscale databases. The zone redundant configuration utilizes Azure Availability Zones to replicate databases across multiple physical locations within an Azure region. By selecting zone redundancy, you can make all layers of your Hyperscale databases resilient to a much larger set of failures, including catastrophic datacenter outages, without any changes of the application logic. For more information see Hyperscale zone redundant availability.

 

 

Creating a zone redundant Hyperscale Database

 

 

 

 

A zone redundant Hyperscale database can be created with Portal, Azure CLI, PowerShell, or REST API. Zone redundancy for Hyperscale service tier can only be specified at database creation. This setting cannot be modified once the resource is provisioned. Database copy, point-in-time restore, or creating a geo-replica can be used to update the zone redundant configuration for an existing Hyperscale database.

 

 

Portal

 

 

The following image illustrates how to use Azure portal to configure a new Hyperscale database to be zone redundant. This can be configured in the Configure database blade when creating a new database, creating a geo replica, creating a copy database, doing a point in time restore or doing a geo restore. Zone-redundant or Geo-zone-redundant backup storage and at least 1 High-Availability Secondary Replica must be specified.

 

 

 

 

 

 

CLI

 

 

The following CLI commands can be used to create a zone redundant Hyperscale database using the –zone-redundant {false, true} parameter.

 

• az sql db create
  
• az sql db replica create
  
• az sql db copy
  
• az sql db restore
  

 

The Hyperscale database must have at least 1 high availability replica and zone-redundant or geo-zone-redundant backup storage. Below is an example CLI command for creating a new zone redundant Hyperscale database.

 

 

 

 

 

 

 

 

 

az sql db create -g mygroup -s myserver -n mydb -e Hyperscale -f Gen5 –ha-replicas 1 –-zone-redundant -–backup-storage-redundancy Zone

 

 

 

 

 

PowerShell

 

 

The following PowerShell commands can be used to create a zone redundant Hyperscale database using the -ZoneRedundant parameter.

 

• New-AzSqlDatabase
  
• New-AzSqlDatabaseSecondary
  
• New-AzSqlDatabaseCopy
  
• Restore-AzSqlDatabase
  

 

 

 

The Hyperscale database must have at least 1 high availability replica and zone-redundant or geo-zone-redundant backup storage must be specified. Below is an example PowerShell command for creating a new zone redundant Hyperscale database.

 

 

 

 

 

 

 

New-AzSqlDatabase -ResourceGroupName "ResourceGroup01" -ServerName "Server01" -DatabaseName "Database01" -Edition “Hyperscale” -HighAvailabilityReplicaCount 1 -ZoneRedundant -BackupStorageRedundancy Zone

 

 

 

 

 

 

 

Current Limitations

 

 

 

 

• Zone redundant configuration can only be specified during database creation. This setting cannot be modified once the resource is provisioned. Database copy, point-in-time restore, or creating a geo-replica can be used to update the zone redundant configuration for an existing Hyperscale database. When using one of these update options, if the target database is in a different region than the source or if the database backup storage redundancy from the target differs from the source database, the copy operation will be a size of data operation.
  
• Named replicas are not currently supported.
  
• Only Gen5 compute is supported.
  
• Zone redundancy cannot currently be specified when migrating an existing database from another Azure SQL Database service tier to Hyperscale.
  

Regions where this is available

 

 

All Azure regions that have Availability Zones support zone redundant Hyperscale database.

 

Continue reading...