Microsoft.DBForMySql flexibleServers 2020-07-01-preview

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@2020-07-01-preview' = {
  name: 'string'
  location: 'string'
  tags: {
    tagName1: 'tagValue1'
    tagName2: 'tagValue2'
  }
  sku: {
    name: 'string'
    tier: 'string'
  }
  identity: {
    type: 'SystemAssigned'
  }
  properties: {
    administratorLogin: 'string'
    administratorLoginPassword: 'string'
    availabilityZone: 'string'
    createMode: 'string'
    delegatedSubnetArguments: {
      subnetArmResourceId: 'string'
    }
    haEnabled: 'string'
    infrastructureEncryption: 'string'
    maintenanceWindow: {
      customWindow: 'string'
      dayOfWeek: int
      startHour: int
      startMinute: int
    }
    privateDnsZoneArguments: {
      privateDnsZoneArmResourceId: 'string'
    }
    replicationRole: 'string'
    restorePointInTime: 'string'
    sourceServerId: 'string'
    sslEnforcement: 'string'
    storageProfile: {
      backupRetentionDays: int
      storageAutogrow: 'string'
      storageIops: int
      storageMB: int
    }
    tags: {}
    version: '5.7'
  }
}

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.	Sku
identity	The Azure Active Directory identity of the server.	Identity
properties	Properties of the server.	ServerProperties

Identity

Name	Description	Value
type	The identity type.	'SystemAssigned'

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
createMode	The mode to create a new MySQL server.	'Default' 'PointInTimeRestore' 'Replica'
delegatedSubnetArguments	Delegated subnet arguments.	DelegatedSubnetArguments
haEnabled	Enable HA or not for a server.	'Disabled' 'Enabled'
infrastructureEncryption	Status showing whether the server enabled infrastructure encryption.	'Disabled' 'Enabled'
maintenanceWindow	Maintenance window of a server.	MaintenanceWindow
privateDnsZoneArguments	private dns zone arguments.	PrivateDnsZoneArguments
replicationRole	The replication role.	string
restorePointInTime	Restore point creation time (ISO8601 format), specifying the time to restore from.	string
sourceServerId	The source MySQL server id.	string
sslEnforcement	Enable ssl enforcement or not when connect to server.	'Disabled' 'Enabled'
storageProfile	Storage profile of a server.	StorageProfile
tags	Application-specific metadata in the form of key-value pairs.	object
version	Server version.	'5.7'

DelegatedSubnetArguments

Name	Description	Value
subnetArmResourceId	delegated subnet arm resource id.	string

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

PrivateDnsZoneArguments

Name	Description	Value
privateDnsZoneArmResourceId	private dns zone arm resource id.	string

StorageProfile

Name	Description	Value
backupRetentionDays	Backup retention days for the server.	int
storageAutogrow	Enable Storage Auto Grow.	'Disabled' 'Enabled'
storageIops	Storage IOPS for a server.	int
storageMB	Max storage allowed for a server.	int

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)

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.

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": "2020-07-01-preview",
  "name": "string",
  "location": "string",
  "tags": {
    "tagName1": "tagValue1",
    "tagName2": "tagValue2"
  },
  "sku": {
    "name": "string",
    "tier": "string"
  },
  "identity": {
    "type": "SystemAssigned"
  },
  "properties": {
    "administratorLogin": "string",
    "administratorLoginPassword": "string",
    "availabilityZone": "string",
    "createMode": "string",
    "delegatedSubnetArguments": {
      "subnetArmResourceId": "string"
    },
    "haEnabled": "string",
    "infrastructureEncryption": "string",
    "maintenanceWindow": {
      "customWindow": "string",
      "dayOfWeek": "int",
      "startHour": "int",
      "startMinute": "int"
    },
    "privateDnsZoneArguments": {
      "privateDnsZoneArmResourceId": "string"
    },
    "replicationRole": "string",
    "restorePointInTime": "string",
    "sourceServerId": "string",
    "sslEnforcement": "string",
    "storageProfile": {
      "backupRetentionDays": "int",
      "storageAutogrow": "string",
      "storageIops": "int",
      "storageMB": "int"
    },
    "tags": {},
    "version": "5.7"
  }
}

Property values

flexibleServers

Name	Description	Value
type	The resource type	'Microsoft.DBForMySql/flexibleServers'
apiVersion	The resource api version	'2020-07-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.	Sku
identity	The Azure Active Directory identity of the server.	Identity
properties	Properties of the server.	ServerProperties

Identity

Name	Description	Value
type	The identity type.	'SystemAssigned'

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
createMode	The mode to create a new MySQL server.	'Default' 'PointInTimeRestore' 'Replica'
delegatedSubnetArguments	Delegated subnet arguments.	DelegatedSubnetArguments
haEnabled	Enable HA or not for a server.	'Disabled' 'Enabled'
infrastructureEncryption	Status showing whether the server enabled infrastructure encryption.	'Disabled' 'Enabled'
maintenanceWindow	Maintenance window of a server.	MaintenanceWindow
privateDnsZoneArguments	private dns zone arguments.	PrivateDnsZoneArguments
replicationRole	The replication role.	string
restorePointInTime	Restore point creation time (ISO8601 format), specifying the time to restore from.	string
sourceServerId	The source MySQL server id.	string
sslEnforcement	Enable ssl enforcement or not when connect to server.	'Disabled' 'Enabled'
storageProfile	Storage profile of a server.	StorageProfile
tags	Application-specific metadata in the form of key-value pairs.	object
version	Server version.	'5.7'

DelegatedSubnetArguments

Name	Description	Value
subnetArmResourceId	delegated subnet arm resource id.	string

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

PrivateDnsZoneArguments

Name	Description	Value
privateDnsZoneArmResourceId	private dns zone arm resource id.	string

StorageProfile

Name	Description	Value
backupRetentionDays	Backup retention days for the server.	int
storageAutogrow	Enable Storage Auto Grow.	'Disabled' 'Enabled'
storageIops	Storage IOPS for a server.	int
storageMB	Max storage allowed for a server.	int

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)

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@2020-07-01-preview"
  name = "string"
  location = "string"
  parent_id = "string"
  tags = {
    tagName1 = "tagValue1"
    tagName2 = "tagValue2"
  }
  identity {
    type = "SystemAssigned"
  }
  body = jsonencode({
    properties = {
      administratorLogin = "string"
      administratorLoginPassword = "string"
      availabilityZone = "string"
      createMode = "string"
      delegatedSubnetArguments = {
        subnetArmResourceId = "string"
      }
      haEnabled = "string"
      infrastructureEncryption = "string"
      maintenanceWindow = {
        customWindow = "string"
        dayOfWeek = int
        startHour = int
        startMinute = int
      }
      privateDnsZoneArguments = {
        privateDnsZoneArmResourceId = "string"
      }
      replicationRole = "string"
      restorePointInTime = "string"
      sourceServerId = "string"
      sslEnforcement = "string"
      storageProfile = {
        backupRetentionDays = int
        storageAutogrow = "string"
        storageIops = int
        storageMB = int
      }
      tags = {}
      version = "5.7"
    }
    sku = {
      name = "string"
      tier = "string"
    }
  })
}

Property values

flexibleServers

Name	Description	Value
type	The resource type	"Microsoft.DBForMySql/flexibleServers@2020-07-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.	Sku
identity	The Azure Active Directory identity of the server.	Identity
properties	Properties of the server.	ServerProperties

Identity

Name	Description	Value
type	The identity type.	"SystemAssigned"

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
createMode	The mode to create a new MySQL server.	"Default" "PointInTimeRestore" "Replica"
delegatedSubnetArguments	Delegated subnet arguments.	DelegatedSubnetArguments
haEnabled	Enable HA or not for a server.	"Disabled" "Enabled"
infrastructureEncryption	Status showing whether the server enabled infrastructure encryption.	"Disabled" "Enabled"
maintenanceWindow	Maintenance window of a server.	MaintenanceWindow
privateDnsZoneArguments	private dns zone arguments.	PrivateDnsZoneArguments
replicationRole	The replication role.	string
restorePointInTime	Restore point creation time (ISO8601 format), specifying the time to restore from.	string
sourceServerId	The source MySQL server id.	string
sslEnforcement	Enable ssl enforcement or not when connect to server.	"Disabled" "Enabled"
storageProfile	Storage profile of a server.	StorageProfile
tags	Application-specific metadata in the form of key-value pairs.	object
version	Server version.	"5.7"

DelegatedSubnetArguments

Name	Description	Value
subnetArmResourceId	delegated subnet arm resource id.	string

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

PrivateDnsZoneArguments

Name	Description	Value
privateDnsZoneArmResourceId	private dns zone arm resource id.	string

StorageProfile

Name	Description	Value
backupRetentionDays	Backup retention days for the server.	int
storageAutogrow	Enable Storage Auto Grow.	"Disabled" "Enabled"
storageIops	Storage IOPS for a server.	int
storageMB	Max storage allowed for a server.	int

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)

Share via

Microsoft.DBForMySql flexibleServers 2020-07-01-preview

Bicep resource definition

Remarks

Resource format

Property values

flexibleServers

Identity

ServerProperties

DelegatedSubnetArguments

MaintenanceWindow

PrivateDnsZoneArguments

StorageProfile

Sku

Quickstart templates

ARM template resource definition

Remarks

Resource format

Property values

flexibleServers

Identity

ServerProperties

DelegatedSubnetArguments

MaintenanceWindow

PrivateDnsZoneArguments

StorageProfile

Sku

Quickstart templates

Terraform (AzAPI provider) resource definition

Resource format

Property values

flexibleServers

Identity

ServerProperties

DelegatedSubnetArguments

MaintenanceWindow

PrivateDnsZoneArguments

StorageProfile

Sku

Feedback

Additional resources