Skip to content

Configure geo-redundant backup#

Reliability · Azure Database for MariaDB · 2022_12

Azure Database for MariaDB should store backups in a geo-redundant storage.

Description#

Geo-redundant backup helps to protect your Azure Database for MariaDB Servers against outages impacting backup storage in the primary region and allows you to restore your server to the geo-paired region in the event of a disaster.

When the backups are stored in geo-redundant backup storage, they are not only stored within the region in which your server is hosted, but are also replicated to a paired data center.

Check out the NOTES and the LINKS section for more details about geo-redundant backup.

Recommendation#

Configure geo-redundant backup for Azure Database for MariaDB.

Examples#

Configure with Azure template#

To deploy Azure Database for MariaDB Servers that pass this rule:

  • Set the properties.storageProfile.geoRedundantBackup property to Enabled.

For example:

Azure Template snippet
{
  "type": "Microsoft.DBforMariaDB/servers",
  "apiVersion": "2018-06-01",
  "name": "[parameters('serverName')]",
  "location": "[parameters('location')]",
  "sku": {
    "name": "[parameters('skuName')]",
    "tier": "GeneralPurpose",
    "capacity": "[parameters('SkuCapacity')]",
    "size": "[format('{0}', parameters('skuSizeMB'))]",
    "family": "[parameters('skuFamily')]"
  },
  "properties": {
    "createMode": "Default",
    "version": "[parameters('mariadbVersion')]",
    "administratorLogin": "[parameters('administratorLogin')]",
    "administratorLoginPassword": "[parameters('administratorLoginPassword')]",
    "storageProfile": {
      "storageMB": "[parameters('skuSizeMB')]",
      "backupRetentionDays": 7,
      "geoRedundantBackup": "Enabled"
    }
  }
}

Configure with Bicep#

To deploy Azure Database for MariaDB Servers that pass this rule:

  • Set the properties.storageProfile.geoRedundantBackup property to Enabled.

For example:

Azure Bicep snippet
resource mariaDbServer 'Microsoft.DBforMariaDB/servers@2018-06-01' = {
  name: serverName
  location: location
  sku: {
    name: skuName
    tier: 'GeneralPurpose'
    capacity: skuCapacity
    size: '${skuSizeMB}' 
    family: skuFamily
  }
  properties: {
    createMode: 'Default'
    version: mariadbVersion
    administratorLogin: administratorLogin
    administratorLoginPassword: administratorLoginPassword
    storageProfile: {
      storageMB: skuSizeMB
      backupRetentionDays: 7
      geoRedundantBackup: 'Enabled'
    }
  }
}

Notes#

This rule is only applicable for Azure Database for Maria DB Servers with General Purpose and Memory Optimized tiers. The Basic tier does not support geo-redundant backup storage.

Last update: 2022-12-03

Comments