MySQL on Oracle Cloud Workload Brief

AmpereOne® processors are designed from the ground up to deliver exceptional performance for Cloud Native applications. With an innovative architecture that delivers high performance, linear scalability, and stellar energy efficiency, AmpereOne® enables applications like MySQL to run in a predictable manner, with minimal variance under increasing loads.

Oracle Cloud offers the cost-optimized A2 VMs powered by AmpereOne® processors in multiple flexible VM shapes – up to 78 OCPUs (156 cores) per VM, and a wide range of network-attached storage options. These VMs are suitable for scale-out Cloud Native workloads like web servers, in-memory caches, databases, containerized microservices, data-logging, media transcoding, and Big Data applications.

MySQL is a popular open-source Relational Database Management System (RDBMS), which is developed, distributed, and supported by Oracle Corporation. It is used by many modern websites and web-based services as a convenient and fast access storage and retrieval solution for large volumes of data. MySQL Database Server is fast, reliable, scalable, and easy to use. It continues to rank highly in popularity among databases, according to DB-engines.

In this performance brief, we compare MySQL running on Oracle Cloud A2 VMs powered by AmpereOne® processors to AMD EPYC™ Genoa-based E5 VMs.

As can be seen above in Figure 1, the Oracle Cloud A2 flex VMs powered by AmpereOne® processors perform 36% better relative to AMD E5 VMs on MySQL.

Figure 2 shows the price-performance running MySQL. We measured a 2.1x uplift on AmpereOne(R) A2 instances compared to AMD’s E5 instances. The instance pricing is derived from the Oracle Cloud cost estimator tool: https://www.oracle.com/cloud/costestimator.html

MySQL 8.0.36 was used with sysbench as the load generator and testing framework for running the oltp_point_select test. A database size of 1.84 GB on a 64 GB RAMdisk was used and 128 sysbench threads were used. The A2 and E5 systems under test (SUT) were 16 OCPU VMs. Three runs were performed to ensure run-to-run variance was low.

Relational database systems like MySQL are in use in most enterprise and cloud deployments today. Oracle Cloud A2 instances with AmpereOne® processors provide high performance for applications like MySQL. Cloud developers can expect to see a performance advantage up to 36% on the A2 instances compared to legacy x86 VMs like the E5 and a combined price-performance advantage of more than 2x on MySQL.