MySQL on Azure Performance Benchmark – ScaleGrid vs. Azure Database
Tags: azure, mysql, database, benchmark
Published: 2020-09-28 15:14:32

---
title: MySQL on Azure Performance Benchmark – ScaleGrid vs. Azure Database
published: true
description: In this performance benchmark for MySQL on Azure, we put ScaleGrid up against Azure Database. See which provider gives you the most value for your money!
tags: azure, mysql, database, benchmark
cover_image: https://scalegrid.io/blog/wp-content/uploads/2020/08/mysql-azure-benchmark-scalegrid-vs-azure-database-performance-blog.jpg
---
<link rel="canonical" href="https://scalegrid.io/blog/mysql-on-azure-performance-benchmark-scalegrid-vs-azure-database/" />
<p style="text-align: justify;"><a style="color: #2da964;" href="https://azure.microsoft.com/en-us/" target="_blank">Microsoft Azure</a> is one of the most popular cloud providers in the world, and a natural fit for database hosting on applications leveraging Microsoft across their infrastructure. <a style="color: #2da964;" href="https://www.mysql.com/" target="_blank">MySQL</a> is the number one open source database that’s commonly hosted through Azure instances. While Microsoft offers their own Azure Database product, there are other alternatives available that may be able to help you improve your MySQL performance. In this blog post, we compare Azure Database for MySQL vs. <a style="color: #2da964;" href="https://scalegrid.io/blog/mysql-on-azure-performance-benchmark-scalegrid-vs-azure-database/" target="_blank">ScaleGrid MySQL on Azure</a> so you can see which provider offers the best throughput and latency performance. We measure latency in ms 95th percentile latency.</p>
<table style="background: #def5fe;">
<tbody>
<tr>
<th style="padding: 20px 30px 0px 30px;">
<h2>At a glance - TLDR</h2>
</th>
</tr>
<tr>
<td style="padding: 0px 30px 20px 30px;">
<table style="background: #def5fe;">
<tbody>
<tr>
<td style="border-bottom: 1px solid #b1cb25;" width="10%"><img class="alignnone size-full wp-image-5165" src="https://scalegrid.io/blog/wp-content/uploads/2020/03/ScaleGrid-Blog-At-a-Glance-1.png" alt="ScaleGrid Blog - At a glance overview - 1st point" width="65" height="65" /></td>
<td style="padding: 10px 20px; border-bottom: 1px solid #b1cb25;" width="85%">
<h4 style="font-size: 20px;">Read-Intensive Workloads</h4>
During Read-Intensive Workloads, ScaleGrid manages to achieve up to 3 times higher throughput and averages 66% better latency compared to Azure Database. <a style="color: #2da964; text-decoration: underline;" href="#1">Read now</a></td>
</tr>
<tr>
<td style="border-bottom: 1px solid #b1cb25;" width="10%"><img class="alignnone size-full wp-image-5169" src="https://scalegrid.io/blog/wp-content/uploads/2020/03/ScaleGrid-Blog-At-a-Glance-2.png" alt="ScaleGrid Blog - At a glance overview - 2nd point" width="65" height="65" /></td>
<td style="padding: 20px; border-bottom: 1px solid #b1cb25;" width="85%">
<h4 style="font-size: 20px;">Balanced Workloads</h4>
With an average of 150% better throughput, and less than one third of the latency, ScaleGrid outperforms Azure Database for Balanced Workloads. <a style="color: #2da964; text-decoration: underline;" href="#4">Read now</a></td>
</tr>
<tr>
<td width="10%"><img class="alignnone size-full wp-image-5170" src="https://scalegrid.io/blog/wp-content/uploads/2020/03/ScaleGrid-Blog-At-a-Glance-3.png" alt="ScaleGrid Blog - At a glance overview - 3rd point" width="65" height="65" /></td>
<td style="padding: 20px;" width="85%">
<h4 style="font-size: 20px;">Write-Intensive Workloads</h4>
Scalegrid achieves up to 4 times higher throughput and averages 64% lower latency across all number of threads compared to Azure Database for MySQL. <a style="color: #2da964; text-decoration: underline;" href="#7">Read now</a></td>
</tr>
</tbody>
</table>
</td>
</tr>
</tbody>
</table>

<p style="padding-top: 15px; text-align: justify;">Just getting started? Check out <a style="color: #2da964;" href="https://scalegrid.io/blog/the-best-way-to-host-mysql-on-azure-cloud/" target="_blank">The Best Way to Host MySQL on Azure Cloud</a> post to learn more about optimizing your cloud database deployment.</p>

<h2 style="padding-top: 15px;">MySQL Azure Performance Benchmark</h2>
<p style="text-align: justify;">In this benchmark report, we compare <a style="color: #2da964;" href="https://scalegrid.io/mysql.html" target="_blank">MySQL hosting</a> on Azure at ScaleGrid vs. <a style="color: #2da964;" href="https://azure.microsoft.com/en-us/services/mysql/" target="_blank">Azure Database for MySQL</a> across these three workload scenarios:</p>

<ul>
	<li>Read-Intensive Workload: 80% reads and 20% writes</li>
	<li>Balanced Workload: 50% reads and 50% writes</li>
	<li>Write-Intensive Workload: 20% reads and 80% writes</li>
</ul>
<p style="text-align: justify;">We measure the MySQL throughput and latency performance, and measure throughput in terms of queries per second (QPS) and latency in terms of 95th percentile (ms). Check out our <a style="color: #2da964;" href="#10">Benchmark Configuration</a> section below the performance report to see how these tests were configured.</p>

<h2 style="padding-top: 15px;"><a id="1"></a>MySQL Read-Intensive Performance</h2>
<p style="text-align: justify;">MySQL read-intensive workloads are workloads that are typically dominated by read operations, such as SELECT. So, a read-intensive workload would be one that searches the database more often vs. writing to it. Percona has a great post on <a style="color: #2da964;" href="https://www.percona.com/blog/2018/08/30/read-intensive-or-write-intensive-workload/" target="_blank">read-intensive vs. write-intensive</a> workloads where you can learn more.</p>
<p style="text-align: justify;">Let’s take a look at the throughput and latency performance of ScaleGrid MySQL vs. Azure Database for MySQL:</p>

<h3 style="padding-top: 15px;"><a id="2"></a>Throughput</h3>
<img class="alignnone wp-image-5828 size-full" src="https://scalegrid.io/blog/wp-content/uploads/2020/08/mysql-azure-scalegrid-read-intensive-throughput.jpg" alt="MySQL - ScaleGrid vs Azure Databases – Read-Intensive Throughput Performance Graph" width="100%" height="auto" />

<table width="100%">
<tbody>
<tr>
<th style="width: 36%;"><b>Threads</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #2da964; color: #fff;"><b>ScaleGrid</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #273039; color: #fff;"><b>Azure</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #def5fe;"><b>ScaleGrid Improvement</b></th>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">25</td>
<td style="padding: 10px; border: 1px solid #eee;">5,299</td>
<td style="padding: 10px; border: 1px solid #eee;">1,689</td>
<td style="padding: 10px; border: 1px solid #eee;">214%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">50</td>
<td style="padding: 10px; border: 1px solid #eee;">6,092</td>
<td style="padding: 10px; border: 1px solid #eee;">2,302</td>
<td style="padding: 10px; border: 1px solid #eee;">165%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">100</td>
<td style="padding: 10px; border: 1px solid #eee;">8,429</td>
<td style="padding: 10px; border: 1px solid #eee;">2,877</td>
<td style="padding: 10px; border: 1px solid #eee;">193%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">150</td>
<td style="padding: 10px; border: 1px solid #eee;">9,011</td>
<td style="padding: 10px; border: 1px solid #eee;">2,870</td>
<td style="padding: 10px; border: 1px solid #eee;">214%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">175</td>
<td style="padding: 10px; border: 1px solid #eee;">7,025</td>
<td style="padding: 10px; border: 1px solid #eee;">2,805</td>
<td style="padding: 10px; border: 1px solid #eee;">151%</td>
</tr>
</tbody>
</table>
<table style="margin-top: 15px;" width="100%">
<tbody>
<tr>
<td style="padding: 15px; background: #def5fe;"><span style="font-size: 18px;">As we can see from the above graph and performance table, ScaleGrid MySQL achieves <b>up to 3x higher throughput</b> compared to Azure Database for read-intensive workloads. While Azure Database for MySQL throughput is under 3,000 queries per second across all thread scenarios, ScaleGrid has over 5,000-9,000 queries per second across threads.</span></td>
</tr>
</tbody>
</table>

<h3 style="padding-top: 15px;"><a id="3"></a>Latency</h3>
<img class="alignnone size-full wp-image-5829" src="https://scalegrid.io/blog/wp-content/uploads/2020/08/mysql-azure-scalegrid-read-intensive-latency.jpg" alt="MySQL - ScaleGrid vs Azure Databases – Read-Intensive Latency Performance Graph" width="100%" height="auto" />

<table width="100%">
<tbody>
<tr>
<th style="width: 36%;"><b>Threads</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #2da964; color: #fff;"><b>ScaleGrid</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #273039; color: #fff;"><b>Azure</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #def5fe;"><b>ScaleGrid Improvement</b></th>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">25</td>
<td style="padding: 10px; border: 1px solid #eee;">258</td>
<td style="padding: 10px; border: 1px solid #eee;">451</td>
<td style="padding: 10px; border: 1px solid #eee;">-43%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">50</td>
<td style="padding: 10px; border: 1px solid #eee;">101</td>
<td style="padding: 10px; border: 1px solid #eee;">670</td>
<td style="padding: 10px; border: 1px solid #eee;">-85%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">100</td>
<td style="padding: 10px; border: 1px solid #eee;">148</td>
<td style="padding: 10px; border: 1px solid #eee;">978</td>
<td style="padding: 10px; border: 1px solid #eee;">-85%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">150</td>
<td style="padding: 10px; border: 1px solid #eee;">309</td>
<td style="padding: 10px; border: 1px solid #eee;">1562</td>
<td style="padding: 10px; border: 1px solid #eee;">-80%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">175</td>
<td style="padding: 10px; border: 1px solid #eee;">1,089</td>
<td style="padding: 10px; border: 1px solid #eee;">1,678</td>
<td style="padding: 10px; border: 1px solid #eee;">-35%</td>
</tr>
</tbody>
</table>
<table style="margin-top: 15px;" width="100%">
<tbody>
<tr>
<td style="padding: 15px; background: #def5fe;"><span style="font-size: 18px;">While Azure Database for MySQL latency rapidly increases as the number of threads grows, ScaleGrid MySQL steadily achieves low latency across all thread counts. On average, <b>ScaleGrid for MySQL has 66% lower latency than Azure Database</b> for MySQL for read-intensive workload scenarios.</span></td>
</tr>
</tbody>
</table>

<h2 style="padding-top: 15px;"><a id="4"></a>MySQL Balanced Workload Performance</h2>
<p style="text-align: justify;">Balanced workloads leverage roughly equal amounts of read operations and write operations.</p>

<h3 style="padding-top: 15px;"><a id="5"></a>Throughput</h3>
<img class="alignnone size-full wp-image-5830" src="https://scalegrid.io/blog/wp-content/uploads/2020/08/mysql-azure-scalegrid-balanced-throughput.jpg" alt="MySQL - ScaleGrid vs Azure Databases – Balanced Workload Throughput Performance Graph" width="100%" height="auto" />
<table width="100%">
<tbody>
<tr>
<th style="width: 36%;"><b>Threads</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #2da964; color: #fff;"><b>ScaleGrid</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #273039; color: #fff;"><b>Azure</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #def5fe;"><b>ScaleGrid Improvement</b></th>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">25</td>
<td style="padding: 10px; border: 1px solid #eee;">3,806</td>
<td style="padding: 10px; border: 1px solid #eee;">1,748</td>
<td style="padding: 10px; border: 1px solid #eee;">118%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">50</td>
<td style="padding: 10px; border: 1px solid #eee;">5,834</td>
<td style="padding: 10px; border: 1px solid #eee;">2,437</td>
<td style="padding: 10px; border: 1px solid #eee;">139%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">100</td>
<td style="padding: 10px; border: 1px solid #eee;">6,365</td>
<td style="padding: 10px; border: 1px solid #eee;">2,712</td>
<td style="padding: 10px; border: 1px solid #eee;">135%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">150</td>
<td style="padding: 10px; border: 1px solid #eee;">5,724</td>
<td style="padding: 10px; border: 1px solid #eee;">2,775</td>
<td style="padding: 10px; border: 1px solid #eee;">106%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">175</td>
<td style="padding: 10px; border: 1px solid #eee;">6,206</td>
<td style="padding: 10px; border: 1px solid #eee;">1,767</td>
<td style="padding: 10px; border: 1px solid #eee;">251%</td>
</tr>
</tbody>
</table>
<table style="margin-top: 15px;" width="100%">
<tbody>
<tr>
<td style="padding: 15px; background: #def5fe;"><span style="font-size: 18px;">On average, <b>ScaleGrid improved the MySQL throughput by 150% over Azure Database</b> for MySQL for balanced workloads, and is <b>over 2x better</b> across all number of threads. Azure Database maxed out at around 2,775 queries per second at 150 threads, while ScaleGrid achieved 5,724 queries per second for the same number of threads.</span></td>
</tr>
</tbody>
</table>
<p style="text-align: justify;"></p>

<h3 style="padding-top: 15px;"><a id="6"></a>Latency</h3>
<img class="alignnone size-full wp-image-5831" src="https://scalegrid.io/blog/wp-content/uploads/2020/08/mysql-azure-scalegrid-balanced-latency.jpg" alt="MySQL - ScaleGrid vs Azure Databases – Balanced Workload Latency Performance Graph" width="100%" height="auto" />
<table width="100%">
<tbody>
<tr>
<th style="width: 36%;"><b>Threads</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #2da964; color: #fff;"><b>ScaleGrid</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #273039; color: #fff;"><b>Azure</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #def5fe;"><b>ScaleGrid Improvement</b></th>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">25</td>
<td style="padding: 10px; border: 1px solid #eee;">76</td>
<td style="padding: 10px; border: 1px solid #eee;">390</td>
<td style="padding: 10px; border: 1px solid #eee;">-81%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">50</td>
<td style="padding: 10px; border: 1px solid #eee;">103</td>
<td style="padding: 10px; border: 1px solid #eee;">612</td>
<td style="padding: 10px; border: 1px solid #eee;">-83%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">100</td>
<td style="padding: 10px; border: 1px solid #eee;">240</td>
<td style="padding: 10px; border: 1px solid #eee;">943</td>
<td style="padding: 10px; border: 1px solid #eee;">-75%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">150</td>
<td style="padding: 10px; border: 1px solid #eee;">560</td>
<td style="padding: 10px; border: 1px solid #eee;">1,590</td>
<td style="padding: 10px; border: 1px solid #eee;">-65%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">175</td>
<td style="padding: 10px; border: 1px solid #eee;">560</td>
<td style="padding: 10px; border: 1px solid #eee;">2,199</td>
<td style="padding: 10px; border: 1px solid #eee;">-75%</td>
</tr>
</tbody>
</table>
<table style="margin-top: 15px;" width="100%">
<tbody>
<tr>
<td style="padding: 15px; background: #def5fe;"><span style="font-size: 18px;">We see another dramatic improvement in latency performance for balanced workloads, where ScaleGrid MySQL deployments are able to perform at <b>less than one third the latency</b> compared to Azure Database for MySQL.</span></td>
</tr>
</tbody>
</table>

<h2 style="padding-top: 15px;"><a id="7"></a>MySQL Write-Intensive Performance</h2>
<p style="text-align: justify;">While read operations are searching from the database, write operations are those that save to or modify the database, such as INSERT, UPDATE or DELETE queries. Write-intensive workloads are typically more expensive than read-intensive workloads as the operations consume more resources. Let’s compare ScaleGrid vs. Azure Database throughput and latency performance across MySQL write-intensive workloads.</p>

<h3 style="padding-top: 15px;"><a id="8"></a>Throughput</h3>
<img class="alignnone size-full wp-image-5832" src="https://scalegrid.io/blog/wp-content/uploads/2020/08/mysql-azure-scalegrid-write-intensive-throughput.jpg" alt="MySQL - ScaleGrid vs Azure Databases – Write-Intensive Throughput Performance Graph" width="100%" height="auto" />

<table width="100%">
<tbody>
<tr>
<th style="width: 36%;"><b>Threads</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #2da964; color: #fff;"><b>ScaleGrid</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #273039; color: #fff;"><b>Azure</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #def5fe;"><b>ScaleGrid Improvement</b></th>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">25</td>
<td style="padding: 10px; border: 1px solid #eee;">3,327</td>
<td style="padding: 10px; border: 1px solid #eee;">826</td>
<td style="padding: 10px; border: 1px solid #eee;">303%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">50</td>
<td style="padding: 10px; border: 1px solid #eee;">5,003</td>
<td style="padding: 10px; border: 1px solid #eee;">1,154</td>
<td style="padding: 10px; border: 1px solid #eee;">334%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">100</td>
<td style="padding: 10px; border: 1px solid #eee;">5,180</td>
<td style="padding: 10px; border: 1px solid #eee;">1,476</td>
<td style="padding: 10px; border: 1px solid #eee;">251%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">150</td>
<td style="padding: 10px; border: 1px solid #eee;">4,310</td>
<td style="padding: 10px; border: 1px solid #eee;">1,651</td>
<td style="padding: 10px; border: 1px solid #eee;">161%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">175</td>
<td style="padding: 10px; border: 1px solid #eee;">4,071</td>
<td style="padding: 10px; border: 1px solid #eee;">1,643</td>
<td style="padding: 10px; border: 1px solid #eee;">148%</td>
</tr>
</tbody>
</table>
<table style="margin-top: 15px;" width="100%">
<tbody>
<tr>
<td style="padding: 15px; background: #def5fe;"><span style="font-size: 18px;">In our write-intensive scenario, we are able to see the largest performance improvement where ScaleGrid achieves <b>up to 4x higher throughput compared to Azure Database</b>. This is especially apparent in our low-thread scenarios, but even at 175 threads ScaleGrid still performs 2.5x better than Azure Database.</span></td>
</tr>
</tbody>
</table>
<p style="text-align: justify;"></p>

<h3 style="padding-top: 15px;"><a id="9"></a>Latency</h3>
<img class="alignnone size-full wp-image-5833" src="https://scalegrid.io/blog/wp-content/uploads/2020/08/mysql-azure-scalegrid-write-intensive-latency.jpg" alt="MySQL - ScaleGrid vs Azure Databases – Write-Intensive Latency Performance Graph" width="100%" height="auto" />

<table width="100%">
<tbody>
<tr>
<th style="width: 36%;"><b>Threads</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #2da964; color: #fff;"><b>ScaleGrid</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #273039; color: #fff;"><b>Azure</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #def5fe;"><b>ScaleGrid Improvement</b></th>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">25</td>
<td style="padding: 10px; border: 1px solid #eee;">76</td>
<td style="padding: 10px; border: 1px solid #eee;">277</td>
<td style="padding: 10px; border: 1px solid #eee;">-73%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">50</td>
<td style="padding: 10px; border: 1px solid #eee;">101</td>
<td style="padding: 10px; border: 1px solid #eee;">383</td>
<td style="padding: 10px; border: 1px solid #eee;">-74%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">100</td>
<td style="padding: 10px; border: 1px solid #eee;">298</td>
<td style="padding: 10px; border: 1px solid #eee;">996</td>
<td style="padding: 10px; border: 1px solid #eee;">-70%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">150</td>
<td style="padding: 10px; border: 1px solid #eee;">760</td>
<td style="padding: 10px; border: 1px solid #eee;">1,740</td>
<td style="padding: 10px; border: 1px solid #eee;">-56%</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;">175</td>
<td style="padding: 10px; border: 1px solid #eee;">1,089</td>
<td style="padding: 10px; border: 1px solid #eee;">2,009</td>
<td style="padding: 10px; border: 1px solid #eee;">-46%</td>
</tr>
</tbody>
</table>
<table style="margin-top: 15px;" width="100%">
<tbody>
<tr>
<td style="padding: 15px; background: #def5fe;"><span style="font-size: 18px;">ScaleGrid outperformed Azure Database again with an average of <b>64% lower latency across all number of threads</b> for write-intensive workloads.</span></td>
</tr>
</tbody>
</table>
<p style="text-align: justify;">As we can see from the above reports, ScaleGrid helps you significantly increase your throughput and decrease your latency against Azure Database deployments for MySQL across read-intensive, write-intensive and balanced workloads scenarios. To learn more about how these two providers compare across features, check out the <a style="color: #2da964;" href="https://scalegrid.io/mysql/hosting-comparison/scalegrid-vs-azure-database.html" target="_blank">ScaleGrid vs. Azure Database MySQL</a> page.</p>

<h2 style="padding-top: 15px;"><a id="10"></a>Benchmark configurations</h2>
<p style="text-align: justify;">Let’s take a look at the configurations we used in the performance benchmark:</p>

<h3 style="padding-top: 15px;">Configuration Comparison</h3>
<p style="text-align: justify;">We designed the configuration using the most comparable plans offered between ScaleGrid and Azure Database. There are only minor differences and the costs are the same for the two providers:</p>

<table width="100%">
<tbody>
<tr>
<th style="width: 36%;"></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #2da964; color: #fff;"><b>ScaleGrid MySQL on Azure</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #273039; color: #fff;"><b>Azure Database for MySQL</b></th>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;"><b>Instance Type</b></td>
<td style="padding: 10px; border: 1px solid #eee;">Dedicated Large: Standard_Ds2_v2 2 cores</td>
<td style="padding: 10px; border: 1px solid #eee;">General Purpose: 2 cores</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;"><b>RAM</b></td>
<td style="padding: 10px; border: 1px solid #eee;">7GB</td>
<td style="padding: 10px; border: 1px solid #eee;">10GB (5GB Memory per vCore)</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;"><b>SSD</b></td>
<td style="padding: 10px; border: 1px solid #eee;">128GB, Premium SSD disk, 500 IOPS</td>
<td style="padding: 10px; border: 1px solid #eee;">167GB, up to 500 IOPS</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;"><b>Deployment Type</b></td>
<td style="padding: 10px; border: 1px solid #eee;">2+1 Quorum with Semisynchronous replication</td>
<td style="padding: 10px; border: 1px solid #eee;">+1 Read Replica Asynchronous replication</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;"><b>Region</b></td>
<td style="padding: 10px; border: 1px solid #eee;">East US</td>
<td style="padding: 10px; border: 1px solid #eee;">East US</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;"><b>Support</b></td>
<td style="padding: 10px; border: 1px solid #eee;">Included</td>
<td style="padding: 10px; border: 1px solid #eee;"><a style="color: #2da964;" href="https://azure.microsoft.com/en-us/support/plans/standard/" target="_blank">Standard plan</a> ($100)</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;"><b>Estimated Monthly Price</b></td>
<td style="padding: 10px; border: 1px solid #eee;"><a style="color: #2da964;" href="https://scalegrid.io/pricing.html?db=POSTGRESQL&amp;cloud=cloud_azure&amp;replica=deployment_pg_2+1&amp;instance=Large#section_pricing_dedicated" target="_blank">$400</a></td>
<td style="padding: 10px; border: 1px solid #eee;"><a style="color: #2da964;" href="https://azure.microsoft.com/en-us/pricing/details/mysql/" target="_blank">$400</a></td>
</tr>
</tbody>
</table>
<h3 style="padding-top: 15px;">Sysbench Configuration</h3>
<table width="100%">
<tbody>
<tr>
<th style="width: 50%; padding: 10px; border: 1px solid #eee; background: #def5fe;"><b>Configuration</b></th>
<th style="width: 50%; padding: 10px; border: 1px solid #eee; background: #def5fe;"><b>Details</b></th>
</tr>
<tr>
<td style="padding: 8px 10px; border: 1px solid #eee;">Tool</td>
<td style="padding: 8px 10px; border: 1px solid #eee;"><a style="color: #2da964;" href="https://github.com/akopytov/sysbench" target="_blank">Sysbench version 1.0.20</a></td>
</tr>
<tr>
<td style="padding: 8px 10px; border: 1px solid #eee;">Host</td>
<td style="padding: 8px 10px; border: 1px solid #eee;">Standard_Ds2_v2
2 cores (2 vcpus, 7GB memory) on East US region</td>
</tr>
<tr>
<td style="padding: 8px 10px; border: 1px solid #eee;"># Tables</td>
<td style="padding: 8px 10px; border: 1px solid #eee;">100</td>
</tr>
<tr>
<td style="padding: 8px 10px; border: 1px solid #eee;"># Rows per table</td>
<td style="padding: 8px 10px; border: 1px solid #eee;">2,000,000</td>
</tr>
<tr>
<td style="padding: 8px 10px; border: 1px solid #eee;">Random numbers distribution</td>
<td style="padding: 8px 10px; border: 1px solid #eee;">Special</td>
</tr>
</tbody>
</table>
<h3 style="padding-top: 15px;">MySQL Server Configuration</h3>
<table width="100%">
<tbody>
<tr>
<th style="width: 36%;"><b>Configuration</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #2da964; color: #fff;"><b>Azure Scalegrid (Dedicated)</b></th>
<th style="width: 18%; padding: 10px; border: 1px solid #eee; background: #273039; color: #fff;"><b>Azure DB for MySQL</b></th>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;"><b>SQL version</b></td>
<td style="padding: 10px; border: 1px solid #eee;">5.7.25</td>
<td style="padding: 10px; border: 1px solid #eee;">5.7.27</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;"><b>innodb_buffer_pool_size</b></td>
<td style="padding: 10px; border: 1px solid #eee;">4G</td>
<td style="padding: 10px; border: 1px solid #eee;">7.5G</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;"><b>innodb_log_file_size</b></td>
<td style="padding: 10px; border: 1px solid #eee;">1G</td>
<td style="padding: 10px; border: 1px solid #eee;">268M</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;"><b>innodb_io_capacity</b></td>
<td style="padding: 10px; border: 1px solid #eee;">500</td>
<td style="padding: 10px; border: 1px solid #eee;">500</td>
</tr>
<tr>
<td style="padding: 10px; border: 1px solid #eee;"><b>innodb_io_capacity_max</b></td>
<td style="padding: 10px; border: 1px solid #eee;">1000</td>
<td style="padding: 10px; border: 1px solid #eee;">1000</td>
</tr>
</tbody>
</table>
<p style="text-align: justify;">Note that at ScaleGrid, you have advanced options to customize your <a style="color: #2da964;" href="https://help.scalegrid.io/docs/mysql-configuration-settings" target="_blank">MySQL configurations</a>. This allows you to customize your deployment to your application needs and optimize for performance. Unfortunately, Azure Database does not allow for customization of some of the parameters, so you are stuck with the default configurations available through their platform.</p>
<p style="text-align: justify;">For example, we were able to customize the InnoDB log file size to 1GB whereas for Azure Database, this cannot be modified and has a default value of 268M. Learn more about the <a style="color: #2da964;" href="https://docs.microsoft.com/en-us/azure/mysql/concepts-limits" target="_blank">limitations in Azure Database for MySQL</a>.</p>
<p style="text-align: justify;">There are many other advantages of using Scalegrid MySQL for Azure, check out the full comparison on our <a style="color: #2da964;" href="https://scalegrid.io/mysql/hosting-comparison/scalegrid-vs-azure-database.html" target="_blank">ScaleGrid vs. Azure Database - MySQL Hosting</a> page.</p>