azure-mysql

Prerequisites

PowerShell 7 - (tested with v7.1.0 (Nov 2020), v7.1.1 (Jan 2021))
PowerShell Az module - (tested with v4.2.0 (July 2020), v5.4.0 (Jan 2021))

Getting Started

Clone or download this repo.
Navigate to the folder containing the local version of this repo in PowerShell
Create target resource group using Azure Portal, Az PowerShell or Azure CLI.
Update parameter file as required Default provided in parameters file - see Parameters section for details.
Run the interactive deployment script: (this will securely prompt for administrator password)

$ .\deploy\interactive.ps1 -ResourceGroupName 'test-mysql-resource-group'

Enter admin password: **********

DeploymentName          : template
ResourceGroupName       : test-client-mysql-resource-group
ProvisioningState       : Succeeded
Timestamp               : 19/01/2021 14:54:57
Mode                    : Incremental
TemplateLink            :
Parameters              :
                          Name                          Type                       Value
                          ============================  =========================  ==========
                          administratorLogin            String                     gracehopper
                          administratorLoginPassword    SecureString
                          location                      String                     uksouth
                          serverName                    String                     test-server-name
                          skuCapacity                   Int                        2
                          skuFamily                     String                     Gen5
                          skuName                       String                     B_Gen5_2
                          skuSizeMB                     Int                        51200
                          skuTier                       String                     Basic
                          version                       String                     5.7
                          backupRetentionDays           Int                        7
                          geoRedundantBackup            String                     Disabled
                          previewFeature                String
                          tags                          Object                     {}
                          storageAutoGrow               String                     Enabled
                          infrastructureEncryption      String                     Disabled
                          firewallRules                 Array                      []
Outputs                 :
DeploymentDebugLogLevel :

Parameters

Most of the parameters below match closely with their equivalents for the related resource templates in which they are used, all of which are documented on https://docs.microsoft.com/en-us/azure/templates/.

administratorLogin

A non-null value must be provided - see ServerPropertiesForDefaultCreate object for usage. For automated deployments this value is best set from a value stored in an existing Key Vault.

  "parameters": {
       
        "administratorLogin": {
            "value": null
        },
       
  }

administratorLoginPassword

You can supply non-null value here, but it is strongly recommended that you do not. For interactive deployments it is preferable to use the ability of the New-AzResourceGroupDeployment cmdlet to provide values for template parameters - see provided deployment script for an example of this. For automated deployments this value is best set from a value stored in an existing Key Vault.

  "parameters": {
      
        "administratorLoginPassword": {
            "value": null
        },
      
  }

serverName

A non-null value must be provided - see Microsoft.DBforMySQL/servers object for usage.

  "parameters": {

        "serverName": {
            "value": "my-mysql-server"
        },

  }