This post has been republished via RSS; it originally appeared at: Microsoft Tech Community - Latest Blogs - .
With the retirement of Azure Database for MySQL – Single Server scheduled for this September, it’s time to move to Azure Database for MySQL – Flexible Server. The move improves performance, offers better value, and is supported by an easy migration process for your high-performance online transaction processing (OLTP) applications according to a recent study by Principled Technologies. Overall, Flexible Server delivers up to 266 percent better performance per dollar plus significantly faster transactions and lower latency compared to Single Server.
With a new and improved architecture, Azure Database for MySQL – Flexible Server advances the computation, availability, scalability, and performance capabilities of this fully managed MySQL service. You get better performance across all service tiers and more ways to control your costs and ensure business continuity.
Better value and stronger OLTP performance
Principled Technologies compared similar configurations of Azure Database for MySQL – Single Server and Azure Database for MySQL – Flexible Server in its study, “Improving database performance and value with an easy migration to Azure Database for MySQL – Flexible Server with AMD EPYC.” The tests used sysbench, the standard for MySQL benchmarking, to simulate OLTP performance, reporting data in transactions per second (TPS) and queries per second (QPS), and also compared latency in milliseconds.
Compared to Single Server, Flexible Server delivered up to:
- 266 percent better performance per dollar.
- 117 percent better performance.
- 54 percent lower latency.
Flexible Server leads in price-performance for mission-critical workloads based on a comparison of monthly costs.
The study calculated the price-performance value as the median of the three runs performed for each test (TPS, QPS, latency). Flexible Server has the clear advantage, meaning you can pay up to 266 percent less for the same performance. In a straight OLTP comparison, Flexible Server outperforms Single Server in transactions per minute (TPM)—another practical business advantage. For example, your websites can handle more sales, more customers, and more transactions while lower latency can translate to faster load and response times for database users.
Sysbench performance tests show that Flexible Server delivers better performance to handle heavy traffic on your applications.
The performance tests used a 5-minute run time at multiple thread counts. For Flexible Server, the new autoscale IOPS feature enabled IOPS to automatically adjust based on workload requirements.
A related study by Principled Technologies concludes that Azure Database for MySQL leads in price-performance for mission-critical workloads. With accelerated logs enabled, the Azure Database for MySQL Business Critical service tier costs up to 54 percent less than MySQL on Amazon Relational Database Service (RDS) and costs up to 51 percent less than Google Cloud Platform (GCP) Cloud SQL for MySQL.
A new level of AI-powered innovation
With Flexible Server, database performance is no longer limited by the compute, storage, or IOPs capacity. You benefit from better performance, and it’s easier to monitor and manage operations and provision the right IOPs limit for a server.
Flexible Server also features the latest innovations and integrations with Azure OpenAI and Azure Cognitive Search, enabling you to build new AI-driven intelligent applications with your MySQL data.
Super fast migration
Single Server is scheduled for retirement by September 16, 2024. We recommend upgrading to Flexible Server for the best MySQL experience. Migration is free of charge, and the Principled Technology study reports that the command-line interface tool that Microsoft offers makes it easy. The study used Azure Database for MySQL Import to move a sample 50 GB database from an 8vCPU Single Server to a similar Flexible Server configuration. The move took just a few steps and finished in as little as 9 minutes, 10 seconds.
The migration command provides smart defaults for the required parameters, such as tier, version, and location, and you can customize the options. You can also choose from other offline and online migration tools based on in-place auto-migration or Azure Database Migration Service (classic).
Learn more
Read the study: Improving database performance and value with an easy migration to Azure Database for MySQL – Flexible Server with AMD EPYC.
For more information: