Skip to main content

MysqlFlexible


Resource Icon​

Resource Overview​

Azure Database for MySQL - Flexible Server is a fully managed production-ready database service designed to offer greater control and flexibility over database management features and configuration settings. Flexible Server is most suitable for:

  • Ease of deployment for features like backups, high availability, security, and monitoring, along with inherent scalability and reduced database management overhead.
  • Application development requiring a community edition of MySQL with better control and customization.
  • Production workloads with high availability through zone redundancy, zonal deployments, and managed maintenance windows.
  • Streamlined development environments.
  • Enterprise-grade security, compliance, and privacy.

Associated Resources​

Parent Resource​

Resource Setting Values​

  • version : MySQL version to use - 5.7, `8.0.21

  • sku_name : The name of SKU for the MySQL Server, Tier + compute generation + cores pattern - azureDatabaseSku

  • storage_gb : MySQL Server capacity(GB) - storageGB

  • iops : The storage IOPS for the MySQL Flexible Server - 360 ~ 20000

  • admin_username : If the creation mode is default, the administrator login for the MySQL Server

  • admin_password : If the creation mode is default, the password associated with the administrator login

  • auto_grow_enabled : Enable Storage Auto Grow - true , false

  • availability_zone : Specifies the Availability Zone. Possible values are 1, 2, 3. - 1 ~ 3

  • enable_high_availability : Enable high availability of MySQL Flexible Server - true , false

  • high_availability_mode : The high availability mode for the MySQL Flexible Server - SameZone , ZoneRedundant

  • standby_availability_zone : Specifies the Availability Zone in which the standby Flexible Server should be located. Possible values are 1, 2, 3, Availability Zones cannot overlap. - 1 ~ 3

  • backup_retention_days : The backup retention days for the MySQL Flexible Server. Possible values are between 1 and 35 days. - 1 ~ 35

  • public_network_access_enabled : Allow public network access for the Server - true , false

  • configuration

    • name : Name of the configuration for MySQL Flexible Server
    • param_value : Specifies the value of the MySQL Flexible Server Configuration

  • database

    • charset : The charset for the MySQL Database - azureMysqlChartSet
    • collation : The collation for the MySQL Database - azureMysqlCol

  • firewall_rule

    • start_ip_address: The Start IP Address asscociated with the Firewall Rule
    • end_ip_address: The End IP Address asscociated with the Firewall Rule

  • tag : Tag to categorize resources - up to 512 characters, key:value

Reference Materials​