Amazon_Aurora

Amazon Aurora

Amazon Aurora

Relational database service

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).

Quick Facts Developer(s), Initial release ...

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


Stub icon

This database-related article is a stub. You can help Wikipedia by expanding it.
Share this article:

This article uses material from the Wikipedia article Amazon_Aurora, and is written by contributors. Text is available under a CC BY-SA 4.0 International License; additional terms may apply. Images, videos and audio are available under their respective licenses.