Crypto Discover
cloud Strategy

How to Improve MySQL AWS Performance 2X Over Amazon RDS at The Same Cost




AWS is the #1 cloud provider for open-source database hosting, and the go-to cloud for MySQL deployments. As organizations continue to migrate to the cloud, it’s important to get in front of performance issues, such as high latency, low throughput, and replication lag with higher distances between your users and cloud infrastructure. While many AWS users default to their managed database solution, Amazon RDS, there are alternatives available that can improve your MySQL performance on AWS through advanced customization options and unlimited EC2 instance type support. ScaleGrid offers a compelling alternative to hosting MySQL on AWS that offers better performance, more control, and no cloud vendor lock-in and the same price as Amazon RDS. In this post, we compare the performance of MySQL Amazon RDS vs. MySQL Hosting at ScaleGrid on AWS High-Performance instances.

TLDR

ScaleGrid’s MySQL on AWS High-Performance deployment can provide 2x-3x the throughput at half the latency of Amazon RDS for MySQL with their added advantage of having 2 read replicas as compared to 1 in RDS.

MySQL on AWS Performance Test

 
ScaleGrid
Amazon RDS

Instance Type
AWS High-Performance XLarge (see system details below)
DB Instance r4.xlarge
(Multi-AZ)

Deployment Type
3 Node Master-Slave Set with Semisynchronous Replication
Multi-AZ Deployment with 1 Read Replica

SSD Disk
Local SSD & General Purpose – …

Read More on Datafloq



Source link

Related posts

Azure Integration Opens Blockchain Firm Kaleido to 80% of Cloud Market

cryptodiscover

How to Choose the Right Data Storage System for Team Work

cryptodiscover

The Fuzzy Line Between Good and Evil Data Science

cryptodiscover

Leave a Comment