Jump to content

Amazon Aurora

From Wikipedia, the free encyclopedia

This is an old revision of this page, as edited by Peaceray (talk | contribs) at 18:45, 16 October 2023 (Reverting edit(s) by 128.235.250.32 (talk) to rev. 1179883295 by Crosbiesmith: Unexplained content removal (RW 16.1)). The present address (URL) is a permanent link to this revision, which may differ significantly from the current revision.

Amazon Aurora
Developer(s)Amazon.com
Initial releaseOctober 2014; 10 years ago (2014-10) [1]
Operating systemCross-platform
Available inEnglish
Typerelational database SaaS
LicenseProprietary
Websiteaws.amazon.com/rds/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).

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

  1. ^ a b "Amazon Aurora – New Cost-Effective MySQL-Compatible Database Engine for Amazon RDS". Amazon Web Services. November 12, 2014.
  2. ^ Preimesberger, Chris (November 12, 2014). "Amazon Claims New Aurora DB Engine Screams With Speed". eweek.com. Retrieved November 13, 2014.
  3. ^ "Now Available – Amazon Aurora with PostgreSQL Compatibility". Amazon Web Services. October 24, 2017. Retrieved April 7, 2019.
  4. ^ "Amazon Aurora Fast Database Cloning". August 30, 2017. Retrieved September 15, 2020.
  5. ^ "AWS launches an undo feature for its Aurora database service". TechCrunch. May 10, 2018. Retrieved September 11, 2020.
  6. ^ "Amazon Aurora Now Supports Stopping and Starting of Database Clusters". Amazon Web Services, Inc. Retrieved April 7, 2019.
  7. ^ "Aurora Serverless MySQL Generally Available". Amazon Web Services. August 9, 2018. Retrieved April 7, 2019.
  8. ^ "When should I use Amazon RDS vs. Aurora Serverless?". SearchCloudComputing. Retrieved September 11, 2020.
  9. ^ "Awards - SIGMOD/PODS 2019". SIGMOD 2019. Retrieved August 9, 2019.
  10. ^ "Amazon Aurora Increases Maximum Storage Size to 128TB". Retrieved September 28, 2020.
  11. ^ "Amazon Aurora FAQs | MySQL PostgreSQL Relational Database | Amazon Web Services". Amazon Web Services, Inc. Retrieved March 9, 2021.
  12. ^ "Monitoring Amazon Aurora performance metrics". Datadog. November 19, 2015. Retrieved September 15, 2016.
  13. ^ "Amazon Aurora Fast Database Cloning". Amazon Web Services. August 30, 2017. Retrieved April 12, 2019.
  14. ^ "Amazon Aurora Multi-Master is Now Generally Available".
  15. ^ "Amazon Aurora supports MySQL 8.0". Retrieved December 24, 2021.
  16. ^ a b "Amazon Aurora Product Details". Retrieved September 15, 2016.