Microsoft.DBforMySQL servers template reference

Template format

To create a Microsoft.DBforMySQL/servers resource, add the following JSON to the resources section of your template.

{
  "name": "string",
  "type": "Microsoft.DBforMySQL/servers",
  "apiVersion": "2017-12-01",
  "identity": {
    "type": "SystemAssigned"
  },
  "sku": {
    "name": "string",
    "tier": "string",
    "capacity": "integer",
    "size": "string",
    "family": "string"
  },
  "properties": {
    "version": "string",
    "sslEnforcement": "string",
    "minimalTlsVersion": "string",
    "infrastructureEncryption": "string",
    "publicNetworkAccess": "string",
    "storageProfile": {
      "backupRetentionDays": "integer",
      "geoRedundantBackup": "string",
      "storageMB": "integer",
      "storageAutogrow": "string"
    },
    <one of the ServerPropertiesForCreate objects>
  },
  "location": "string",
  "tags": {},
  "resources": []
}

ServerPropertiesForCreate

The properties used to create a new server.

"createMode": "Default",
"administratorLogin": "string",
"administratorLoginPassword": "string"

The properties used to create a new server by restoring to a different region from a geo replicated backup.

"createMode": "GeoRestore",
"sourceServerId": "string"

The properties to create a new replica.

"createMode": "Replica",
"sourceServerId": "string",

The properties used to create a new server by restoring from a backup.

"createMode": "PointInTimeRestore",
"restorePointInTime": "string",
"sourceServerId": "string",

Property values

The following tables describe the values you need to set in the schema.

Microsoft.DBforMySQL/servers object

Name Type Required Value
name string Yes The name of the server.
type enum Yes Microsoft.DBforMySQL/servers
apiVersion enum Yes 2017-12-01
identity object No The Azure Active Directory identity of the server. - ResourceIdentity object
sku object No The SKU (pricing tier) of the server. - Sku object
properties object Yes Properties of the server. - ServerPropertiesForCreate object
location string Yes The location the resource resides in.
tags object No Application-specific metadata in the form of key-value pairs.
resources array No securityAlertPolicies configurations databases virtualNetworkRules firewallRules

ResourceIdentity object

Name Type Required Value
type enum No The identity type. Set this to 'SystemAssigned' in order to automatically create and assign an Azure Active Directory principal for the resource. - SystemAssigned

Sku object

Name Type Required Value
name string No The name of the sku, typically, tier + family + cores, e.g. B_Gen4_1, GP_Gen5_8.
tier enum No The tier of the particular SKU, e.g. Basic. - Basic, GeneralPurpose, MemoryOptimized
capacity integer No The scale up/out capacity, representing server's compute units.
size string No The size code, to be interpreted by resource as appropriate.
family string No The family of hardware.

ServerPropertiesForCreate object

Name Type Required Value
version enum No Server version. - 5.6, 5.7, 8.0
sslEnforcement enum No Enable ssl enforcement or not when connect to server. - Enabled or Disabled
minimalTlsVersion enum No Enforce a minimal Tls version for the server. - TLS1_0, TLS1_1, TLS1_2, TLSEnforcementDisabled
infrastructureEncryption enum No Status showing whether the server enabled infrastructure encryption. - Enabled or Disabled
publicNetworkAccess enum No Whether or not public network access is allowed for this server. Value is optional but if passed in, must be 'Enabled' or 'Disabled'. - Enabled or Disabled
storageProfile object No Storage profile of a server. - StorageProfile object

Plus one of the following objects: ServerPropertiesForDefaultCreate, ServerPropertiesForGeoRestore, ServerPropertiesForReplica, or ServerPropertiesForRestore.

ServerPropertiesForDefaultCreate object

Name Type Required Value
createMode string Yes Default
administratorLogin string Yes The administrator's login name of a server. Can only be specified when the server is being created (and is required for creation).
administratorLoginPassword string Yes The password of the administrator login.

ServerPropertiesForGeoRestore object

Name Type Required Value
createMode string Yes GeoRestore
sourceServerId string Yes The source server id to restore from.

ServerPropertiesForReplica object

Name Type Required Value
createMode string Yes Replica
sourceServerId string Yes The master server id to create replica from.

ServerPropertiesForRestore object

Name Type Required Value
createMode string Yes PointInTimeRestore
restorePointInTime string Yes Restore point creation time (ISO8601 format), specifying the time to restore from.
sourceServerId string Yes The source server id to restore from.

StorageProfile object

Name Type Required Value
backupRetentionDays integer No Backup retention days for the server.
geoRedundantBackup enum No Enable Geo-redundant or not for server backup. - Enabled or Disabled
storageMB integer No Max storage allowed for a server.
storageAutogrow enum No Enable Storage Auto Grow. - Enabled or Disabled

Quickstart templates

The following quickstart templates deploy this resource type.

Template Description
Deploy Azure Database for MySQL with VNet

Deploy to Azure
This template provides a way to deploy an Azure database for MySQL with VNet integration.
Web App on Linux with Azure database for MySQL

Deploy to Azure
This template provides a way to deploy Web Apps on Linux with Azure database for MySQL.
Sonarqube Docker Web App on Linux with MySQL

Deploy to Azure
This template provides a easy way to deploy a Sonarqube docker image (alpine tag) on a Linux Web App with Azure database for MySQL
Web App with Azure database for MySQL

Deploy to Azure
This template provides a easy way to deploy web app on Azure App Service Web Apps with Azure database for MySQL.
Application Gateway for a Web App with IP Restriction

Deploy to Azure
This template creates an application gateway in front of an Azure Web App with IP restriction enabled on the Web App.
Buffalo Web App

Deploy to Azure
Start running your Golang Buffalo Application on Azure quickly and cheaply.
Java CI/CD using Jenkins and Azure Web Apps

Deploy to Azure
This is a sample for Java CI/CD using Jenkins and Azure Web Apps.