last sync: 2025-Apr-29 17:44:12 Etc/UTC

MySQL Server - Microsoft Azure Resource type
microsoft.dbformysql/flexibleservers

Azure Resource Provider Resource provider (RP) - Microsoft DB for MySQL [Microsoft.DBforMySQL]
RP Microsoft.DBforMySQL
RP display name Microsoft DB for MySQL
Azure Resource Type
RP Resource types
Resource types: 76
Azure Policy Alias
RP aliases
RP aliases: 185
Azure Policy definition
RP Azure Policy
Azure Policy definitions: 27
if: 27
then.deployment: 4
then.details: 1
then.existenceCondition: 0
then.operations: 0
Azure RBAC Role Based Access Control
RP RBAC operations
RP RBAC operations: 144
RP RBAC operationType action: 37
RP RBAC operationType delete: 14
RP RBAC operationType read: 69
RP RBAC operationType write: 24
Azure RBAC Role definition
RP RBAC Roles & Operation actions
Unique RBAC Roles: 19
RBAC Roles with action operationType: 6
RBAC Roles with delete operationType: 4
RBAC Roles with read operationType: 19
RBAC Roles with write operationType: 5
Azure Application
RP related 1st party Service Principals
RP related 1st party Service Principals: 4
• Meru19 MySQL First Party App (appId: e6f9f783-1fdb-4755-acaf-abed6c642885)
• Azure SQL Virtual Network to Network Resource Provider (appId: 76cd24bf-a9fc-4344-b1dc-908275de6d6d) [ JSON;CSV]
• Azure OSSRDBMS MySQL Flexible Server BYOK (appId: cb43afba-eb6b-4cef-bf00-758b6c233beb)
• Azure OSSRDBMS Database (appId: 123cd850-d9df-40bd-94d5-c9f07b7fa203)
All Azure RPs Microsoft Learn
AzResourceTypesAdvertizer (Microsoft only)
Azure Resource Type Resource type (RT) - MySQL Server [microsoft.dbformysql/flexibleservers]
RT information
RT microsoft.dbformysql/flexibleservers
RT display name MySQL Server
RT type only
(without RP)
flexibleServers
RT sub- Resource types sub-Resource types: 20
RT schema RT schema API versions: 14
All Microsoft Azure RTs AzResourceTypesAdvertizer
Aliases and Azure Policy
Azure Policy Alias
Aliases
aliases: 83
Azure Policy definition
Azure Policy
Azure Policy definitions: 10
if: 10
then.deployment: 0
then.details: 0
then.existenceCondition: 0
then.operations: 0
RBAC Operations and Roles & Roles related operation actions
Azure RBAC Role Based Access Control
RBAC operations
RBAC operations: 19
RBAC operationType action: 16
RBAC operationType delete: 1
RBAC operationType read: 1
RBAC operationType write: 1
Azure RBAC Role definition
RBAC Roles & Operation actions
Unique RBAC Roles: 19
RBAC Roles with action operationType: 4
RBAC Roles with delete operationType: 4
RBAC Roles with read operationType: 18
RBAC Roles with write operationType: 4
Capabilities & Locations
Azure Resource Diagnostic settings logs
Diagnostic logs
True
log-categories
Azure Resource Diagnostic settings metrics
Diagnostic metrics
True
metrics
Azure Customer-managed key
Customer-managed key (CMK) [experimental]
Unknown
Enforce Encryption with a customer-managed key (CMK) at scale
Azure Managed identity
System-Assigned-Resource-Identity
False
Azure Resource Mover
Cross-ResourceGroup-Resource-Move
True
Azure Resource Mover
Cross-Subscription-Resource-Move
True
Azure Resource Tags
Tags
True
Azure Extension
Extension
False
Azure Private Endpoint
Private-Endpoint
True
Azure Private Endpoint location Azure Private Endpoint location
Supported Locations for Private-Endpoint
Supported Locations for Private-Endpoint: 44
australiacentral, australiaeast, australiasoutheast, brazilsouth, canadacentral, canadaeast, centralindia, centralus, eastasia, eastus, eastus2, francecentral, germanywestcentral, indonesiacentral, israelcentral, italynorth, japaneast, japanwest, jioindiawest, koreacentral, koreasouth, mexicocentral, newzealandnorth, northcentralus, northeurope, norwayeast, polandcentral, qatarcentral, southafricanorth, southcentralus, southeastasia, southindia, spaincentral, swedencentral, switzerlandnorth, uaenorth, uksouth, ukwest, westcentralus, westeurope, westindia, westus, westus2, westus3
Non supported Locations for Private-Endpoint Non supported Locations for Private-Endpoint: 14
brazilus, eastusstg, centraluseuap, eastus2euap, southcentralusstg, southafricawest, australiacentral2, jioindiacentral, francesouth, germanynorth, norwaywest, switzerlandwest, uaecentral, brazilsoutheast
Azure location
Location
True
Azure Resource type location Azure Resource type location
Locations
Locations: 48
australiacentral, australiaeast, australiasoutheast, brazilsouth, brazilsoutheast, canadacentral, canadaeast, centralindia, centralus, eastasia, eastus, eastus2, francecentral, francesouth, germanynorth, germanywestcentral, israelcentral, italynorth, japaneast, japanwest, koreacentral, koreasouth, mexicocentral, newzealandnorth, northcentralus, northeurope, norwayeast, norwaywest, polandcentral, qatarcentral, southafricanorth, southafricawest, southcentralus, southeastasia, southindia, spaincentral, swedencentral, switzerlandnorth, switzerlandwest, uaecentral, uaenorth, uksouth, ukwest, westcentralus, westeurope, westus, westus2, westus3
Not locations Not locations: 49
asia, asiapacific, australia, australiacentral2, brazil, brazilus, canada, centraluseuap, centralusstage, eastasiastage, eastus2euap, eastus2stage, eastusstage, eastusstg, europe, france, germany, global, india, indonesia, indonesiacentral, israel, italy, japan, jioindiacentral, jioindiawest, korea, mexico, newzealand, northcentralusstage, norway, poland, qatar, singapore, southafrica, southcentralusstage, southcentralusstg, southeastasiastage, spain, sweden, switzerland, taiwan, uae, uk, unitedstates, unitedstateseuap, westindia, westus2stage, westusstage
Assessment tooling
Azure Advisor
Azure Advisor
Azure Advisor recommendations: 21
HighAvailability [High] Globally set the value of the innodb_strict_mode server parameter to OFF
HighAvailability [High] High Availability - Add primary key to the table that currently does not have one.
HighAvailability [High] Replication - Add a primary key to the table that currently does not have one
HighAvailability [High] Scale replica server's SKU to match the source server SKU
HighAvailability [High] Upgrade to Transport Layer Security (TLS) 1.2
OperationalExcellence [High] Enable storage autogrow for MySQL Flexible Server
OperationalExcellence [High] Optimize or partition tables in your database which has huge tablespace size
OperationalExcellence [High] Your Azure Database for MySQL - Flexible Server is vulnerable using weak, deprecated TLSv1 or TLSv1.1 protocols
OperationalExcellence [Low] Apply resource delete lock
OperationalExcellence [Medium] Add firewall rules for MySQL Flexible Server
Performance [High] Enable Accelerated Logs for improved performance
Performance [High] Improve performance by optimizing MySQL temporary-table sizing
Performance [High] Increase the MySQL Flexible Server vCores
Performance [High] Increase the storage IOPS
Performance [High] Increase the storage limit for MySQL Flexible Server
Performance [Medium] Add a MySQL Read Replica server
Performance [Medium] Boost your workload performance by 30% with the new Ev5 compute hardware
Performance [Medium] Move your MySQL server to Memory Optimized SKU
Performance [Medium] Scale the MySQL Flexible Server to a higher SKU
Security [High] Microsoft Defender for SQL should be enabled for unprotected MySQL flexible servers
Security [Medium] Azure MySQL flexible server should have Azure Active Directory Only Authentication enabled
Azure Proactive Resilience Library v2 (APRLv2)
Azure Proactive Resilience Library v2 (APRLv2)
Azure Proactive Resilience Library v2 recommendations: 4
DisasterRecovery [High] Configure geo redundant backup storage
DisasterRecovery [High] Configure one or more read replicas
HighAvailability [High] Enable HA with zone redundancy
Scalability [High] Configure storage auto-grow
PSRule for Azure
PSRule for Azure
PSRule for Azure rules: 5
Reliability [Important] Customer-controlled maintenance window configuration
Reliability [Important] Use Azure Database for MySQL Flexible Server
Reliability [Important] Zone-Redundant High Availability
Security [Critical] Use Entra ID authentication with MySQL databases
Security [Important] Entra ID only authentication
Azure Quick Review (AZQR)
Azure Quick Review (AZQR)
Azure Quick Review (AZQR) recommendations: 10
DisasterRecovery [High] Configure geo redundant backup storage
DisasterRecovery [High] Configure one or more read replicas
Governance [Low] Azure Database for MySQL - Flexible Server Name should comply with naming conventions
Governance [Low] Azure Database for MySQL - Flexible Server should have tags
HighAvailability [High] Azure Database for MySQL - Flexible Server should have a SLA
HighAvailability [High] Enable HA with zone redundancy
MonitoringAndAlerting [Low] Azure Database for MySQL - Flexible Server should have diagnostic settings enabled
Scalability [High] Configure storage auto-grow
Scalability [High] Enable custom maintenance schedule
Security [High] Azure Database for MySQL - Flexible Server should have private access enabled
Infrastructure as Code (IaC)
ARM (Azure Resource Manager)
ARM (Azure Resource Manager) templates
ARM (Azure Resource Manager) template API versions: 14
latest
Azure Bicep
Bicep templates
Bicep template API versions: 14
latest
Terraform
Terraform provider
Terraform providers: 1
mysql_flexible_server
AzAPI Terraform
AzAPI Terraform templates
AzAPI Terraform template API versions: 14
latest
Pulumi
Pulumi provider
Pulumi providers: 1
dbformysql/server
OpenTofu
OpenTofu provider
OpenTofu TF providers: 1
mysql_flexible_server
Azure Verified Modules (AVM) Bicep Azure Verified Modules (AVM) Bicep
Azure Verified Modules (AVM) Bicep
DB for MySQL Flexible Server
Azure Verified Modules (AVM) Terraform Azure Verified Modules (AVM) Terraform
Azure Verified Modules (AVM) Terraform
• GitHub: DB for MySQL Flexible Server
• Terraform registry: DB for MySQL Flexible Server
REST-API (Representational State Transfer - Application Programming Interface)
REST-API versions REST-API versions: 23
2024-12-30
2024-12-01-preview
2024-10-30
2024-10-01-preview
2024-06-30
2024-06-01-preview
2024-02-28
2024-02-01-preview
2023-12-30
2023-12-01-preview
2023-10-01-preview
2023-06-30
2023-06-01-preview
2022-09-30-privatepreview
2022-09-30-preview
2022-06-01-privatepreview
2022-06-01-preview
2022-01-01
2021-12-01-preview
2021-05-01-preview
2021-05-01
2020-07-01-privatepreview
2020-07-01-preview
REST-API version default 2023-10-01-preview
API profiles n/a
Resource naming
Azure Naming Tool
Azure Naming Tool
The Azure Naming Tool was created to help administrators define and manage their naming conventions, while providing a simple interface for users to generate a compliant name.
Resource naming details n/a