Azure Database for MySQL - Supported MySQL Versions
This page provides a comprehensive list of MySQL versions supported by Azure Database for MySQL. Understanding the supported versions is crucial for planning your database deployments and ensuring compatibility with your applications.
General Availability (GA) Versions
Azure Database for MySQL offers the following General Availability (GA) versions:
- MySQL 8.0: The latest stable release, offering significant performance improvements, enhanced security features, and new SQL functionalities.
- MySQL 5.7: A widely adopted and stable version, providing a robust set of features for most application workloads.
Community Editions and Editions Comparison
Azure Database for MySQL is based on the community edition of MySQL. We strive to keep up with the latest community releases. The following table summarizes key differences and considerations:
| Feature/Version | MySQL 8.0 | MySQL 5.7 |
|---|---|---|
| Release Year | 2018 | 2015 |
| Performance | Significantly improved, especially for read/write heavy workloads. | Good performance, but generally lower than 8.0. |
| Security | Enhanced authentication, data masking, password management. | Standard security features. |
| JSON Support | Native JSON data type and functions. | Limited JSON support via string manipulation. |
| Window Functions | Yes | No |
| Common Table Expressions (CTEs) | Yes | No |
| Default Character Set | utf8mb4 |
latin1 |
| Upgradability from 5.7 | Supported via in-place upgrade or migration. | N/A |
Tip
For new projects or when migrating, we recommend using MySQL 8.0 due to its advanced features, performance enhancements, and ongoing support.
Unsupported Versions
Azure Database for MySQL does not support older versions such as MySQL 5.6, 5.5, or earlier. If you are running on an unsupported version, you will need to migrate your data to a supported version of Azure Database for MySQL.
Finding Your Server Version
You can check the MySQL version of your Azure Database for MySQL server using the following SQL query:
SELECT @@VERSION;Note
When you create a new Azure Database for MySQL server, you will be prompted to select a supported MySQL version.
Future Support
Microsoft is committed to supporting the latest stable releases of MySQL. We continuously evaluate new MySQL versions for inclusion in Azure Database for MySQL. Please refer to the Overview page for the most up-to-date information.