Difference Between AWS RDS MYSQL vs Aurora MySQL
July 3, 2020 / Eternal Team
What is Mysql?
MySQL is an open-source relational database that has wide acceptance in the industry. MySQL has over 20 years of community-backed development and support. Amazon RDS supports MySQL Community Edition versions 5.5, 5.6, 5.7, and 8.0, which means the code, applications and tools you already use today can be used with Amazon RDS.
The MySQL Community Edition includes.
- SQL and NoSQL
- MySQL Document Store
- Transactional Data Dictionary
- Pluggable Storage Engine Architecture
- MySQL Replication
- MySQL Group Replication
- MySQL InnoDB Cluster
- MySQL Router
- MySQL Partitioning
- Stored Procedures
- Performance Schema
- Information Schema
- MySQL Connectors
- MySQL Workbench
What is RDS?
As per AWS “AWS Relational Database Service (RDS) is a managed database platform-as-a-service (PaaS) by AWS that offers customers the option of running one of several database products such as Oracle, PostgreSQL, MySQL, Microsoft SQL Server, or MariaDB without having to worry about OS administration or database administration”. Any of these database products could also be provisioned manually in an Elastic Compute Cloud (EC2) instance, but the RDS platform offers greatly simplified provisioning, administration, and operation for a small cost premium over EC2.
What is AWS Aurora?
- As per AWS “Amazon RDS Aurora, built for the cloud, is a variant on the standard RDS platform. Unlike standard RDS, it supports only a subset of the database engines.” Currently, only MySQL and PostgreSQL are supported in RDS Aurora. Many of our customers struggle to understand the differences between regular RDS and Aurora RDS, so to alleviate that confusion this article was written to shed some light on the key differences between RDS MySQL and RDS Aurora MySQL.
Advantages And Disadvantages
The regular RDS and Aurora RDS offerings for MySQL and PostgreSQL are more similar than they are different. When comparing the two platforms to select the best architecture for a particular application stack, the following should be taken into consideration.
- RDS offers a greater range of database engines and versions than Aurora RDS.
- Aurora RDS offers superior performance to RDS due to the unique storage subsystem.
- Aurora RDS offers superior scalability to RDS due to the unique storage subsystem.
- The pricing models differ slightly between RDS and Aurora RDS, but Aurora RDS is generally a bit more expensive to implement for the same database workload.
- Aurora RDS offers superior high availability to RDS due to the unique storage subsystem.