Microsoft.DBforMySQL servers 2017-12-01-preview
Remarks
Using a template to create a MySQL server with the Replica value is not idempotent. The server is created successfully the first time. However, deploying the template when the replica server already exists returns an error.
Bicep resource definition
The servers resource type can be deployed with operations that target:
- Resource groups - See resource group deployment commands
For a list of changed properties in each API version, see change log.
Resource format
To create a Microsoft.DBforMySQL/servers resource, add the following Bicep to your template.
resource symbolicname 'Microsoft.DBforMySQL/servers@2017-12-01-preview' = {
location: 'string'
name: 'string'
properties: {
minimalTlsVersion: 'string'
sslEnforcement: 'string'
storageProfile: {
backupRetentionDays: int
geoRedundantBackup: 'string'
storageAutogrow: 'string'
storageMB: int
}
version: 'string'
createMode: 'string'
// For remaining properties, see ServerPropertiesForCreateOrServerProperties objects
}
sku: {
capacity: int
family: 'string'
name: 'string'
size: 'string'
tier: 'string'
}
tags: {
{customized property}: 'string'
}
}
ServerPropertiesForCreateOrServerProperties objects
Set the createMode property to specify the type of object.
For Default, use:
{
administratorLogin: 'string'
administratorLoginPassword: 'string'
createMode: 'Default'
}
For GeoRestore, use:
{
createMode: 'GeoRestore'
sourceServerId: 'string'
}
For PointInTimeRestore, use:
{
createMode: 'PointInTimeRestore'
restorePointInTime: 'string'
sourceServerId: 'string'
}
For Replica, use:
{
createMode: 'Replica'
sourceServerId: 'string'
}
Property values
Microsoft.DBforMySQL/servers
Name | Description | Value |
---|---|---|
location | The location the resource resides in. | string (required) |
name | The resource name | string (required) |
properties | Properties of the server. | ServerPropertiesForCreateOrServerProperties (required) |
sku | The SKU (pricing tier) of the server. | Sku |
tags | Resource tags | Dictionary of tag names and values. See Tags in templates |
ServerForCreateTags
Name | Description | Value |
---|
ServerPropertiesForCreateOrServerProperties
Name | Description | Value |
---|---|---|
createMode | Set to 'Default' for type ServerPropertiesForDefaultCreate. Set to 'GeoRestore' for type ServerPropertiesForGeoRestore. Set to 'PointInTimeRestore' for type ServerPropertiesForRestore. Set to 'Replica' for type ServerPropertiesForReplica. | 'Default' 'GeoRestore' 'PointInTimeRestore' 'Replica' (required) |
minimalTlsVersion | Enforce a minimal Tls version for the server. | 'TLS1_0' 'TLS1_1' 'TLS1_2' 'TLSEnforcementDisabled' |
sslEnforcement | Enable ssl enforcement or not when connect to server. | 'Disabled' 'Enabled' |
storageProfile | Storage profile of a server. | StorageProfile |
version | Server version. | '5.6' '5.7' '8.0' |
ServerPropertiesForDefaultCreate
Name | Description | Value |
---|---|---|
administratorLogin | The administrator's login name of a server. Can only be specified when the server is being created (and is required for creation). | string (required) |
administratorLoginPassword | The password of the administrator login. | string Constraints: Sensitive value. Pass in as a secure parameter. (required) |
createMode | The mode to create a new server. | 'Default' (required) |
ServerPropertiesForGeoRestore
Name | Description | Value |
---|---|---|
createMode | The mode to create a new server. | 'GeoRestore' (required) |
sourceServerId | The source server id to restore from. | string (required) |
ServerPropertiesForReplica
Name | Description | Value |
---|---|---|
createMode | The mode to create a new server. | 'Replica' (required) |
sourceServerId | The master server id to create replica from. | string (required) |
ServerPropertiesForRestore
Name | Description | Value |
---|---|---|
createMode | The mode to create a new server. | 'PointInTimeRestore' (required) |
restorePointInTime | Restore point creation time (ISO8601 format), specifying the time to restore from. | string (required) |
sourceServerId | The source server id to restore from. | string (required) |
Sku
Name | Description | Value |
---|---|---|
capacity | The scale up/out capacity, representing server's compute units. | int Constraints: Min value = 0 |
family | The family of hardware. | string |
name | The name of the sku, typically, tier + family + cores, e.g. B_Gen4_1, GP_Gen5_8. | string (required) |
size | The size code, to be interpreted by resource as appropriate. | string |
tier | The tier of the particular SKU, e.g. Basic. | 'Basic' 'GeneralPurpose' 'MemoryOptimized' |
StorageProfile
Name | Description | Value |
---|---|---|
backupRetentionDays | Backup retention days for the server. | int |
geoRedundantBackup | Enable Geo-redundant or not for server backup. | 'Disabled' 'Enabled' |
storageAutogrow | Enable Storage Auto Grow. | 'Disabled' 'Enabled' |
storageMB | Max storage allowed for a server. | int |
Quickstart samples
The following quickstart samples deploy this resource type.
Bicep File | Description |
---|---|
Build a Web App on Linux with Azure database for MySQL | This template provides a way to deploy Web Apps on Linux with Azure database for MySQL. |
Deploy Azure Database for MySQL with VNet | This template provides a way to deploy an Azure database for MySQL with VNet integration. |
Deploys 1 MySQL PaaS instance and up to 5 read only replicas | This template will deploy a MySQL PaaS Server instance, and from 0 to 5 read only replicas. They will all be set on the same location as the master and replication will be automatically configured. |
Web App with Azure database for MySQL | This template provides a easy way to deploy web app on Azure App Service Web Apps with Azure database for MySQL. |
ARM template resource definition
The servers resource type can be deployed with operations that target:
- Resource groups - See resource group deployment commands
For a list of changed properties in each API version, see change log.
Resource format
To create a Microsoft.DBforMySQL/servers resource, add the following JSON to your template.
{
"type": "Microsoft.DBforMySQL/servers",
"apiVersion": "2017-12-01-preview",
"name": "string",
"location": "string",
"properties": {
"minimalTlsVersion": "string",
"sslEnforcement": "string",
"storageProfile": {
"backupRetentionDays": "int",
"geoRedundantBackup": "string",
"storageAutogrow": "string",
"storageMB": "int"
},
"version": "string",
"createMode": "string"
// For remaining properties, see ServerPropertiesForCreateOrServerProperties objects
},
"sku": {
"capacity": "int",
"family": "string",
"name": "string",
"size": "string",
"tier": "string"
},
"tags": {
"{customized property}": "string"
}
}
ServerPropertiesForCreateOrServerProperties objects
Set the createMode property to specify the type of object.
For Default, use:
{
"administratorLogin": "string",
"administratorLoginPassword": "string",
"createMode": "Default"
}
For GeoRestore, use:
{
"createMode": "GeoRestore",
"sourceServerId": "string"
}
For PointInTimeRestore, use:
{
"createMode": "PointInTimeRestore",
"restorePointInTime": "string",
"sourceServerId": "string"
}
For Replica, use:
{
"createMode": "Replica",
"sourceServerId": "string"
}
Property values
Microsoft.DBforMySQL/servers
Name | Description | Value |
---|---|---|
apiVersion | The api version | '2017-12-01-preview' |
location | The location the resource resides in. | string (required) |
name | The resource name | string (required) |
properties | Properties of the server. | ServerPropertiesForCreateOrServerProperties (required) |
sku | The SKU (pricing tier) of the server. | Sku |
tags | Resource tags | Dictionary of tag names and values. See Tags in templates |
type | The resource type | 'Microsoft.DBforMySQL/servers' |
ServerForCreateTags
Name | Description | Value |
---|
ServerPropertiesForCreateOrServerProperties
Name | Description | Value |
---|---|---|
createMode | Set to 'Default' for type ServerPropertiesForDefaultCreate. Set to 'GeoRestore' for type ServerPropertiesForGeoRestore. Set to 'PointInTimeRestore' for type ServerPropertiesForRestore. Set to 'Replica' for type ServerPropertiesForReplica. | 'Default' 'GeoRestore' 'PointInTimeRestore' 'Replica' (required) |
minimalTlsVersion | Enforce a minimal Tls version for the server. | 'TLS1_0' 'TLS1_1' 'TLS1_2' 'TLSEnforcementDisabled' |
sslEnforcement | Enable ssl enforcement or not when connect to server. | 'Disabled' 'Enabled' |
storageProfile | Storage profile of a server. | StorageProfile |
version | Server version. | '5.6' '5.7' '8.0' |
ServerPropertiesForDefaultCreate
Name | Description | Value |
---|---|---|
administratorLogin | The administrator's login name of a server. Can only be specified when the server is being created (and is required for creation). | string (required) |
administratorLoginPassword | The password of the administrator login. | string Constraints: Sensitive value. Pass in as a secure parameter. (required) |
createMode | The mode to create a new server. | 'Default' (required) |
ServerPropertiesForGeoRestore
Name | Description | Value |
---|---|---|
createMode | The mode to create a new server. | 'GeoRestore' (required) |
sourceServerId | The source server id to restore from. | string (required) |
ServerPropertiesForReplica
Name | Description | Value |
---|---|---|
createMode | The mode to create a new server. | 'Replica' (required) |
sourceServerId | The master server id to create replica from. | string (required) |
ServerPropertiesForRestore
Name | Description | Value |
---|---|---|
createMode | The mode to create a new server. | 'PointInTimeRestore' (required) |
restorePointInTime | Restore point creation time (ISO8601 format), specifying the time to restore from. | string (required) |
sourceServerId | The source server id to restore from. | string (required) |
Sku
Name | Description | Value |
---|---|---|
capacity | The scale up/out capacity, representing server's compute units. | int Constraints: Min value = 0 |
family | The family of hardware. | string |
name | The name of the sku, typically, tier + family + cores, e.g. B_Gen4_1, GP_Gen5_8. | string (required) |
size | The size code, to be interpreted by resource as appropriate. | string |
tier | The tier of the particular SKU, e.g. Basic. | 'Basic' 'GeneralPurpose' 'MemoryOptimized' |
StorageProfile
Name | Description | Value |
---|---|---|
backupRetentionDays | Backup retention days for the server. | int |
geoRedundantBackup | Enable Geo-redundant or not for server backup. | 'Disabled' 'Enabled' |
storageAutogrow | Enable Storage Auto Grow. | 'Disabled' 'Enabled' |
storageMB | Max storage allowed for a server. | int |
Quickstart templates
The following quickstart templates deploy this resource type.
Template | Description |
---|---|
Application Gateway for a Web App with IP Restriction |
This template creates an application gateway in front of an Azure Web App with IP restriction enabled on the Web App. |
Buffalo Web App |
Start running your Golang Buffalo Application on Azure quickly and cheaply. |
Build a Web App on Linux with Azure database for MySQL |
This template provides a way to deploy Web Apps on Linux with Azure database for MySQL. |
Deploy Azure Database for MySQL with VNet |
This template provides a way to deploy an Azure database for MySQL with VNet integration. |
Deploys 1 MySQL PaaS instance and up to 5 read only replicas |
This template will deploy a MySQL PaaS Server instance, and from 0 to 5 read only replicas. They will all be set on the same location as the master and replication will be automatically configured. |
Java CI/CD using Jenkins and Azure Web Apps |
This is a sample for Java CI/CD using Jenkins and Azure Web Apps. |
Sonarqube Docker Web App on Linux with MySQL |
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 |
This template provides a easy way to deploy web app on Azure App Service Web Apps with Azure database for MySQL. |
Terraform (AzAPI provider) resource definition
The servers resource type can be deployed with operations that target:
- Resource groups
For a list of changed properties in each API version, see change log.
Resource format
To create a Microsoft.DBforMySQL/servers resource, add the following Terraform to your template.
resource "azapi_resource" "symbolicname" {
type = "Microsoft.DBforMySQL/servers@2017-12-01-preview"
name = "string"
location = "string"
sku = {
capacity = int
family = "string"
name = "string"
size = "string"
tier = "string"
}
tags = {
{customized property} = "string"
}
body = jsonencode({
properties = {
minimalTlsVersion = "string"
sslEnforcement = "string"
storageProfile = {
backupRetentionDays = int
geoRedundantBackup = "string"
storageAutogrow = "string"
storageMB = int
}
version = "string"
createMode = "string"
// For remaining properties, see ServerPropertiesForCreateOrServerProperties objects
}
})
}
ServerPropertiesForCreateOrServerProperties objects
Set the createMode property to specify the type of object.
For Default, use:
{
administratorLogin = "string"
administratorLoginPassword = "string"
createMode = "Default"
}
For GeoRestore, use:
{
createMode = "GeoRestore"
sourceServerId = "string"
}
For PointInTimeRestore, use:
{
createMode = "PointInTimeRestore"
restorePointInTime = "string"
sourceServerId = "string"
}
For Replica, use:
{
createMode = "Replica"
sourceServerId = "string"
}
Property values
Microsoft.DBforMySQL/servers
Name | Description | Value |
---|---|---|
location | The location the resource resides in. | string (required) |
name | The resource name | string (required) |
properties | Properties of the server. | ServerPropertiesForCreateOrServerProperties (required) |
sku | The SKU (pricing tier) of the server. | Sku |
tags | Resource tags | Dictionary of tag names and values. |
type | The resource type | "Microsoft.DBforMySQL/servers@2017-12-01-preview" |
ServerForCreateTags
Name | Description | Value |
---|
ServerPropertiesForCreateOrServerProperties
Name | Description | Value |
---|---|---|
createMode | Set to 'Default' for type ServerPropertiesForDefaultCreate. Set to 'GeoRestore' for type ServerPropertiesForGeoRestore. Set to 'PointInTimeRestore' for type ServerPropertiesForRestore. Set to 'Replica' for type ServerPropertiesForReplica. | 'Default' 'GeoRestore' 'PointInTimeRestore' 'Replica' (required) |
minimalTlsVersion | Enforce a minimal Tls version for the server. | 'TLS1_0' 'TLS1_1' 'TLS1_2' 'TLSEnforcementDisabled' |
sslEnforcement | Enable ssl enforcement or not when connect to server. | 'Disabled' 'Enabled' |
storageProfile | Storage profile of a server. | StorageProfile |
version | Server version. | '5.6' '5.7' '8.0' |
ServerPropertiesForDefaultCreate
Name | Description | Value |
---|---|---|
administratorLogin | The administrator's login name of a server. Can only be specified when the server is being created (and is required for creation). | string (required) |
administratorLoginPassword | The password of the administrator login. | string Constraints: Sensitive value. Pass in as a secure parameter. (required) |
createMode | The mode to create a new server. | 'Default' (required) |
ServerPropertiesForGeoRestore
Name | Description | Value |
---|---|---|
createMode | The mode to create a new server. | 'GeoRestore' (required) |
sourceServerId | The source server id to restore from. | string (required) |
ServerPropertiesForReplica
Name | Description | Value |
---|---|---|
createMode | The mode to create a new server. | 'Replica' (required) |
sourceServerId | The master server id to create replica from. | string (required) |
ServerPropertiesForRestore
Name | Description | Value |
---|---|---|
createMode | The mode to create a new server. | 'PointInTimeRestore' (required) |
restorePointInTime | Restore point creation time (ISO8601 format), specifying the time to restore from. | string (required) |
sourceServerId | The source server id to restore from. | string (required) |
Sku
Name | Description | Value |
---|---|---|
capacity | The scale up/out capacity, representing server's compute units. | int Constraints: Min value = 0 |
family | The family of hardware. | string |
name | The name of the sku, typically, tier + family + cores, e.g. B_Gen4_1, GP_Gen5_8. | string (required) |
size | The size code, to be interpreted by resource as appropriate. | string |
tier | The tier of the particular SKU, e.g. Basic. | 'Basic' 'GeneralPurpose' 'MemoryOptimized' |
StorageProfile
Name | Description | Value |
---|---|---|
backupRetentionDays | Backup retention days for the server. | int |
geoRedundantBackup | Enable Geo-redundant or not for server backup. | 'Disabled' 'Enabled' |
storageAutogrow | Enable Storage Auto Grow. | 'Disabled' 'Enabled' |
storageMB | Max storage allowed for a server. | int |