Edit

Share via

What's new in Azure Database for MySQL - Flexible Server?

  • Article

APPLIES TO: Azure Database for MySQL - Flexible Server

Azure Database for MySQL - Flexible Server deployment model is a deployment mode designed to provide more granular control and flexibility over database management functions and configuration settings than the Azure Database for MySQL single server deployment mode. The service currently supports the community versions of MySQL 5.7 and 8.0.

This article summarizes new releases and features in the Azure Database for MySQL flexible server, which will begin in January 2021. Listings appear in reverse chronological order, with the most recent updates first.

Note

This article references the term slave, which Microsoft no longer uses. When the term is removed from the software, we'll remove it from this article.

May 2024

  • Accelerated Logs in Azure Database for MySQL Flexible Server is now Generally Available

    We're thrilled to announce the General Availability (GA) of the Accelerated Logs feature for Azure Database for MySQL Flexible Server. This feature is available within the Business-Critical service tier, which significantly enhances the performance of Azure Database for MySQL Flexible Server instances. It offers a dynamic solution designed for high throughput needs, reducing latency with no additional cost. Learn more.

  • Support for storage up to 32 TB in Azure Database for MySQL Flexible Server is now Generally Available

    We're excited to announce the general availability (GA) of storage support up to 32 TB in Azure Database for MySQL Flexible Server. The feature is available only in the Business Critical service tier. To learn more, visit service tiers.

April 2024

  • Enhanced Memory Allocation in Azure Database for MySQL Flexible Server

    In the April deployments, we introduced optimized memory allocation for Azure Database for MySQL Flexible Server. This refinement ensures a more accurate and efficient memory calculation for the MySQL Server component, allowing it to utilize available resources effectively for query processing and data management. Azure Database for MySQL - Flexible Server service tiers.

  • Enhanced Monitoring for Azure Database for MySQL Flexible Server: Introducing New Metrics

    The newly added metrics include MySQL Uptime, MySQL History list length, MySQL Deadlocks, Active Transactions, and MySQL Lock Timeouts. These metrics provide a more detailed view of your server's performance, enabling you to monitor and optimize your database operations more effectively. In addition to these new metrics, we've also improved the Memory percent metric. It now offers more precise calculations of memory usage for the MySQL server (mysqld) process. Monitor Azure Database for MySQL - Flexible Server

  • Microsoft Defender for Cloud supports Azure Database for MySQL flexible server (General Availability)

    We're excited to announce the general availability of the Microsoft Defender for Cloud feature for Azure Database for MySQL flexible server in all service tiers. The Microsoft Defender Advanced Threat Protection feature simplifies the security management of Azure Database for MySQL flexible server instances. It monitors the server for anomalous or suspicious database activities to detect potential threats and provides security alerts for you to investigate and take appropriate action, allowing you to actively improve the security posture of your database without being a security expert. What is Microsoft Defender for open-source relational databases

  • On-demand backup and Export (Preview)

    Azure Database for MySQL Flexible Server now allows triggering an on-demand server backup and exporting it to an Azure storage account (Azure blob storage). The feature is currently in public preview and available only in public cloud regions. Learn more

  • Known Issues

    While attempting to enable the Microsoft Defender for Cloud feature for an Azure Database for MySQL flexible server, you might encounter the following error: 'The server <server_name> is incompatible with Advanced Threat Protection. Contact Microsoft support to update the server to a supported version.' This issue can occur on MySQL Flexible Servers still awaiting an internal update. It's automatically resolved in the following internal update of your server. Alternatively, you can open a support ticket to expedite an immediate update."

March 2024

February 2024

  • Accelerated Logs is now available for existing servers and three new regions.

    Accelerated Logs, previously limited to servers created after November 14, is now accessible for all existing Business Critical tier's standalone servers in the preview phase. Accelerated logs also support Microsoft Entra authentication for Azure Database for MySQL - Flexible Server. Additionally, this feature has been extended to include three new regions: Japan East, Korea Central, and Poland Central. Accelerated logs feature in Azure Database for MySQL - Flexible Server (Preview)

  • Known Issues

    Due to a technical issue in this month's deployment, primary servers with read-replica are temporarily restricted from enabling the accelerated logs feature. Users should turn off the accelerated logs feature before creating a replica server. If you require assistance with accelerated logs and replica creation, open a support ticket for assistance. Learn more.

  • Audit logs now support wild card entries

    The server parameters now support wildcards in audit_log_include_users and audit_log_exclude_users, enhancing flexibility for specifying user inclusions and exclusions in audit logs. Learn more

  • Enhanced Audit Logging with CONNECTION_V2 for Comprehensive MySQL User Audits

    Server parameter audit_log_events now supports event CONNECTION_V2 for detailed connection logs, providing insights into user audits, connection status, and error codes in MySQL interactions.Learn more

December 2023

  • Near Zero Downtime Maintenance for Azure Database for MySQL Flexible Server (Preview)

    This feature significantly reduces maintenance-related downtime, typically maintaining operations under 60 seconds in most cases. Using planned failover in HA enabled servers, it updates the standby server first, followed by a failover to make it the primary, and concludes with updating the former primary server, ensuring minimal service disruption.Learn more

  • Error logs under server logs for Azure Database for MySQL Flexible Server (Preview)

    This new feature enables direct access to MySQL Server error logs, significantly improving the ability to troubleshoot issues and enhancing transparency and independence with Azure Database for MySQL Flexible Server.Error logs in Azure Database for MySQL - Flexible Server (Preview)

November 2023

  • Enhanced replica provisioning experience

    The replica provisioning experience will now provide extra flexibility to modify the replica compute and storage settings during the provisioning workflow. You can modify the computing settings of the replica server at the time of provisioning instead of making the changes after provisioning the replica server. The feature will also enable the modification of the backup retention days of the replica server and the configuration of it to have a different value than that of the source server.

  • Modify multiple server parameters using Azure CLI

    You can now conveniently update multiple server parameters for your Azure Database for MySQL flexible server instance using Azure CLI. Learn more.

  • Accelerated logs in Azure Database for MySQL flexible server (Preview)

    We're excited to announce a preview of the accelerated logs feature for Azure Database for MySQL's flexible server. This feature is available within the Business Critical service tier. Accelerated logs significantly enhance the performance of Azure Database for MySQL flexible server instances, offering a dynamic solution that is designed for high throughput needs that also reduces latency and optimizes cost efficiency.Accelerated logs feature in Azure Database for MySQL - Flexible Server (Preview).

  • Universal Geo Restore in Azure Database for MySQL flexible server (General Availability)

    The Universal Geo Restore feature allows you to restore a source server instance to an alternate region from the Azure supported regions where the Azure Database for MySQL flexible server is available. If a large-scale incident in a region results in the unavailability of a database application, then you can use this feature as a disaster recovery option to restore the server to an Azure-supported target region that's different from the source server region. Learn more.

October 2023

  • Addition of New vCore Options in Azure Database for MySQL flexible server

    We're excited to inform you that we have introduced 20 new vCores options under the Business Critical Service tier for Azure Database for MySQL flexible server. Find more information under Compute Option for Azure Database for MySQL flexible server.

  • Known Issues

    • When attempting to modify the User assigned managed identity and Key identifier in a single request while changing the CMK settings, the operation gets struck. We're working on the upcoming deployment for the permanent solution to address this issue. In the meantime, ensure that you perform the two operations of updating the User Assigned Managed Identity and Key identifier in separate requests. The sequence of these operations isn't critical, as long as the user-assigned identities have the necessary access to both key vaults.
    • We identified a known issue where customers are unable to initialize a new Custom Maintenance Window (CMW) configuration while creating or updating their Azure Database for MySQL flexible server instance using ARM/CLI/RestAPI. Currently, the CMW configuration can only be initially set up through the Azure portal. Subsequent modifications to the CMW can then be made during server updates. We're actively working to resolve this limitation. As a workaround, customers can manually set up a CMW for their MySQL server via the Azure portal before making any further changes through ARM/CLI/RestAPI.

September 2023

  • Flexible Maintenance for Azure Database for MySQL flexible server (Public Preview)

    Flexible Maintenance for Azure Database for MySQL flexible server enables a tailored maintenance schedule to suit your operational rhythm. This feature allows you to reschedule maintenance tasks within a maximum 14-day window and initiate on-demand maintenance, granting you unprecedented control over server upkeep timing. Stay tuned for more customizable experiences in the future. Scheduled maintenance in Azure Database for MySQL - Flexible Server.

  • Universal Cross Region Read Replica on Azure Database for MySQL flexible server (General Availability)

    Azure Database for MySQL flexible server now supports Universal Read Replicas in Public regions. This feature allows you to replicate your data from an instance of Azure Database for MySQL flexible server to a read-only server in the Universal region, which could be any region from the list of Azure supported regions where Azure Database for MySQL flexible server is available. Read replicas in Azure Database for MySQL - Flexible Server.

  • Private Link for Azure Database for MySQL flexible server (General Availability)

    You can now enable private endpoints to provide a secure means to access the Azure Database for MySQL flexible server via a Private Link, allowing both public and private access simultaneously. If necessary, you have the choice to restrict public access, ensuring that connections are exclusively routed through private endpoints for heightened network security. It's also possible to configure or update Private Link settings either during or after the creation of the server. Private Link for Azure Database for MySQL - Flexible Server.

  • Azure MySQL Import Smart Defaults for Azure Database for MySQL single server to Azure Database for MySQL flexible server migration (Public Preview)

    You can now migrate an Azure Database for MySQL single server instance to an Azure Database for MySQL flexible server instance by running a single CLI command with minimal inputs. The command leverages smart defaults for target Azure Database for MySQL flexible server provisioning based on the source server SKU and properties! Migrate Azure Database for MySQL - Single Server to Flexible Server using Azure Database for MySQL Import CLI.

  • Nominate an eligible Azure Database for MySQL single server instance for in-place automigration to Azure Database for MySQL flexible server

    If you own an Azure Database for MySQL single server workload with Basic or GP SKU, data storage used < 10 GiB, and no complex features (CMK, Microsoft Entra ID, Read Replica, Private Link) enabled, you can now nominate yourself (if not already scheduled by the service) for in-place automigration to Azure Database for MySQL flexible server by submitting your server details through this form.

August 2023

  • Universal Geo Restore in Azure Database for MySQL flexible server (Public Preview)

    The Universal Geo Restore feature allows you to restore a source server instance to an alternate region from the Azure supported regions where the Azure Database for MySQL flexible server is available. If a large-scale incident in a region results in the unavailability of database applications, you can use this feature as a disaster recovery option to restore the server to an Azure-supported target region that's different from the source server region. Learn more.

  • Generated Invisible Primary Key in Azure Database for MySQL flexible server

    Azure Database for MySQL flexible server now supports generated invisible primary key (GIPK) for MySQL version 8.0. With this change, by default, the value of the server system variable "sql_generate_invisible_primary_key" is ON for all Azure Database for MySQL flexible server instances on MySQL 8.0. With GIPK mode ON, MySQL generates an invisible primary key to any InnoDB table, which is newly created without an explicit primary key. Learn more about the GIPK mode: Generated Invisible Primary Keys and Invisible Column Metadata.

July 2023

  • Autoscale IOPS in Azure Database for MySQL flexible server (General Availability)

    You can now scale IOPS on demand without having to pre-provision a certain amount of IOPS. With this feature, you can now enjoy worry-free IO management in Azure Database for MySQL flexible server because the server scales IOPs up or down automatically depending on workload needs. With this feature, you pay only for the IO you use and no longer need to provision and pay for resources you aren't fully using, saving time and money. The autoscale IOPS feature eliminates the administration required to provide the best performance for Azure Database for MySQL flexible server customers at the lowest cost. Learn more.

June 2023

  • Private Link for Azure Database for MySQL flexible server (Preview)

    You can now enable private access to the Azure Database for MySQL flexible server using Private Link. Azure Private Link essentially brings Azure services inside your private Virtual Network (virtual network). Using the private IP address, the Azure Database for MySQL flexible server instance is accessible just like any other resource within the virtual network. Private Link for Azure Database for MySQL - Flexible Server.

  • Enhanced Data Encryption with Customer Managed Keys for Azure Database for MySQL flexible server

    Azure Database for MySQL flexible server now supports allowing access to Azure Key Vault from selected Vnets to enable data encryption using Customer-Managed Keys. Data encryption with customer managed keys for Azure Database for MySQL - Flexible Server.

  • Server Parameters support for Azure Database for MySQL- Flexible Server

    contact our support team if you need assistance with the server parameters below.

    [lower_case_table_names] (https://dev.mysql.com/doc/refman/8.0/en/server-system-variables.html#sysvar_lower_case_table_names ): MySQL version 5.7 supports a value change to 2. Changing the value from two back to 1 isn't allowed. contact our support team for assistance.

    innodb_flush_log_at_trx_commit: This parameter determines the level of strictness for commit operations to ensure ACID compliance. Changing the value from its default setting might result in data loss.

  • Max IOPS support for Azure Database for MySQL- Flexible Server

    Business Critical SKU now supports 80 K IOPS, enabling enhanced performance with increased IO operations per second. Learn more.

May 2023

  • Read-Replica in Geo-Paired Region on Azure Database for MySQL- Flexible Server (General Availability)

    Azure Database for MySQL - Flexible server now supports cross-region read-replica in a geo-paired region. The feature allows you to replicate your data from an instance of Azure Database for MySQL Flexible Server to a read-only server in a geo-paired region. Read replicas in Azure Database for MySQL - Flexible Server

  • Support for data-in replication using GTID

    Flexible Server now also supports Replicate data into Azure Database for MySQL - Flexible Server using GTID based replication. You can also use this feature to configure data-in replication for HA-enabled servers. To learn more - see how to configure data-in replication using GTID

  • Major version upgrades from 5.7 to 8.0 for Azure Database for MySQL flexible server (General Availability)

    The major version upgrade feature allows you to perform in-place upgrades of existing instances of Azure Database for MySQL flexible server from MySQL 5.7 to MySQL 8.0 with the select of a button, without any data movement or the need to make any application connection string changes. With the ability to upgrade your Azure Database for MySQL flexible server major version from 5.7 to 8.0, you'll gain access to performance enhancements, security improvements, and new features, such as Data Dictionary, JSON enhancements, and Windows functions. Major version upgrade in Azure Database for MySQL - Flexible Server

April 2023

  • Known issues

    When the storage autogrow feature is enabled and pre-provisioned IOPS is increased, it might result in unexpected increase in the storage size of the instance. We're actively working to resolve this issue and will provide updates as soon as they're available.

March 2023

  • Azure Resource Health

    Use Azure Resource Health to monitor the health and availability of the HA-enabled server if there's a planned or unplanned failover. High availability concepts in Azure Database for MySQL - Flexible Server

  • Enhanced restore experience

    Restore experience provides extra flexibility to modify the compute and storage settings while provisioning the restored server. The restored server can currently be configured to have a higher compute tier, compute size, and storage than the source server at the time of provisioning. Options like "Storage autogrow", "Backup retention days," and "Geo-redundancy" can also be edited to have a different value than that of the source server.

February 2023

  • Enhanced metrics workbook is now available

    Monitor system's performance with our recently added Enhanced Metrics workbook. With all enhanced metrics consolidated in one place, you can easily monitor and track your system's health and make informed decisions to improve its overall performance.

  • Major version upgrade is now back and available for use

    The Major Version upgrade feature was temporarily disabled in the portal due to technical issues, but it's now back in use. If you encounter any issues with the upgrade feature, open a support ticket and we assist you.

  • Redo logs management in MySQL version 8.0

    Starting from MySQL version 8.0.30 and above, there has been a change in the way the redo log is configured. Instead of using the innodb_log_file_size variable, the redo log can now be easily adjusted from the available values using the innodb_redo_log_capacity variable. Learn more.

  • Unsupported Server Parameters

    The ability to modify the thread_handling parameter in the Azure Database for MySQL Flexible Server is discontinued considering the underlying architecture and performance.

  • Minor version upgrade for Azure Database for MySQL - Flexible server to 8.0.31

    After this month's deployment, Azure Database for MySQL flexible server 8.0 will be running on minor version 8.0.31*, to learn more about changes coming in this minor version visit Changes in MySQL 8.0.31 (2022-10-11, General Availability)

  • Known issues

    Upgrade Option Unavailable in Portal: Following technical issues after this month's deployment, the Major Version Upgrade feature has been temporarily disabled. We apologize for any inconvenience. Our team is working on a solution, and the issue will be resolved in the next deployment cycle. If you require immediate assistance with the Major Version Upgrade, open a support ticket, and we assist you.

December 2022

  • New Replication Metrics

    You can now have a better visibility into replication performance and health through newly exposed replication status metrics based on different replication types offered by Azure Database for MySQL- Flexible Server. Learn More

  • Support for Data-out Replication

    Azure Database for MySQL: Flexible Server now supports Data-out replication. This capability allows customers to synchronize data out of Azure Database for MySQL flexible server (source) to another MySQL (replica) which could be on-premises, in virtual machines, or a database service hosted outside of Azure. Learn more about How to configure Azure Database for MySQL - Flexible Server data-out replication.

November 2022

  • Microsoft Entra IDauthentication for Azure Database for MySQL – Flexible Server (General Availability)

    Using identities, you can now authenticate to Azure Database for MySQL - Flexible server using Microsoft Entra ID. With authentication, you can manage database user identities and other Microsoft services in a central location, simplifying permission management. Microsoft Entra authentication for Azure Database for MySQL - Flexible Server

  • Customer managed keys data encryption – Azure Database for MySQL – Flexible Server (General Availability)

    With data encryption with customer-managed keys (CMKs) for Azure Database for MySQL flexible server Preview, you can bring your key (BYOK) for data protection at rest and implement separation of duties managing keys and data. Data encryption with CMKs is set at the server level. For a given server, a CMK, called the key encryption key (KEK), is used to encrypt the data encryption key (DEK) used by the service. With customer managed keys (CMKs), the customer is responsible for the full control of the key lifecycle management (key creation, upload, rotation, deletion), key usage permissions, and auditing operations on keys. Data encryption with customer managed keys for Azure Database for MySQL - Flexible Server

  • General availability in Azure US Government regions Azure Database for MySQL flexible server is now available in the following Azure regions:

    • USGov Virginia
    • USGov Arizona
    • USGov Texas

  • Known issues

    In specific scenario wherein if the source server if configured as Zone redundant HA and also enabled for Geo-redundancy, the geo-restore workflow fails if the target region doesn't have availability zone support.

October 2022

  • AMD compute SKUs for General Purpose and Business Critical tiers in Azure Database for MySQL flexible server

    You can now choose between Intel and AMD hardware for Azure Database for MySQL flexible server instances based on the General Purpose (Dadsv5-series) and Business Critical (Eadsv5-series) tiers. AMD SKU offers competitive price-performance options to all Azure Database for MySQL flexible server users. To ensure transparency in the portal, you can select the compute hardware vendor for both primary and secondary server. After determining the best compute processor for your workload, deploy flexible servers in more available regions and zones. Azure Database for MySQL - Flexible Server service tiers.

  • Autoscale IOPS in Azure Database for MySQL flexible server (Preview)

    You can now scale IOPS on demand without having to pre-provision a certain amount of IOPS. With this feature, you can now enjoy worry free IO management in Azure Database for MySQL flexible server because the server scales IOPs up or down automatically depending on workload needs. With this feature, you pay only for the IO you use and no longer need to provision and pay for resources they aren't fully using, saving time and money. In addition, mission-critical Tier-1 applications can achieve consistent performance by making extra IO available to the workload anytime. Auto scale IO eliminates the administration required to provide the best performance for Azure Database for MySQL customers at the least cost. Azure Database for MySQL - Flexible Server service tiers

  • Perform Major version upgrade with minimal efforts for Azure Database for MySQL flexible server (Preview)

    The major version upgrade feature allows you to perform in-place upgrades of existing instances of Azure Database for MySQL flexible server from MySQL 5.7 to MySQL 8.0 with the select of a button, without any data movement or the need to make any application connection string changes. Take advantage of this functionality to efficiently perform major version upgrades on your instances of Azure Database for MySQL flexible server and use the latest MySQL 8.0 offers. Major version upgrade in Azure Database for MySQL - Flexible Server.

  • MySQL extension for Azure Data Studio (Preview)

    When working with multiple databases across data platforms and cloud deployment models, performing the most common tasks on all your databases using a single tool enhances productivity several fold. With the MySQL extension for Azure Data Studio, you can now connect to and modify MySQL databases along with your other databases, taking advantage of the modern editor experience and capabilities in Azure Data Studio, such as IntelliSense, code snippets, source control integration, native Jupyter Notebooks, an integrated terminal, and more. Use this new tooling with any MySQL server hosted on-premises, on virtual machines, on managed MySQL in other clouds, and on Azure Database for MySQL flexible server. Quickstart: Use Azure Data Studio to connect and query MySQL.

  • Enhanced metrics for better monitoring

    You can now monitor more metrics under monitoring for your Azure Database for MySQL flexible server instance. Enhanced metrics allow you to have more visibility and monitor performance with Innodb metrics and troubleshoot database management operations with metrics like DML statistics and DDL statistics. Learn more

  • Server parameters that are now configurable

    List of server parameters that are now configurable.

  • Known issues

    • Change of compute size isn't currently permitted after the Major version upgrade in Azure Database for MySQL - Flexible Server of your Azure Database for MySQL flexible server instance. Changing the compute size of your Azure Database for MySQL flexible server instance is recommended before the major version upgrade from version 5.7 to version 8.0.

September 2022

  • Read replica for HA enabled Azure Database for MySQL flexible server (General Availability)

    The read replica feature allows you to replicate data from an Azure Database for MySQL flexible server instance to a read-only server. You can replicate the source server to up to 10 replicas. This functionality is now extended to support HA enabled servers within same region. Read replicas in Azure Database for MySQL - Flexible Server.

  • Microsoft Entra IDauthentication for Azure Database for MySQL flexible server (Public Preview)

    You can now authenticate to Azure Database for MySQL flexible server using Microsoft Entra ID using identities. With authentication, you can manage database user identities and other Microsoft services in a central location, simplifying permission management. Microsoft Entra authentication for Azure Database for MySQL - Flexible Server.

  • Known issues

    • The server parameter aad_auth_only stays set to ON only when the authentication type is changed to Microsoft Entra IDauthentication. We recommend disabling it manually when you opt for MySQL authentication only in the future.

    • The newly restored server will also have the server parameter aad_auth_only set to ON if it was ON on the source server during failover. You must manually disable this server parameter to use MySQL authentication on the restored server. Otherwise, an Admin must be configured.

  • Customer managed keys data encryption – Azure Database for MySQL flexible server (Preview)

    With data encryption with customer-managed keys (CMKs) for Azure Database for MySQL flexible server Preview, you can bring your key (BYOK) for data protection at rest and implement separation of duties for managing keys and data. Data encryption with CMKs is set at the server level. For a given server, a CMK, called the key encryption key (KEK), is used to encrypt the data encryption key (DEK) used by the service. With customer managed keys (CMKs), the customer is responsible for the full control of the key lifecycle management (key creation, upload, rotation, deletion), key usage permissions, and auditing operations on keys. Data encryption with customer managed keys for Azure Database for MySQL - Flexible Server.

  • Change Timezone of your Azure Database for MySQL flexible server instance in a single step

    Previously to change time_zone of your Azure Database for MySQL flexible server instance required two steps to take effect. Now you no longer need to call the procedure mysql.az_load_timezone() to populate the mysql.time_zone_name table. Azure Database for MySQL flexible server timezone can be changed directly by just changing the server parameter time_zone from portal or CLI.

  • Known issues

    • The server parameter aad_auth_only stays set to ON only when the authentication type is changed to Microsoft Entra IDauthentication. We recommend disabling it manually when you opt for MySQL authentication only in the future.

    • The newly restored server will also have the server parameter aad_auth_only set to ON if it was ON on the source server during failover. To use MySQL authentication on the restored server, you must manually disable this server parameter. Otherwise, an Admin must be configured.

August 2022

June 2022

  • Known Issues

    You might no longer see logs uploaded to data sinks configured under diagnostics settings on a few servers where audit or slow logs are enabled. Verify whether your logs have the latest updated timestamp for the events based on the data sink you've configured. If your server is affected by this issue, open a support ticket so that we can apply a quick fix on the server to resolve the issue.

May 2022

  • Announcing Azure Database for MySQL flexible server for business-critical workloads Azure Database for MySQL flexible server Business Critical service tier is generally available. The Business Critical service tier is ideal for Tier 1 production workloads that require low latency, high concurrency, fast failover, and high scalability, such as gaming, e-commerce, and Internet-scale applications, to learn more about Business Critical service Tier.

  • Announcing the addition of new Burstable compute instances for Azure Database for MySQL flexible server We're announcing the addition of new Burstable compute instances to support customers' autoscaling compute requirements from 1 vCore up to 20 vCores. learn more about Compute Option for Azure Database for MySQL flexible server.

  • Known issues

    • The Reserved instances (RI) feature in Azure Database for MySQL flexible server isn't working properly for the Business Critical service tier after rebranding from the Memory Optimized service tier. Specifically, instance reservation has stopped working, and we're working to fix the issue.
    • Private DNS integration details aren't displayed on a few Azure Database for MySQL Database flexible server instances that have enabled HA. This issue doesn't impact the server's availability or name resolution. We're working on a permanent fix to resolve the issue, and it will be available in the next deployment. Meanwhile, suppose you want to view the Private DNS Zone details. In that case, you can either search under Quickstart: Create an Azure private DNS zone using the Azure portal in the Azure portal or you can perform a manual failover of the HA enabled Azure Database for MySQL flexible server instance and refresh the Azure portal.

April 2022

  • Minor version upgrade for Azure Database for MySQL flexible server to 8.0.28 Azure Database for MySQL flexible server 8.0 now is running on minor version 8.0.28. To learn more about changes coming in this minor version, see Changes in MySQL 8.0.28 (2022-01-18, General Availability).

  • Minor version upgrade for Azure Database for MySQL flexible server to 5.7.37 Azure Database for MySQL flexible server 5.7 is now running on minor version 5.7.37. To learn more about changes coming in this minor version, see Changes in MySQL 5.7.37 (2022-01-18, General Availability.

    Note

    Some regions are still running older minor versions of Azure Database for MySQL flexible server and will be patched by end of April 2022.

  • Deprecation of TLSv1 or TLSv1.1 protocols with Azure Database for MySQL flexible server (8.0.28)

    Starting version 8.0.28, the MySQL community edition supports TLS protocol TLSv1.2 or TLSv1.3 only. Azure Database for MySQL flexible server will also stop supporting TLSv1 and TLSv1.1 protocols to align with modern security standards. You can no longer configure TLSv1 or TLSv1.1 from the server parameter pane for newly created and previously created resources. The default is TLSv1.2. Resources created before the upgrade still support communication through TLS protocol TLSv1 or TLS v1.1 through May 1, 2022.

March 2022

This release of Azure Database for MySQL flexible server includes the following updates.

  • Migrate from locally redundant backup storage to geo-redundant backup storage for existing flexible server Azure Database for MySQL flexible server provides the added flexibility to migrate to geo-redundant backup storage from locally redundant backup storage post server-create to provide higher data resiliency. Enabling geo-redundancy via the server's Compute + Storage page empowers customers to recover their existing Azure Database for MySQL flexible server instances from a geographic disaster or regional failure when they can't access the server in the primary region. With this feature enabled for their existing servers, customers can perform geo-restore and deploy a new server to the geo-paired Azure region using the original server's latest geo-redundant backup. Backup and restore in Azure Database for MySQL - Flexible Server.

  • Simulate disaster recovery drills for your stopped servers Azure Database for MySQL flexible server now provides the ability to perform geo-restore on stopped servers helping users simulate disaster recovery drills for their workloads to estimate impact and recovery time. This helps users plan better to meet their disaster recovery and business continuity objectives by using geo-redundancy feature offered by Azure Database for MySQL flexible server. Point-in-time restore in Azure Database for MySQL - Flexible Server with Azure CLI.

January 2022

This release of Azure Database for MySQL flexible server includes the following updates.

  • All Operations are disabled on Stopped Azure Database for MySQL flexible server instances Operations on servers in a Stop state are disabled and show as inactive in the Azure portal. Operations that aren't supported on stopped servers include changing the pricing tier, number of vCores, storage size or IOPS, backup retention day, server tag, the server password, server parameters, storage autogrow, GEO backup, HA, and user identity.

  • Availability in three additional Azure regions

    The public preview of Azure Database for MySQL flexible server is now available in the following Azure regions:

    • China East 2
    • China North 2

  • Reserving 36 IOPs for Azure Database for MySQL flexible server instances that have HA enabled

    We're adding 36 IOPs and reserving them to support standby failover operation on servers that have enabled High Availability. This IOPs is in addition to the configured IOPs on your servers, so more monthly charges would apply based on your Azure region. The extra IOPS help us ensure our commitment to providing smooth failover experience from primary to standby replica. The added charge can be estimated by navigating to the Azure Database for MySQL flexible server pricing page, choosing the Azure region for your server, and multiplying IOPs/month cost by 36 IOPs. For example, if your server is hosted in East US, the extra IO costs you can expect are $0.05*36 = USD 1.8 per month.

  • Bug fixes

    Restart workflow struck issue with servers with HA, and Geo-redundant backup option enabled is fixed.

  • Known issues

    • When you're using ARM templates for provisioning or configuration changes for HA enabled servers, if a single deployment is made to enable/disable HA and other server properties like backup redundancy, storage etc., then deployment would fail. You can mitigate it by submitting the deployment request separately to enable\disable and configuration changes. You don't have an issue with Portal or Azure CLI, as these requests are already separated.

    • When you're viewing automated backups for a HA enabled server on the Backup and Restore page, if at some point in time a forced or automatic failover is performed, you might lose viewing rights to the server's backups on the Backup and Restore page. Despite the invisibility of information regarding backups on the portal, the flexible server is successfully taking daily automated backups for the server in the backend. The server can be restored to any point within the retention period.

November 2021

  • General Availability of Azure Database for MySQL flexible server

    Azure Database for MySQL flexible server is now General Availability in more than Azure Database for MySQL - Flexible Server deployment model worldwide.

  • View available full backups in Azure portal

    A dedicated Backup and Restore option is now available in the Azure portal. This page lists the backups available within the server's retention period, effectively providing a single pane view for managing a server's backups and consequent restores. You can use this option to:

    1. View the completion timestamps for all available full backups within the server's retention period
    2. Perform restore operations using these full backups

  • Fastest restore points

    With the fastest restore point option, you can restore an Azure Database for MySQL flexible server instance in the fastest time possible on a given day within the server's retention period. This restore operation restores the full snapshot backup without requiring restore or recovery of logs. With fastest restore point, customers will see three options while performing point in time restores from Azure portal viz latest restore point, custom restore point and fastest restore point. Learn more.

  • FAQ in the Azure portal

    The Backup and Restore page includes a section dedicated to listing your most frequently asked questions and answers. This should provide answers to most questions about backup directly within the Azure portal. In addition, selecting the question mark icon for FAQs on the top menu provides access to even more related detail.

  • Restore a deleted Azure Database for MySQL flexible server instance

    The service now allows you to recover a deleted Azure Database for MySQL flexible server resource within five days from the time of server deletion. For a detailed guide on restoring a deleted server, refer to the documented steps. To protect server resources post deployment from accidental deletion or unexpected changes, we recommend administrators to use management locks.

  • Known issues

    On servers with HA and Geo-redundant backup option enabled, we found a rare issue encountered by a race condition, which blocks the restart of the standby server to finish. As a result of this issue, when you fail over the HA enabled Azure Database for MySQL flexible server instance might get stuck in restarting state for a long time. The fix will be deployed to the production in the next deployment cycle.

October 2021

  • Thread pools are now available for Azure Database for MySQL flexible server

    Thread pools enhance the scalability of Azure Database for MySQL flexible server. Using a thread pool, users can optimize performance, achieve better throughput, and lower latency for high concurrent workloads. Learn more.

  • Geo-redundant backup restore to geo-paired region for DR scenarios

    The service now provides the flexibility to choose geo-redundant backup storage for higher data resiliency. Enabling geo-redundancy empowers customers to recover from a geographic disaster or regional failure when they can't access the server in the primary region. With this feature enabled, customers can perform geo-restore and deploy a new server to the geo-paired geographic region using the original server's latest geo-redundant backup. Backup and restore in Azure Database for MySQL - Flexible Server.

  • Availability Zones Selection when creating Read replicas

    When creating Read replica, you can select the Availability Zones location of your choice. An Availability Zone is a high availability offering that protects your applications and data from datacenter failures. Availability Zones are unique physical locations within an Azure region. Read replicas in Azure Database for MySQL - Flexible Server.

  • Read replicas in Azure Database for MySQL flexible server will no longer be available on Burstable SKUs

    If you have an existing Azure Database for MySQL flexible server instance with read replica enabled, you have to scale up your server to either General Purpose or Business Critical pricing tiers or delete the read replica within 60 days. After the 60 days, while you can continue to use the primary server for your read-write operations, replication to read replica servers will be stopped. For newly created servers, read replica option is available only for the General Purpose and Business Critical pricing tiers.

  • Monitoring Azure Database for MySQL flexible server with Azure Monitor Workbooks

    Azure Database for MySQL flexible server is now integrated with Azure Monitor Workbooks. Workbooks provide a flexible canvas for data analysis and creating rich visual reports within the Azure portal. With this integration, the server has link to workbooks and few sample templates, which help to monitor the service at scale. These templates can be edited, customized to customer requirements and pinned to dashboard to create a focused and organized view of Azure resources. Tutorial: Query Performance Insight for Azure Database for MySQL - Flexible Server, Tutorial: Configure audit logs by using Azure Database for MySQL - Flexible Server, and Instance Overview templates are currently available. Monitor Azure Database for MySQL - Flexible Server by using Azure Monitor workbooks.

  • Prepay for Azure Database for MySQL flexible server compute resources with reserved instances

    Azure Database for MySQL flexible server now helps you save money by prepaying for compute resources compared to pay-as-you-go prices. With Azure Database for MySQL flexible server reserved instances, you make an upfront commitment on Azure Database for MySQL flexible server for one or three years to get a significant discount on the compute costs. You can exchange a reservation from Azure Database for MySQL single server with Azure Database for MySQL flexible server. Learn more.

  • Stopping the server for up to 30 days while the server is not in use

    Azure Database for MySQL flexible server now allows you to Stop the server for up to 30 days when not in use and Start the server when you're ready to resume your development. This enables you to develop at your own pace and save development costs on the database servers by paying for the resources only when used. This is important for dev-test workloads and when you only use the server for part of the day. When you stop the server, all active connections are dropped. When the server is in the Stopped state, the server's compute isn't billed. However, storage continues to be billed as the server's storage remains to ensure that data files are available when the server is started again. Learn more.

  • Terraform Support for Azure Database for MySQL flexible server

    Terraform support for Azure Database for MySQL flexible server is now released with the latest v2.81.0 release of azurerm. The detailed reference document for provisioning and managing an Azure Database for MySQL flexible server instance using Terraform can be found here. Any bugs or known issues can be found or reported here.

  • Static Parameter innodb_log_file_size is now Configurable

    • innodb_log_file_size can now be configured to any of these values: 256 MB, 512 MB, 1 GB, or 2 GB. Because it's a static parameter, it requires a server restart. If you've changed the parameter innodb_log_file_size from default, check if the "show global status like 'innodb_buffer_pool_pages_dirty'" stays at 0 for 30 seconds to avoid restart delay. See Server parameters in Azure Database for MySQL - Flexible Server to learn more.

  • Availability in two additional Azure regions

    Azure Database for MySQL flexible server is now available in the following Azure regions:

    • US West 3
    • North Central US

Learn more.

  • Known Issues
    • When a primary Azure region is down, you can't create geo-redundant servers in its geo-paired region as storage can't be provisioned in the primary Azure region. You must wait for the primary region to be up to provision geo-redundant servers in the geo-paired region.

September 2021

This release of Azure Database for MySQL flexible server includes the following updates.

  • Availability in three additional Azure regions

    The public preview of Azure Database for MySQL flexible server is now available in the following Azure regions:

    • UK West
    • Canada East
    • Japan West

  • Bug fixes

    Same-zone HA creation is fixed in the following regions:

    • Central India
    • East Asia
    • Korea Central
    • South Africa North
    • Switzerland North

August 2021

This release of Azure Database for MySQL flexible server includes the following updates.

  • High availability within a single zone using Same-Zone High Availability

    The service now allows customers to choose the preferred availability zone for their standby server when they enable high availability. With this feature, customers can place a standby server in the same zone as the primary server, which reduces the replication lag between primary and standby. This also provides lower latencies between the application server and database server if placed within the same Azure zone. High availability concepts in Azure Database for MySQL - Flexible Server.

  • Standby zone selection using Zone-Redundant High Availability

    The service now allows customers to choose the standby server zone location. Using this feature, customers can place their standby server in the zone of their choice. Colocating the standby database servers and applications in the same zone reduces latencies and allows customers to better prepare for disaster recovery situations and "zone down" scenarios. High availability concepts in Azure Database for MySQL - Flexible Server.

  • Private DNS zone integration

    What is an Azure Private DNS zone? provides a reliable and secure DNS service (responsible for translating a service name to IP address) for your virtual network. Azure Private DNS manages and resolves domain names in the virtual network without configuring a custom DNS solution. This enables you to connect your application running on a virtual network to your Azure Database for MySQL flexible server instance running on a locally or globally peered virtual network. Azure Database for MySQL flexible server now integrates with an Azure private DNS zone to allow seamless resolution of private DNS within the current virtual network, or any peered virtual network to which the private DNS zone is linked. With this integration, if the IP address of the backend Azure Database for MySQL flexible server instance changes during failover or any other event, your integrated private DNS zone is updated automatically to ensure your application connectivity resumes automatically once the server is online. Private Network Access using virtual network integration for Azure Database for MySQL - Flexible Server.

  • Point-In-Time Restore for a server in a specified virtual network

    The Point-In-Time Restore experience for the service now enables customers to configure networking settings, allowing users to switch between private and public networking options when performing a restore operation. This feature allows customers to inject a server being restored into a specified virtual network securing their connection endpoints. Point-in-time restore in Azure Database for MySQL - Flexible Server with the Azure portal.

  • Point-In-Time Restore for a server in an availability zone

    The Point-In-Time Restore experience for the service now enables customers to configure availability zone. Colocating the database servers and standby applications in the same zone reduces latencies and allows customers to better prepare for disaster recovery situations and "zone down" scenarios. High availability concepts in Azure Database for MySQL - Flexible Server.

  • validate_password and caching_sha2_password plugin available in private preview

    Azure Database for MySQL flexible server now supports enabling validate_password and caching_sha2_password plugins in preview. The validate_password plugin provides password policy enforcement and password strength validation. The caching_sha2_password plugin provides a more secure authentication method than the default mysql_native_password plugin. To learn more, visit server parameters.

  • Availability in four additional Azure regions

    The public preview of Azure Database for MySQL flexible server is now available in the following Azure regions:

    • Australia Southeast
    • South Africa North
    • East Asia (Hong Kong Special Administrative Region)
    • Central India

    Learn more.

  • Known issues

    • Right after Zone-Redundant high availability server failover, clients fail to connect to the server if using SSL with ssl_mode VERIFY_IDENTITY. This issue can be mitigated by using ssl_mode as VERIFY_CA.
    • Unable to create Same-Zone High availability server in the following regions: Central India, East Asia, Korea Central, South Africa North, Switzerland North.
    • In a rare scenario and after HA failover, the primary server is in read_only mode. Resolve the issue by updating "read_only" value from the server parameters page to OFF.
    • After successfully scaling Compute on the Compute + Storage page, IOPS are reset to the SKU default. Customers can work around the issue by rescaling IOPs on the Compute + Storage page to desired value (previously set) post the compute deployment and consequent IOPS reset.

July 2021

This release of Azure Database for MySQL flexible server includes the following updates.

  • Online migration from Azure Database for MySQL single server to Azure Database for MySQL flexible server

    Customers can now migrate an instance of Azure Database for MySQL single server to Azure Database for MySQL flexible server with minimum downtime to their applications using Data-in Replication. For detailed, step-by-step instructions, see Migrate Azure Database for MySQL single server instances to Azure Database for MySQL flexible server with minimal downtime.

  • Availability in West US and Germany West Central

    The public preview of Azure Database for MySQL flexible server is now available in the West US and Germany West Central Azure regions.

June 2021

This release of Azure Database for MySQL flexible server includes the following updates.

  • Improved performance on smaller storage servers

    Beginning June 21, 2021, the minimum allowed provisioned storage size for all newly created server increases from 5 GB to 20 GB. In addition, the available free IOPS increases from 100 to 300. These changes are summarized in the following table:

    Current As of June 21, 2021
    Minimum allowed storage size: 5 GB Minimum allowed storage size: 20 GB
    IOPS available: Max(100, 3 * [Storage provisioned in GB]) IOPS available: (300 + 3 * [Storage provisioned in GB])

  • Free 12-month offer

    As of June 15, 2021, the Azure free account provides customers up to 12 months of free access to Azure Database for MySQL flexible server with 750 hours of usage and 32 GB of storage per month. Customers can use this offer to develop and deploy applications that use Azure Database for MySQL flexible server. Use an Azure free account to try Azure Database for MySQL - Flexible Server for free.

  • Storage auto-grow

    Storage auto grow prevents a server from running out of storage and becoming read-only. If storage auto grow is enabled, the storage automatically grows without affecting the workload. Beginning June 21, 2021, all newly created servers have storage auto grow enabled by default.

  • Data-in Replication

    Azure Database for MySQL flexible server now supports Replicate data into Azure Database for MySQL - Flexible Server. Use this feature to synchronize and migrate data from a MySQL server running on-premises, in virtual machines, on Azure Database for MySQL single server, or database services outside Azure to Azure Database for MySQL flexible server. Learn more about How to configure Azure Database for MySQL - Flexible Server data-in replication.

  • GitHub Actions support with Azure CLI

    Azure Database for MySQL flexible server CLI now allows customers to automate workflows to deploy updates with GitHub Actions. This feature helps set up and deploy database updates with MySQL GitHub Actions workflow. These CLI commands assist with setting up a repository to enable continuous deployment for ease of development. Learn more.

  • Zone redundant HA forced failover fixes

    This release includes fixes for known issues related to forced failover to ensure that server parameters and more IOPS changes are persisted across failovers.

  • Known issues

    • Trying to perform up a compute scale or scale down operation on an existing server with less than 20 GB of storage provisioned doesn't complete successfully. Resolve the issue by scaling the provisioned storage to 20 GB and retrying the compute scaling operation.

May 2021

This release of Azure Database for MySQL flexible server includes the following updates.

  • Extended regional availability (France Central, Brazil South, and Switzerland North)

    The public preview of Azure Database for MySQL flexible server is now available in the France Central, Brazil South, and Switzerland North regions. Learn more.

  • SSL/TLS 1.2 enforcement can be disabled

    This release provides the enhanced flexibility to customize SSL and minimum TLS version enforcement. To learn more, see Connect to Azure Database for MySQL - Flexible Server with encrypted connections.

  • Zone redundant HA available in UK South and Japan East region

    Azure Database for MySQL flexible server now offers zone-redundant high availability in two more regions: UK South and Japan East. Learn more.

  • Known issues

    • Additional IOPs changes don't take effect in zone redundant HA enabled servers. Customers can work around the issue by disabling HA, scaling IOPs, and the re-enabling zone redundant HA.
    • After force failover, the standby availability zone is inaccurately reflected in the portal. (No workaround)
    • Server parameter changes don't take effect in zone redundant HA enabled server after forced failover. (No workaround)

April 2021

This release of Azure Database for MySQL flexible server includes the following updates.

  • Ability to force failover to standby server with zone redundant high availability released

    Customers can now manually force a failover to test functionality with their application scenarios, which can help them to prepare for any outages. Learn more.

  • PowerShell module for Azure Database for MySQL flexible server released

    Developers can now use PowerShell to provision, manage, operate, and support Azure Database for MySQL flexible server instances and dependent resources. Learn more.

  • Connect, test, and execute queries using Azure CLI

    Azure Database for MySQL flexible server now provides an improved developer experience allowing customers to connect and execute queries to their servers using the Azure CLI with the "az mysql flexible-server connect" and "az mysql flexible-server execute" commands. Learn more.

  • Fixes for provisioning failures for server creates in virtual network with private access

    All the provisioning failures caused when creating a server in virtual network are fixed. With this release, users can create Azure Database for MySQL flexible server instances with private access every time.

March 2021

This release of Azure Database for MySQL flexible server includes the following updates.

  • MySQL 8.0.21 released

    MySQL 8.0.21 is now available in Azure Database for MySQL flexible server in all major Azure regions. Customers can use the Azure portal, the Azure CLI, or Azure Resource Manager templates to provision the MySQL 8.0.21 release. Learn more.

  • Support for Availability zone placement during server creation released

    Customers can now specify their preferred Availability zone during server creation. This functionality allows customers to collocate their applications hosted on Azure VM, Virtual Machine Scale Set, or AKS and database in the same Availability zones to minimize database latency and improve performance. Learn more.

  • Performance fixes for issues when running Azure Database for MySQL flexible server in virtual network with private access

    Before this release, the performance of Azure Database for MySQL flexible server degraded significantly when running in virtual network configuration. This release includes the fixes for the issue, allowing users to see improved performance on Azure Database for MySQL flexible server in virtual network.

  • Known issues

    • SSL\TLS 1.2 is enforced and can't be disabled. (No workarounds)
    • There are intermittent provisioning failures for servers provisioned in a virtual network. The workaround is to retry the server provisioning until it succeeds.

February 2021

This release of Azure Database for MySQL flexible server includes the following updates.

  • Additional IOPS feature released

    Azure Database for MySQL flexible server supports provisioning more IOPS independent of the storage provisioned. Customers can use this feature to increase or decrease the number of IOPS anytime based on their workload requirements.

  • Known issues

    The performance of Azure Database for MySQL flexible server degrades with private access-virtual network isolation (No workaround).

January 2021

This release of Azure Database for MySQL flexible server includes the following updates.

  • Up to 10 read replicas for Azure Database for MySQL flexible server

    Azure Database for MySQL flexible server now supports asynchronous data replication from one Azure Database for MySQL flexible server instance (the 'source') to up to 10 Azure Database for MySQL flexible server instances (the 'replicas') in the same region. This functionality enables read-heavy workloads to scale out and be balanced across replica servers according to a user's preferences. Read replicas in Azure Database for MySQL - Flexible Server.

Feedback and support

If you have questions about or suggestions for working with Azure Database for MySQL flexible server, consider the following points of contact as appropriate:

Related content