ⓘ Amazon Aurora

                                     

ⓘ Amazon Aurora

Amazon Aurora is a relational database service developed and offered by Amazon Web Services beginning in October 2014. Aurora is available as part of the Amazon Relational Database Service.

                                     

1. History

Aurora offered MySQL compatible service upon its release. It added PostgreSQL compatibility in October 2017.

It became possible to stop and start Aurora Clusters in September 2018. In August 2018 Amazon began to offer a serverless version.

In 2019 the developers of Aurora won the SIGMOD Systems Award for fundamentally redesigning relational database storage for cloud environments.

                                     

2. Features

Aurora automatically allocates database storage space in 10-gigabyte increments, as needed, up to a maximum of 64 terabytes. Aurora offers automatic, six-way replication of those chunks across multiple locations for improved availability and fault-tolerance.

Aurora provides users with performance metrics, such as query throughput and latency. It provides fast database cloning.

                                     

2.1. Features MySQL compatibility

Amazon designed Aurora to be compatible with MySQL, meaning that tools for querying or managing MySQL databases such as the mysql command-line client and the MySQL Workbench graphical user-interface can be used. Not all MySQL options and features are available: as of September 2016, Amazon Aurora is compatible with MySQL 5.6 and 5.7. It supports InnoDB as a storage engine.

                                     

2.2. Features Performance

Amazon claims fivefold performance improvements on benchmarking tests over MySQL on the same hardware, due to "tightly integrating the database engine with an SSD-based virtualized storage layer purpose-built for database workloads, reducing writes to the storage system, minimizing lock contention and eliminating delays created by database process threads". Other independent tests have shown that Aurora performs better than competing technologies on some, but not all, combinations of workload and instance type.