Amazon Aurora
Amazon Aurora is a relational database service developed and offered by Amazon Web Services beginning in October 2014.[1][2] Aurora is available as part of the Amazon Relational Database Service (RDS).
Developer(s) | Amazon.com |
---|---|
Initial release | October 2014 [1] |
Operating system | Cross-platform |
Available in | English |
Type | relational database SaaS |
License | Proprietary |
Website | aws |
History
Aurora offered MySQL compatible service upon its release. It added PostgreSQL compatibility in October 2017.[3]
It became possible to stop and start Aurora Clusters in September 2018.[4] In August 2018 Amazon began to offer a serverless version.[5]
In 2019 the developers of Aurora won the SIGMOD Systems Award for fundamentally redesigning relational database storage for cloud environments.[6]
Features
Aurora automatically allocates database storage space in 10-gigabyte increments, as needed, up to a maximum of 64 terabytes.[7] 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.[8] It provides fast database cloning.[9]
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.[10]
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".[10] Other independent tests have shown that Aurora performs better than competing technologies on some, but not all, combinations of workload and instance type.
References
- "Amazon Aurora – New Cost-Effective MySQL-Compatible Database Engine for Amazon RDS". Amazon Web Services. November 12, 2014.
- Preimesberger, Chris (2014-11-12). "Amazon Claims New Aurora DB Engine Screams With Speed". eweek.com. Retrieved 2014-11-13.
- "Now Available – Amazon Aurora with PostgreSQL Compatibility". Amazon Web Services. 2017-10-24. Retrieved 2019-04-07.
- "Amazon Aurora Now Supports Stopping and Starting of Database Clusters". Amazon Web Services, Inc. Retrieved 2019-04-07.
- "Aurora Serverless MySQL Generally Available". Amazon Web Services. 2018-08-09. Retrieved 2019-04-07.
- "Awards - SIGMOD/PODS 2019". SIGMOD 2019. Retrieved 9 August 2019.
- "Amazon Aurora FAQs". Retrieved 14 September 2016.
- "Monitoring Amazon Aurora performance metrics". Datadog. Retrieved 15 September 2016.
- "Amazon Aurora Fast Database Cloning". Amazon Web Services. 2017-08-30. Retrieved 2019-04-12.
- "Amazon Aurora Product Details". Retrieved 15 September 2016.
External links
- Amazon Aurora: Design Considerations for High Throughput Cloud-Native Relational Databases - SIGMOD'17 (ACM digital library)
- Amazon Web Services, Inc. (2014-11-12). "Amazon Web Services Announces Amazon Aurora". phx.corporate-ir.net (Press release). Seattle, WA: Amazon.com. Retrieved 2014-11-13.