Microsoft.DBforMySQL flexibleServers

Article
10/03/2024

Bicep resource definition

The flexibleServers 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.

Remarks

Use the maintenanceWindow property only when updating an existing flexible server. When creating a new flexible servcer, don't specify values for this property.

Resource format

To create a Microsoft.DBforMySQL/flexibleServers resource, add the following Bicep to your template.

resource symbolicname 'Microsoft.DBforMySQL/flexibleServers@2024-06-01-preview' = {
  name: 'string'
  location: 'string'
  tags: {
    tagName1: 'tagValue1'
    tagName2: 'tagValue2'
  }
  sku: {
    name: 'string'
    tier: 'string'
  }
  identity: {
    type: 'UserAssigned'
    userAssignedIdentities: {
      {customized property}: any()
    }
  }
  properties: {
    administratorLogin: 'string'
    administratorLoginPassword: 'string'
    availabilityZone: 'string'
    backup: {
      backupIntervalHours: int
      backupRetentionDays: int
      geoRedundantBackup: 'string'
    }
    createMode: 'string'
    databasePort: int
    dataEncryption: {
      geoBackupKeyURI: 'string'
      geoBackupUserAssignedIdentityId: 'string'
      primaryKeyURI: 'string'
      primaryUserAssignedIdentityId: 'string'
      type: 'string'
    }
    highAvailability: {
      mode: 'string'
      standbyAvailabilityZone: 'string'
    }
    importSourceProperties: {
      dataDirPath: 'string'
      sasToken: 'string'
      storageType: 'AzureBlob'
      storageUrl: 'string'
    }
    maintenancePolicy: {
      patchStrategy: 'string'
    }
    maintenanceWindow: {
      customWindow: 'string'
      dayOfWeek: int
      startHour: int
      startMinute: int
    }
    network: {
      delegatedSubnetResourceId: 'string'
      privateDnsZoneResourceId: 'string'
      publicNetworkAccess: 'string'
    }
    replicationRole: 'string'
    restorePointInTime: 'string'
    sourceServerResourceId: 'string'
    storage: {
      autoGrow: 'string'
      autoIoScaling: 'string'
      iops: int
      logOnDisk: 'string'
      storageRedundancy: 'string'
      storageSizeGB: int
    }
    version: 'string'
  }
}

Property values

flexibleServers

Name	Description	Value
name	The resource name	string (required)
location	The geo-location where the resource lives	string (required)
tags	Resource tags.	Dictionary of tag names and values. See Tags in templates
sku	The SKU (pricing tier) of the server.	MySQLServerSku
identity	The cmk identity for the server.	MySQLServerIdentity
properties	Properties of the server.	ServerProperties

MySQLServerIdentity

Name	Description	Value
type	Type of managed service identity.	'UserAssigned'
userAssignedIdentities	Metadata of user assigned identity.	MySQLServerIdentityUserAssignedIdentities

MySQLServerIdentityUserAssignedIdentities

Name	Description	Value
{customized property}		For Bicep, you can use the any() function.

ServerProperties

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
administratorLoginPassword	The password of the administrator login (required for server creation).	string Constraints: Sensitive value. Pass in as a secure parameter.
availabilityZone	availability Zone information of the server.	string
backup	Backup related properties of a server.	Backup
createMode	The mode to create a new MySQL server.	'Default' 'GeoRestore' 'PointInTimeRestore' 'Replica'
databasePort	The server database port. Can only be specified when the server is being created.	int
dataEncryption	The Data Encryption for CMK.	DataEncryption
highAvailability	High availability related properties of a server.	HighAvailability
importSourceProperties	Source properties for import from storage.	ImportSourceProperties
maintenancePolicy	Maintenance policy of a server.	MaintenancePolicy
maintenanceWindow	Maintenance window of a server. Known issue: cannot be set during server creation or updated with other properties during server update; must be updated separately.	MaintenanceWindow
network	Network related properties of a server.	Network
replicationRole	The replication role.	'None' 'Replica' 'Source'
restorePointInTime	Restore point creation time (ISO8601 format), specifying the time to restore from.	string
sourceServerResourceId	The source MySQL server id.	string
storage	Storage related properties of a server.	Storage
version	Server version.	'5.7' '8.0.21'

Backup

Name	Description	Value
backupIntervalHours	Backup interval hours for the server.	int
backupRetentionDays	Backup retention days for the server.	int
geoRedundantBackup	Whether or not geo redundant backup is enabled.	'Disabled' 'Enabled'

DataEncryption

Name	Description	Value
geoBackupKeyURI	Geo backup key uri as key vault can't cross region, need cmk in same region as geo backup	string
geoBackupUserAssignedIdentityId	Geo backup user identity resource id as identity can't cross region, need identity in same region as geo backup	string
primaryKeyURI	Primary key uri	string
primaryUserAssignedIdentityId	Primary user identity resource id	string
type	The key type, AzureKeyVault for enable cmk, SystemManaged for disable cmk.	'AzureKeyVault' 'SystemManaged'

HighAvailability

Name	Description	Value
mode	High availability mode for a server.	'Disabled' 'SameZone' 'ZoneRedundant'
standbyAvailabilityZone	Availability zone of the standby server.	string

ImportSourceProperties

Name	Description	Value
dataDirPath	Relative path of data directory in storage.	string
sasToken	Sas token for accessing source storage. Read and list permissions are required for sas token.	string Constraints: Sensitive value. Pass in as a secure parameter.
storageType	Storage type of import source.	'AzureBlob'
storageUrl	Uri of the import source storage.	string

MaintenancePolicy

Name	Description	Value
patchStrategy	The patch strategy of this server	'Regular' 'VirtualCanary'

MaintenanceWindow

Name	Description	Value
customWindow	indicates whether custom window is enabled or disabled	string
dayOfWeek	day of week for maintenance window	int
startHour	start hour for maintenance window	int
startMinute	start minute for maintenance window	int

Network

Name	Description	Value
delegatedSubnetResourceId	Delegated subnet resource id used to setup vnet for a server.	string
privateDnsZoneResourceId	Private DNS zone resource id.	string
publicNetworkAccess	Whether or not public network access is allowed for this server. Value is 'Disabled' when server has VNet integration.	'Disabled' 'Enabled'

Storage

Name	Description	Value
autoGrow	Enable Storage Auto Grow or not.	'Disabled' 'Enabled'
autoIoScaling	Enable IO Auto Scaling or not.	'Disabled' 'Enabled'
iops	Storage IOPS for a server.	int
logOnDisk	Enable Log On Disk or not.	'Disabled' 'Enabled'
storageRedundancy	The redundant type of the server storage. The parameter is used for server creation.	'LocalRedundancy' 'ZoneRedundancy'
storageSizeGB	Max storage size allowed for a server.	int

MySQLServerSku

Name	Description	Value
name	The name of the sku, e.g. Standard_D32s_v3.	string (required)
tier	The tier of the particular SKU, e.g. GeneralPurpose.	'Burstable' 'GeneralPurpose' 'MemoryOptimized' (required)

Quickstart templates

The following quickstart templates deploy this resource type.

Template	Description
Deploy Azure Database for MySQL (flexible) with VNet	This template provides a way to deploy a Flexible server Azure database for MySQL with VNet integration.

ARM template resource definition

The flexibleServers 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.

Remarks

Use the maintenanceWindow property only when updating an existing flexible server. When creating a new flexible servcer, don't specify values for this property.

Resource format

To create a Microsoft.DBforMySQL/flexibleServers resource, add the following JSON to your template.

{
  "type": "Microsoft.DBforMySQL/flexibleServers",
  "apiVersion": "2024-06-01-preview",
  "name": "string",
  "location": "string",
  "tags": {
    "tagName1": "tagValue1",
    "tagName2": "tagValue2"
  },
  "sku": {
    "name": "string",
    "tier": "string"
  },
  "identity": {
    "type": "UserAssigned",
    "userAssignedIdentities": {
      "{customized property}": {}
    }
  },
  "properties": {
    "administratorLogin": "string",
    "administratorLoginPassword": "string",
    "availabilityZone": "string",
    "backup": {
      "backupIntervalHours": "int",
      "backupRetentionDays": "int",
      "geoRedundantBackup": "string"
    },
    "createMode": "string",
    "databasePort": "int",
    "dataEncryption": {
      "geoBackupKeyURI": "string",
      "geoBackupUserAssignedIdentityId": "string",
      "primaryKeyURI": "string",
      "primaryUserAssignedIdentityId": "string",
      "type": "string"
    },
    "highAvailability": {
      "mode": "string",
      "standbyAvailabilityZone": "string"
    },
    "importSourceProperties": {
      "dataDirPath": "string",
      "sasToken": "string",
      "storageType": "AzureBlob",
      "storageUrl": "string"
    },
    "maintenancePolicy": {
      "patchStrategy": "string"
    },
    "maintenanceWindow": {
      "customWindow": "string",
      "dayOfWeek": "int",
      "startHour": "int",
      "startMinute": "int"
    },
    "network": {
      "delegatedSubnetResourceId": "string",
      "privateDnsZoneResourceId": "string",
      "publicNetworkAccess": "string"
    },
    "replicationRole": "string",
    "restorePointInTime": "string",
    "sourceServerResourceId": "string",
    "storage": {
      "autoGrow": "string",
      "autoIoScaling": "string",
      "iops": "int",
      "logOnDisk": "string",
      "storageRedundancy": "string",
      "storageSizeGB": "int"
    },
    "version": "string"
  }
}

Property values

flexibleServers

Name	Description	Value
type	The resource type	'Microsoft.DBforMySQL/flexibleServers'
apiVersion	The resource api version	'2024-06-01-preview'
name	The resource name	string (required)
location	The geo-location where the resource lives	string (required)
tags	Resource tags.	Dictionary of tag names and values. See Tags in templates
sku	The SKU (pricing tier) of the server.	MySQLServerSku
identity	The cmk identity for the server.	MySQLServerIdentity
properties	Properties of the server.	ServerProperties

MySQLServerIdentity

Name	Description	Value
type	Type of managed service identity.	'UserAssigned'
userAssignedIdentities	Metadata of user assigned identity.	MySQLServerIdentityUserAssignedIdentities

MySQLServerIdentityUserAssignedIdentities

Name	Description	Value
{customized property}

ServerProperties

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
administratorLoginPassword	The password of the administrator login (required for server creation).	string Constraints: Sensitive value. Pass in as a secure parameter.
availabilityZone	availability Zone information of the server.	string
backup	Backup related properties of a server.	Backup
createMode	The mode to create a new MySQL server.	'Default' 'GeoRestore' 'PointInTimeRestore' 'Replica'
databasePort	The server database port. Can only be specified when the server is being created.	int
dataEncryption	The Data Encryption for CMK.	DataEncryption
highAvailability	High availability related properties of a server.	HighAvailability
importSourceProperties	Source properties for import from storage.	ImportSourceProperties
maintenancePolicy	Maintenance policy of a server.	MaintenancePolicy
maintenanceWindow	Maintenance window of a server. Known issue: cannot be set during server creation or updated with other properties during server update; must be updated separately.	MaintenanceWindow
network	Network related properties of a server.	Network
replicationRole	The replication role.	'None' 'Replica' 'Source'
restorePointInTime	Restore point creation time (ISO8601 format), specifying the time to restore from.	string
sourceServerResourceId	The source MySQL server id.	string
storage	Storage related properties of a server.	Storage
version	Server version.	'5.7' '8.0.21'

Backup

Name	Description	Value
backupIntervalHours	Backup interval hours for the server.	int
backupRetentionDays	Backup retention days for the server.	int
geoRedundantBackup	Whether or not geo redundant backup is enabled.	'Disabled' 'Enabled'

DataEncryption

Name	Description	Value
geoBackupKeyURI	Geo backup key uri as key vault can't cross region, need cmk in same region as geo backup	string
geoBackupUserAssignedIdentityId	Geo backup user identity resource id as identity can't cross region, need identity in same region as geo backup	string
primaryKeyURI	Primary key uri	string
primaryUserAssignedIdentityId	Primary user identity resource id	string
type	The key type, AzureKeyVault for enable cmk, SystemManaged for disable cmk.	'AzureKeyVault' 'SystemManaged'

HighAvailability

Name	Description	Value
mode	High availability mode for a server.	'Disabled' 'SameZone' 'ZoneRedundant'
standbyAvailabilityZone	Availability zone of the standby server.	string

ImportSourceProperties

Name	Description	Value
dataDirPath	Relative path of data directory in storage.	string
sasToken	Sas token for accessing source storage. Read and list permissions are required for sas token.	string Constraints: Sensitive value. Pass in as a secure parameter.
storageType	Storage type of import source.	'AzureBlob'
storageUrl	Uri of the import source storage.	string

MaintenancePolicy

Name	Description	Value
patchStrategy	The patch strategy of this server	'Regular' 'VirtualCanary'

MaintenanceWindow

Name	Description	Value
customWindow	indicates whether custom window is enabled or disabled	string
dayOfWeek	day of week for maintenance window	int
startHour	start hour for maintenance window	int
startMinute	start minute for maintenance window	int

Network

Name	Description	Value
delegatedSubnetResourceId	Delegated subnet resource id used to setup vnet for a server.	string
privateDnsZoneResourceId	Private DNS zone resource id.	string
publicNetworkAccess	Whether or not public network access is allowed for this server. Value is 'Disabled' when server has VNet integration.	'Disabled' 'Enabled'

Storage

Name	Description	Value
autoGrow	Enable Storage Auto Grow or not.	'Disabled' 'Enabled'
autoIoScaling	Enable IO Auto Scaling or not.	'Disabled' 'Enabled'
iops	Storage IOPS for a server.	int
logOnDisk	Enable Log On Disk or not.	'Disabled' 'Enabled'
storageRedundancy	The redundant type of the server storage. The parameter is used for server creation.	'LocalRedundancy' 'ZoneRedundancy'
storageSizeGB	Max storage size allowed for a server.	int

MySQLServerSku

Name	Description	Value
name	The name of the sku, e.g. Standard_D32s_v3.	string (required)
tier	The tier of the particular SKU, e.g. GeneralPurpose.	'Burstable' 'GeneralPurpose' 'MemoryOptimized' (required)

Quickstart templates

The following quickstart templates deploy this resource type.

Template	Description
Deploy Azure Database for MySQL (flexible) with VNet	This template provides a way to deploy a Flexible server Azure database for MySQL with VNet integration.

Terraform (AzAPI provider) resource definition

The flexibleServers 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/flexibleServers resource, add the following Terraform to your template.

resource "azapi_resource" "symbolicname" {
  type = "Microsoft.DBforMySQL/flexibleServers@2024-06-01-preview"
  name = "string"
  location = "string"
  parent_id = "string"
  tags = {
    tagName1 = "tagValue1"
    tagName2 = "tagValue2"
  }
  identity {
    type = "UserAssigned"
    identity_ids = []
  }
  body = jsonencode({
    properties = {
      administratorLogin = "string"
      administratorLoginPassword = "string"
      availabilityZone = "string"
      backup = {
        backupIntervalHours = int
        backupRetentionDays = int
        geoRedundantBackup = "string"
      }
      createMode = "string"
      databasePort = int
      dataEncryption = {
        geoBackupKeyURI = "string"
        geoBackupUserAssignedIdentityId = "string"
        primaryKeyURI = "string"
        primaryUserAssignedIdentityId = "string"
        type = "string"
      }
      highAvailability = {
        mode = "string"
        standbyAvailabilityZone = "string"
      }
      importSourceProperties = {
        dataDirPath = "string"
        sasToken = "string"
        storageType = "AzureBlob"
        storageUrl = "string"
      }
      maintenancePolicy = {
        patchStrategy = "string"
      }
      maintenanceWindow = {
        customWindow = "string"
        dayOfWeek = int
        startHour = int
        startMinute = int
      }
      network = {
        delegatedSubnetResourceId = "string"
        privateDnsZoneResourceId = "string"
        publicNetworkAccess = "string"
      }
      replicationRole = "string"
      restorePointInTime = "string"
      sourceServerResourceId = "string"
      storage = {
        autoGrow = "string"
        autoIoScaling = "string"
        iops = int
        logOnDisk = "string"
        storageRedundancy = "string"
        storageSizeGB = int
      }
      version = "string"
    }
    sku = {
      name = "string"
      tier = "string"
    }
  })
}

Property values

flexibleServers

Name	Description	Value
type	The resource type	"Microsoft.DBforMySQL/flexibleServers@2024-06-01-preview"
name	The resource name	string (required)
location	The geo-location where the resource lives	string (required)
parent_id	To deploy to a resource group, use the ID of that resource group.	string (required)
tags	Resource tags.	Dictionary of tag names and values.
sku	The SKU (pricing tier) of the server.	MySQLServerSku
identity	The cmk identity for the server.	MySQLServerIdentity
properties	Properties of the server.	ServerProperties

MySQLServerIdentity

Name	Description	Value
type	Type of managed service identity.	"UserAssigned"
identity_ids	Metadata of user assigned identity.	Array of user identity IDs.

MySQLServerIdentityUserAssignedIdentities

Name	Description	Value
{customized property}

ServerProperties

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
administratorLoginPassword	The password of the administrator login (required for server creation).	string Constraints: Sensitive value. Pass in as a secure parameter.
availabilityZone	availability Zone information of the server.	string
backup	Backup related properties of a server.	Backup
createMode	The mode to create a new MySQL server.	"Default" "GeoRestore" "PointInTimeRestore" "Replica"
databasePort	The server database port. Can only be specified when the server is being created.	int
dataEncryption	The Data Encryption for CMK.	DataEncryption
highAvailability	High availability related properties of a server.	HighAvailability
importSourceProperties	Source properties for import from storage.	ImportSourceProperties
maintenancePolicy	Maintenance policy of a server.	MaintenancePolicy
maintenanceWindow	Maintenance window of a server. Known issue: cannot be set during server creation or updated with other properties during server update; must be updated separately.	MaintenanceWindow
network	Network related properties of a server.	Network
replicationRole	The replication role.	"None" "Replica" "Source"
restorePointInTime	Restore point creation time (ISO8601 format), specifying the time to restore from.	string
sourceServerResourceId	The source MySQL server id.	string
storage	Storage related properties of a server.	Storage
version	Server version.	"5.7" "8.0.21"

Backup

Name	Description	Value
backupIntervalHours	Backup interval hours for the server.	int
backupRetentionDays	Backup retention days for the server.	int
geoRedundantBackup	Whether or not geo redundant backup is enabled.	"Disabled" "Enabled"

DataEncryption

Name	Description	Value
geoBackupKeyURI	Geo backup key uri as key vault can't cross region, need cmk in same region as geo backup	string
geoBackupUserAssignedIdentityId	Geo backup user identity resource id as identity can't cross region, need identity in same region as geo backup	string
primaryKeyURI	Primary key uri	string
primaryUserAssignedIdentityId	Primary user identity resource id	string
type	The key type, AzureKeyVault for enable cmk, SystemManaged for disable cmk.	"AzureKeyVault" "SystemManaged"

HighAvailability

Name	Description	Value
mode	High availability mode for a server.	"Disabled" "SameZone" "ZoneRedundant"
standbyAvailabilityZone	Availability zone of the standby server.	string

ImportSourceProperties

Name	Description	Value
dataDirPath	Relative path of data directory in storage.	string
sasToken	Sas token for accessing source storage. Read and list permissions are required for sas token.	string Constraints: Sensitive value. Pass in as a secure parameter.
storageType	Storage type of import source.	"AzureBlob"
storageUrl	Uri of the import source storage.	string

MaintenancePolicy

Name	Description	Value
patchStrategy	The patch strategy of this server	"Regular" "VirtualCanary"

MaintenanceWindow

Name	Description	Value
customWindow	indicates whether custom window is enabled or disabled	string
dayOfWeek	day of week for maintenance window	int
startHour	start hour for maintenance window	int
startMinute	start minute for maintenance window	int

Network

Name	Description	Value
delegatedSubnetResourceId	Delegated subnet resource id used to setup vnet for a server.	string
privateDnsZoneResourceId	Private DNS zone resource id.	string
publicNetworkAccess	Whether or not public network access is allowed for this server. Value is 'Disabled' when server has VNet integration.	"Disabled" "Enabled"

Storage

Name	Description	Value
autoGrow	Enable Storage Auto Grow or not.	"Disabled" "Enabled"
autoIoScaling	Enable IO Auto Scaling or not.	"Disabled" "Enabled"
iops	Storage IOPS for a server.	int
logOnDisk	Enable Log On Disk or not.	"Disabled" "Enabled"
storageRedundancy	The redundant type of the server storage. The parameter is used for server creation.	"LocalRedundancy" "ZoneRedundancy"
storageSizeGB	Max storage size allowed for a server.	int

MySQLServerSku

Name	Description	Value
name	The name of the sku, e.g. Standard_D32s_v3.	string (required)
tier	The tier of the particular SKU, e.g. GeneralPurpose.	"Burstable" "GeneralPurpose" "MemoryOptimized" (required)

Share via

Microsoft.DBforMySQL flexibleServers

Bicep resource definition

Remarks

Resource format

Property values

flexibleServers

MySQLServerIdentity

MySQLServerIdentityUserAssignedIdentities

ServerProperties

Backup

DataEncryption

HighAvailability

ImportSourceProperties

MaintenancePolicy

MaintenanceWindow

Network

Storage

MySQLServerSku

Quickstart templates

ARM template resource definition

Remarks

Resource format

Property values

flexibleServers

MySQLServerIdentity

MySQLServerIdentityUserAssignedIdentities

ServerProperties

Backup

DataEncryption

HighAvailability

ImportSourceProperties

MaintenancePolicy

MaintenanceWindow

Network

Storage

MySQLServerSku

Quickstart templates

Terraform (AzAPI provider) resource definition

Resource format

Property values

flexibleServers

MySQLServerIdentity

MySQLServerIdentityUserAssignedIdentities

ServerProperties

Backup

DataEncryption

HighAvailability

ImportSourceProperties

MaintenancePolicy

MaintenanceWindow

Network

Storage

MySQLServerSku

Feedback

Additional resources