Microsoft announces general availability of Azure Database for MySQL

Microsoft recently announced the general availability (GA) of the Azure Database for MySQL – Flexible Server.

Azure Database for MySQL – Flexible Server is a deployment mode designed to provide more granular control and flexibility over database management functions and configuration settings than the Single server deployment mode.

Over a year ago, the company released the preview version Flexible Server to provide customers with control, flexibility, and the ability to customize their MySQL database configuration to quickly meet specific performance, scalability, high availability, and cost optimization goals. Now, almost after a year of continuous service improvement by offering various features, it’s AG.

Source: https://techcommunity.microsoft.com/t5/azure-database-for-mysql/announcing-flexible-server-for-azure-database-for-mysql/ba-p/1686617

Microsoft designed the new deployment mode to:

  • Simplify the application development experience using tools pre-integrated with GitHub, Terraform, Azure Kubernetes Services, and Web Apps
  • Enable the development of highly available, resilient and scalable applications with the ability to select high availability in the same zone or zone redundant and the ability to scale up to 10 Read Replicas
  • Allows users to fine-tune over 300 database settings, choose their maintenance schedule, scale IOPS independent of provisioned storage, and specify the optimal amount of CPU and memory resources
  • Allow users to optimize their costs
  • Secure data with full network isolation, data-at-rest encryption and encrypted connections with full control over the application of TLS and SSL

Users can create Azure Database for MySQL using the Azure portal, CLI, Where ARM model and configure the Flexible Server deployment mode option. Note that the Flexible Server option only supports MySQL versions 5.7 and 8.0. Moreover, in addition to the unique and flexible Server mode, users can also deploy MySQL to Azure virtual machines.

The last stack overflow developer survey reported MySQL as the most used database by developers. Therefore, Microsoft and other public cloud providers like Google and AWS offer MySQL services on their platforms. For example, Google offers Cloud SQL, a fully managed relational database service for MySQL, PostgreSQL, and SQL Server. Cloud SQL is currently compatible with MySQL 8.0, 5.7, and 5.6 and provides up to 416 GB of RAM and 30 TB of data storage for each managed database. In the same way, MySQL on Amazon RDS also supports these versions with various instance sizes.

In a Microsoft Tech community blog post, Director of Product, Platform and Infrastructure at GitHub Ilya Tillis noted:

As a large MySQL store that manages hundreds of database servers in our own data centers, we certainly know what it takes to create powerful and reliable data tiers. The zone redundancy and scalability of MySQL Flexible Server provisioning has helped us accelerate the expansion of our internal cloud usage at GitHub.

The MySQL Flexible Server Azure Database is currently available in more than 30 regions in the world. In addition, details of the service are available on the Azure Database for MySQL landing page and prices on the price page.

Maria H. Underwood