Amazon Aurora database was announced in November 2014[1]. It is now a fully-managed, with both MySQL-compatible (in production July 2015) [5] and PostgreSQL-compatible (in production Oct 2017) , relational database engine hosted on Amazon RDS. This blog is a short analysis of this new cloud-based relational database.
In summary, Aurora databases are:
In summary, Aurora databases are:
- Compatible with MySQL 5.6 using the InnoDB storage engine
- Has 99.99% availability with automatically recovery from an instance and storage failures, and creating up to 15 read-only replicas.
- Has a cloud-managed scalability with from 10GB to 64TB storage size and up to 15 replicas.
- Has cloud-enabled backup and patching management
- Tuned performance: performance targets of up to 100K writes per second and 600K reads per second.[4]
- Managed high availability
- Managed backup and patching
- Scaling of the storage
- Low cost: the calculation by Patrick[9] gives a good insight on the cost estimation, which is around $60K/month for the high throughput use.
- Missing critical OLTP features, including scalable read-write clusters, parallel SQL and the ability to replicate encrypted databases.
- Only run on AWS platform
Resources
- Amazon, Amazon Aurora – New Cost-Effective MySQL-Compatible Database Engine for Amazon RDS, Nov 2, 2014
- Debanjan Saha, Amazon Aurora: An under-the-hood view of a cloud-scale relational database service, September, 2015 (Video)
- Steve Abraham, Introducing the Aurora Storage Engine, December 12, 2016
- Debanjan Saha,AWS re:Invent 2016: Amazon Aurora Deep Dive (GPST402) (YouTube), December 19, 2016
- Gartner, Amazon Aurora Disrupts DBMS Market With Cloud-Native Offering, August 3, 2015
- Oracle, Oracle Beats Amazon Web Services in Head-to-Head Cloud Database Comparison, September 20,2016.
- Amazon Documenation, Aurora on Amazon RDS
- Amazon Documenation, Replication Between Aurora and MySQL or Between Aurora and Another Aurora DB Cluster
- Patrick McClory, Estimating AWS Aurora Cost, July 29, 2015
- Yoav Mor, How Much Does It Cost to Run Relational Database (RDS) on AWS, Aug 20, 2015
Created 1/2/2017, Last Updated: 12/12/2017