Ampere Computing Logo
Contact Sales
Ampere Computing Logo
Hero Image

MySQL on Oracle Cloud Workload Brief

A2 Instances Powered by AmpereOne Processors

Overview

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.

RESULTS AND KEY FINDINGS

graphs1-2-mysql.png


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

TEST METHODOLOGY

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.

KEY FINDINGS AND CONCLUSIONS

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.


FOOTNOTES
All data and information contained herein is for informational purposes only and Ampere reserves the right to change it without notice. This document may contain technical inaccuracies, omissions and typographical errors, and Ampere is under no obligation to update or correct this information. Ampere makes no representations or warranties of any kind, including express or implied guarantees of noninfringement, merchantability, or fitness for a particular purpose, and assumes no liability of any kind. All information is provided “AS IS.” This document is not an offer or a binding commitment by Ampere.

System configurations, components, software versions, and testing environments that differ from those used in Ampere’s tests may result in different measurements than those obtained by Ampere.

©2024 Ampere Computing LLC. All Rights Reserved. Ampere, Ampere Computing, AmpereOne and the Ampere logo are all registered trademarks or trademarks of Ampere Computing LLC or its affiliates. All other product names used in this publication are for identification purposes only and may be trademarks of their respective companies.

Created At : June 24th 2024, 6:45:37 pm
Last Updated At : August 5th 2024, 2:56:08 pm
Ampere Logo

Ampere Computing LLC

4655 Great America Parkway Suite 601

Santa Clara, CA 95054

image
image
image
image
image
 |  |  |  | 
© 2024 Ampere Computing LLC. All rights reserved. Ampere, Altra and the A and Ampere logos are registered trademarks or trademarks of Ampere Computing.
This site is running on Ampere Altra Processors.