Amazon Aurora
Developer(s) | Amazon.com |
---|---|
Initial release | October 2014[1] |
Operating system | Cross-platform |
Available in | English |
Type | relational database SaaS |
License | Proprietary |
Website | aws |
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).
History
Aurora offered MySQL compatible service upon its release in 2014. It added PostgreSQL compatibility in October 2017.[3]
In August 2017, Aurora Fast Cloning (copy-on-write) feature was added allowing customers to create copies of their databases.[4] In May 2018, Aurora Backtrack was added which allows developers to rewind database clusters without creating a new one.[5] It became possible to stop and start Aurora Clusters in September 2018.[6] In August 2018, Amazon began to offer a serverless version.[7][8]
In 2019 the developers of Aurora won the SIGMOD Systems Award for fundamentally redesigning relational database storage for cloud environments.[9]
Features
Aurora automatically allocates database storage space in 10-gigabyte increments, as needed, up to a maximum of 128 terabytes.[10] Aurora offers automatic, six-way replication of those chunks across three availability zones for improved availability and fault-tolerance.[11]
Aurora provides users with performance metrics, such as query throughput and latency.[12] It provides fast database cloning.[13]
Aurora Multi-Master allows creation of multiple read-write instances in an Aurora database across multiple availability zones, which enables uptime-sensitive applications to achieve continuous write availability through instance failure.[14]
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. As of December 2021, Amazon Aurora is compatible with MySQL 5.6, 5.7, and 8.0.[15] It supports InnoDB as a storage engine.[16]
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".[16] Other independent tests have shown that Aurora performs better than competing technologies on some, but not all, combinations of workload and instance type.[citation needed]
See also
References
- ^ a b "Amazon Aurora – New Cost-Effective MySQL-Compatible Database Engine for Amazon RDS". Amazon Web Services. November 12, 2014.
- ^ Preimesberger, Chris (November 12, 2014). "Amazon Claims New Aurora DB Engine Screams With Speed". eweek.com. Retrieved November 13, 2014.
- ^ "Now Available – Amazon Aurora with PostgreSQL Compatibility". Amazon Web Services. October 24, 2017. Retrieved April 7, 2019.
- ^ "Amazon Aurora Fast Database Cloning". August 30, 2017. Retrieved September 15, 2020.
- ^ "AWS launches an undo feature for its Aurora database service". TechCrunch. May 10, 2018. Retrieved September 11, 2020.
- ^ "Amazon Aurora Now Supports Stopping and Starting of Database Clusters". Amazon Web Services, Inc. Retrieved April 7, 2019.
- ^ "Aurora Serverless MySQL Generally Available". Amazon Web Services. August 9, 2018. Retrieved April 7, 2019.
- ^ "When should I use Amazon RDS vs. Aurora Serverless?". SearchCloudComputing. Retrieved September 11, 2020.
- ^ "Awards - SIGMOD/PODS 2019". SIGMOD 2019. Retrieved August 9, 2019.
- ^ "Amazon Aurora Increases Maximum Storage Size to 128TB". Retrieved September 28, 2020.
- ^ "Amazon Aurora FAQs | MySQL PostgreSQL Relational Database | Amazon Web Services". Amazon Web Services, Inc. Retrieved March 9, 2021.
- ^ "Monitoring Amazon Aurora performance metrics". Datadog. November 19, 2015. Retrieved September 15, 2016.
- ^ "Amazon Aurora Fast Database Cloning". Amazon Web Services. August 30, 2017. Retrieved April 12, 2019.
- ^ "Amazon Aurora Multi-Master is Now Generally Available".
- ^ "Amazon Aurora supports MySQL 8.0". Retrieved December 24, 2021.
- ^ a b "Amazon Aurora Product Details". Retrieved September 15, 2016.
External links
- Amazon Aurora: Design Considerations for High Throughput Cloud-Native Relational Databases - SIGMOD'17 (ACM digital library)
- Amazon Web Services, Inc. (November 12, 2014). "Amazon Web Services Announces Amazon Aurora". phx.corporate-ir.net (Press release). Seattle, WA. Retrieved November 13, 2014.