Skip to content

Zone-Redundant High Availability#

Reliability · Azure Database for PostgreSQL · Rule · 2024_09 · Important

Deploy Azure Database for PostgreSQL servers using zone-redundant high availability (HA) in supported regions to ensure high availability and resilience.

Description#

Azure Database for PostgreSQL flexible servers allows configuration high availability (HA) across availability zones in supported regions. Using availability zones improves resiliency of your solution to failures or disruptions isolated to a zone or data center.

Zone-redundant HA works by:

  • Deploying two servers; a primary in one zone, and a secondary in a physically separate zone.
  • Daily Data Backups: Performed from the primary server and stored using zone-redundant backup storage.
  • Transaction Logs: Continuously archived in zone-redundant backup storage from the standby replica.

The failover process ensures continuous operation by switching from the primary server to the standby replica server. This process can be:

  • Manual (Planned) Failover: Initiated by the user for maintenance or other operational reasons.
  • Automatic (Unplanned) Failover: Triggered by Azure in response to failures such as hardware or network issues affecting the primary server.

Before opting for the zone-redundant HA model, review the documentation for additional limitations and critical information. This includes understanding the latency impact between zones, cost implications, and any specific regional support constraints.

Recommendation#

Consider deploying flexible servers using zone-redundant high-availability to improve the resiliency of your databases.

Examples#

Configure with Azure template#

To configure servers that pass this rule:

  • Set the properties.highAvailability.mode property to ZoneRedundant.

For example:

Azure Template snippet
{
  "type": "Microsoft.DBforPostgreSQL/flexibleServers",
  "apiVersion": "2023-03-01-preview",
  "name": "[parameters('serverName')]",
  "location": "[parameters('location')]",
  "sku": {
    "name": "Standard_D16as",
    "tier": "GeneralPurpose"
  },
  "properties": {
    "administratorLogin": "[parameters('administratorLogin')]",
    "administratorLoginPassword": "[parameters('administratorLoginPassword')]",
    "createMode": "Default",
    "version": "[parameters('postgresqlVersion')]",
    "availabilityZone": "1",
    "highAvailability": {
      "mode": "ZoneRedundant",
      "standbyAvailabilityZone": "2"
     }
  }
}

Configure with Bicep#

To configure servers that pass this rule:

  • Set the properties.highAvailability.mode property to ZoneRedundant.

For example:

Azure Bicep snippet
resource postgresqlDbServer 'Microsoft.DBforPostgreSQL/flexibleServers@2023-03-01-preview' = {
  name: serverName
  location: location
  sku: {
    name: 'Standard_D16as'
    tier: 'GeneralPurpose'
  }
  properties: {
    administratorLogin: administratorLogin
    administratorLoginPassword: administratorLoginPassword
    createMode: 'Default'
    version: postgresqlVersion
    availabilityZone: 1
    highAvailability: {
      mode: 'ZoneRedundant'
      standbyAvailabilityZone: 2
    }
  }
}

Configure with Azure Verified Modules

A pre-validated module supported by Microsoft is available from the Azure Bicep public registry. To reference the module, please use the following syntax:

br/public:avm/res/db-for-postgre-sql/flexible-server:<version>

To use the latest version:

br/public:avm/res/db-for-postgre-sql/flexible-server:0.3.1

Notes#

The Burstable SKU tier is not supported.

The zone-redundancy HA model is only available in regions that support availability zones.

Comments