Microsoft.DBforMySQL flexibleServers 2021-05-01-preview

Article
12/09/2024

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.

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.

Resource format

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

resource symbolicname 'Microsoft.DBforMySQL/flexibleServers@2021-05-01-preview' = {
  identity: {
    type: 'SystemAssigned'
  }
  location: 'string'
  name: 'string'
  properties: {
    administratorLogin: 'string'
    administratorLoginPassword: 'string'
    availabilityZone: 'string'
    backup: {
      backupRetentionDays: int
      geoRedundantBackup: 'string'
    }
    createMode: 'string'
    highAvailability: {
      mode: 'string'
      standbyAvailabilityZone: 'string'
    }
    maintenanceWindow: {
      customWindow: 'string'
      dayOfWeek: int
      startHour: int
      startMinute: int
    }
    network: {
      delegatedSubnetResourceId: 'string'
      privateDnsZoneResourceId: 'string'
    }
    replicationRole: 'string'
    restorePointInTime: 'string'
    sourceServerResourceId: 'string'
    storage: {
      autoGrow: 'string'
      iops: int
      storageSizeGB: int
    }
    version: 'string'
  }
  sku: {
    name: 'string'
    tier: 'string'
  }
  tags: {
    {customized property}: 'string'
  }
}

Property values

Backup

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

HighAvailability

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

Identity

Name	Description	Value
type	The identity type.	'SystemAssigned'

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

Microsoft.DBforMySQL/flexibleServers

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

Network

Name	Description	Value
delegatedSubnetResourceId	Delegated subnet resource id used to setup vnet for a server.	string
privateDnsZoneResourceId	Private DNS zone resource id.	string

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'
highAvailability	High availability related properties of a server.	HighAvailability
maintenanceWindow	Maintenance window of a server.	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'

Sku

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)

Storage

Name	Description	Value
autoGrow	Enable Storage Auto Grow or not.	'Disabled' 'Enabled'
iops	Storage IOPS for a server.	int
storageSizeGB	Max storage size allowed for a server.	int

TrackedResourceTags

Name	Description	Value

Quickstart samples

The following quickstart samples deploy this resource type.

Bicep File	Description
Create MySqlFlex server & enable protection via Backup Vault	Template that creates a MySQL Flexible Server and enables protection via Backup Vault
Deploy MySQL Flexible Server with Private Endpoint	This template provides a way to deploy a Azure Database for MySQL Flexible Server with Private Endpoint.
Deploy MySQL Flexible Server with Vnet Integration	This template provides a way to deploy a Azure database for MySQL Flexible Server 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.

Resource format

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

{
  "type": "Microsoft.DBforMySQL/flexibleServers",
  "apiVersion": "2021-05-01-preview",
  "name": "string",
  "identity": {
    "type": "SystemAssigned"
  },
  "location": "string",
  "properties": {
    "administratorLogin": "string",
    "administratorLoginPassword": "string",
    "availabilityZone": "string",
    "backup": {
      "backupRetentionDays": "int",
      "geoRedundantBackup": "string"
    },
    "createMode": "string",
    "highAvailability": {
      "mode": "string",
      "standbyAvailabilityZone": "string"
    },
    "maintenanceWindow": {
      "customWindow": "string",
      "dayOfWeek": "int",
      "startHour": "int",
      "startMinute": "int"
    },
    "network": {
      "delegatedSubnetResourceId": "string",
      "privateDnsZoneResourceId": "string"
    },
    "replicationRole": "string",
    "restorePointInTime": "string",
    "sourceServerResourceId": "string",
    "storage": {
      "autoGrow": "string",
      "iops": "int",
      "storageSizeGB": "int"
    },
    "version": "string"
  },
  "sku": {
    "name": "string",
    "tier": "string"
  },
  "tags": {
    "{customized property}": "string"
  }
}

Property values

Backup

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

HighAvailability

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

Identity

Name	Description	Value
type	The identity type.	'SystemAssigned'

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

Microsoft.DBforMySQL/flexibleServers

Name	Description	Value
apiVersion	The api version	'2021-05-01-preview'
identity	The Azure Active Directory identity of the server.	Identity
location	The geo-location where the resource lives	string (required)
name	The resource name	string (required)
properties	Properties of the server.	ServerProperties
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/flexibleServers'

Network

Name	Description	Value
delegatedSubnetResourceId	Delegated subnet resource id used to setup vnet for a server.	string
privateDnsZoneResourceId	Private DNS zone resource id.	string

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'
highAvailability	High availability related properties of a server.	HighAvailability
maintenanceWindow	Maintenance window of a server.	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'

Sku

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)

Storage

Name	Description	Value
autoGrow	Enable Storage Auto Grow or not.	'Disabled' 'Enabled'
iops	Storage IOPS for a server.	int
storageSizeGB	Max storage size allowed for a server.	int

TrackedResourceTags

Name	Description	Value

Quickstart templates

The following quickstart templates deploy this resource type.

Template	Description
Create MySqlFlex server & enable protection via Backup Vault	Template that creates a MySQL Flexible Server and enables protection via Backup Vault
Deploy MySQL Flexible Server with Private Endpoint	This template provides a way to deploy a Azure Database for MySQL Flexible Server with Private Endpoint.
Deploy MySQL Flexible Server with Vnet Integration	This template provides a way to deploy a Azure database for MySQL Flexible Server 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@2021-05-01-preview"
  name = "string"
  identity = {
    type = "SystemAssigned"
  }
  location = "string"
  sku = {
    name = "string"
    tier = "string"
  }
  tags = {
    {customized property} = "string"
  }
  body = jsonencode({
    properties = {
      administratorLogin = "string"
      administratorLoginPassword = "string"
      availabilityZone = "string"
      backup = {
        backupRetentionDays = int
        geoRedundantBackup = "string"
      }
      createMode = "string"
      highAvailability = {
        mode = "string"
        standbyAvailabilityZone = "string"
      }
      maintenanceWindow = {
        customWindow = "string"
        dayOfWeek = int
        startHour = int
        startMinute = int
      }
      network = {
        delegatedSubnetResourceId = "string"
        privateDnsZoneResourceId = "string"
      }
      replicationRole = "string"
      restorePointInTime = "string"
      sourceServerResourceId = "string"
      storage = {
        autoGrow = "string"
        iops = int
        storageSizeGB = int
      }
      version = "string"
    }
  })
}

Property values

Backup

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

HighAvailability

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

Identity

Name	Description	Value
type	The identity type.	'SystemAssigned'

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

Microsoft.DBforMySQL/flexibleServers

Name	Description	Value
identity	The Azure Active Directory identity of the server.	Identity
location	The geo-location where the resource lives	string (required)
name	The resource name	string (required)
properties	Properties of the server.	ServerProperties
sku	The SKU (pricing tier) of the server.	Sku
tags	Resource tags	Dictionary of tag names and values.
type	The resource type	"Microsoft.DBforMySQL/flexibleServers@2021-05-01-preview"

Network

Name	Description	Value
delegatedSubnetResourceId	Delegated subnet resource id used to setup vnet for a server.	string
privateDnsZoneResourceId	Private DNS zone resource id.	string

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'
highAvailability	High availability related properties of a server.	HighAvailability
maintenanceWindow	Maintenance window of a server.	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'

Sku

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)

Storage

Name	Description	Value
autoGrow	Enable Storage Auto Grow or not.	'Disabled' 'Enabled'
iops	Storage IOPS for a server.	int
storageSizeGB	Max storage size allowed for a server.	int

TrackedResourceTags

Name	Description	Value

Share via

Microsoft.DBforMySQL flexibleServers 2021-05-01-preview

Remarks

Bicep resource definition

Resource format

Property values

Backup

HighAvailability

Identity

MaintenanceWindow

Microsoft.DBforMySQL/flexibleServers

Network

ServerProperties

Sku

Storage

TrackedResourceTags

Quickstart samples

ARM template resource definition

Resource format

Property values

Backup

HighAvailability

Identity

MaintenanceWindow

Microsoft.DBforMySQL/flexibleServers

Network

ServerProperties

Sku

Storage

TrackedResourceTags

Quickstart templates

Terraform (AzAPI provider) resource definition

Resource format

Property values

Backup

HighAvailability

Identity

MaintenanceWindow

Microsoft.DBforMySQL/flexibleServers

Network

ServerProperties

Sku

Storage

TrackedResourceTags

Feedback

Additional resources