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

APPLIES TO: Azure Database for MySQL - Single Server

Azure Database for MySQL is a relational database service in the Microsoft cloud. The service is based on the MySQL Community Edition (available under the GPLv2 license) database engine and supports versions 5.6(retired), 5.7, and 8.0. Azure Database for MySQL - Single Server is a deployment mode that provides a fully managed database service with minimal requirements for customizations of database. The Single Server platform is designed to handle most database management functions such as patching, backups, high availability, and security, all with minimal user configuration and control.

This article summarizes new releases and features in Azure Database for MySQL - Single Server beginning in January 2021. Listings appear in reverse chronological order, with the most recent updates first.

October 2021

  • Known Issues

The MySQL 8.0.27 client is incompatible with Azure Database for MySQL - Single Server. All connections from the MySQL 8.0.27 client created either via mysql.exe or workbench will fail. As a workaround, consider using an earlier version of the client (prior to MySQL 8.0.27) or creating an instance of Azure Database for MySQL - Flexible Server instead.

June 2021

This release of Azure Database for MySQL - Single Server includes the following updates.

  • Enabled the ability to change the server parameter activate_all_roles_on_login from Portal/CLI for MySQL 8.0

    Users can now change the value of the activate_all_roles_on_login parameter using the Azure portal and CLI. This parameter helps to configure whether to enable automatic activation of all granted roles when users sign in to the server. For more information, see Server System Variables.

  • Addressed MySQL Community Bugs #29596969 and #94668

    This release addresses an issue with the default expression being ignored in a CREATE TABLE query if the field was marked as PRIMARY KEY for MySQL 8.0. (MySQL Community Bug #29596969, Bug #94668). For more information, see MySQL Bugs: #94668: Expression Default is made NULL during CREATE TABLE query, if field is made PK

  • Addressed an issue with duplicate table names in "SHOW TABLE" query

    We've introduced a new function to give a fine-grained control of the table cache during the table operation. Because of a code defect in the new feature, the entry in the directory cache might be miss configured or added and cause the unexpected behavior like return two tables with the same name. The directory cache only works for the “SHOW TABLE” related query; it won't impact any DML or DDL queries. This issue is completely resolved in this release.

  • Increased the default value for the server parameter max_heap_table_size to help reduce temp table spills to disk

    With this release, the max allowed value for the parameter max_heap_table_size has been changed to 8589934592 for General Purpose 64 vCore and Memory Optimize 32 vCore.

  • Addressed an issue with setting the value of the parameter sql_require_primary_key from the portal

    Users can now modify the value of the parameter sql_require_primary_key directly from the Azure portal.

  • General Availability of planned maintenance notification

    This release provides General Availability of planned maintenance notifications in Azure Database for MySQL - Single Server. For more information, see the article Planned maintenance notification.

  • Enabled the parameter redirect_enabled by default

    With this release, the parameter redirect_enabled will be enabled by default. Redirection aims to reduce network latency between client applications and MySQL servers by allowing applications to connect directly to backend server nodes. Support for redirection in PHP applications is available through the mysqlnd_azure extension, developed by Microsoft. For more information, see the article Connect to Azure Database for MySQL with redirection.

Note

  • Redirection does not work with Private link setup. If you are using Private link for Azure Database for MySQL, you might encounter connection issue. To resolve the issue, make sure the parameter redirect_enabled is set to “OFF” and the client application is restarted.
  • If you have a PHP application that uses the mysqlnd_azure redirection driver to connect to Azure Database for MySQL (with redirection enabled by default), you might face a data encoding issue that impacts your insert transactions..
    To resolve this issue, either:
    • In Azure portal, disable the redirection by setting the redirect_enabled parameter to “OFF”, and restart the PHP application to clear the driver cache after the change.
      • Explicitly set the charset related parameters at the session level, based on your settings after the connection is established (for example “set names utf8mb4”).

February 2021

This release of Azure Database for MySQL - Single Server includes the following updates.

  • Added new stored procedures to support the global transaction identifier (GTID) for data-in for the version 5.7 and 8.0 Large Storage server.
  • Updated to support MySQL versions to 5.6.50 and 5.7.32.

January 2021

This release of Azure Database for MySQL - Single Server includes the following updates.

  • Enabled "reset password" to automatically fix the first admin permission.
  • Exposed the auto_increment_increment/auto_increment_offset server parameter and session_track_gtids.
  • Added new stored procedures for control innodb buffer pool dump/restore.
  • Exposed the innodb warm up related server parameter for large storage server.

Contacts

If you have questions about or suggestions for working with Azure Database for MySQL, contact the Azure Database for MySQL Team (@Ask Azure DB for MySQL). This email address isn't a technical support alias.

In addition, consider the following points of contact as appropriate:

Next steps