Boost Azure MySQL Business Critical flexible server performance by 30% with the Ev5 compute series!

[Guest Bashar-MSFT]

Overview

 

 

Azure Database for MySQL flexible servers based on the Business Critical tier with Ev5 show outstanding performance, with up to 30% more QPS (queries per second) and 50% lower latency compared to Ev4.

 

 

 

Ev5-series virtual machines run on the 3rd Generation Intel® Xeon® Platinum 8370C (Ice Lake) processor in a hyper threaded configuration, which provides a better value proposition for most general-purpose workloads. This new processor features an all core turbo clock speed of 3.5 GHz with Intel® Turbo Boost Technology, Intel® Advanced-Vector Extensions 512 (Intel® AVX-512), and Intel® Deep Learning Boost. Featuring up to 672 GiB of RAM, these virtual machines are ideal for memory-intensive enterprise applications, relational database servers, and in-memory analytics workloads.

 

 

 

Achieve 30% better performance in Business Critical with Ev5

 

 

The Business Critical tier is the recommended service tier for Tier 1 workloads that require higher QPS and lower latency. The new generation of compute offers better performance at the same price point in both low- and high-concurrency scenarios.

 

 

 

The graphs below compare the QPS and latency between Ev4 and Ev5 for a common OLTP workload (70% reads and 30% writes) running on a 16 vCore Azure Database for MySQL – flexible server based on the Business Critical tier.

 

The first graph focuses on a high-concurrency scenario. We ran sysbench on 10 tables, each with 10 million records. QPS was more than 140K QPS for up to 500 connections.

 

 

 

 

 

 

For the low-concurrency scenario, we also ran sysbench on 10 tables, each with 10 million records. Here, we observed similar results showing that Ev5 is more performant than Ev4.

 

 

 

 

 

 

Availability

 

 

In addition, the Business Critical tier for Azure Database for MySQL – Flexible Server now supports the Ev5 compute series in more regions than ever!

 

 

 

Australia East	China East 2	Japan West	UK South
Australia Southeast	China North 2	Korea Central	UK West
Brazil South	East US	Korea South	West Central US
Canada Central	East US 2	North Europe	West Europe
Canada East	France Central	South Africa North	West US
Central India	Germany West Central	South Central US	West US 2
Central US	Japan East	Switzerland North	West US 3

 

 

 

Conclusion

 

 

The Business Critical tier in the Azure Database for MySQL - Flexible Server is tuned specifically to support Tier-1 workloads that require high QPS and low latency. With the new Ev5 compute hardware, you can boost workload performance by 30% with higher concurrency and better throughput.

 

 

 

Links

 

• Benchmarking Azure Database for MySQL – Flexible Server using Sysbench
  
• Announcing Azure Database for MySQL - Flexible Server for business-critical workloads
  

 

Continue reading...