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

Amazon Aurora
Developer(s)Amazon.com
Initial releaseOctober 2014 (2014-10) [1]
Operating systemCross-platform
Available inEnglish
Typerelational database SaaS
LicenseProprietary
Websiteaws.amazon.com/rds/aurora/

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.

gollark: Added to your gaming profile.
gollark: You're actually doing things? Wow.
gollark: ++magic py "<:bismuth" ":793803997130522634>"
gollark: It is here!
gollark: ++help

See also

References

  1. "Amazon Aurora – New Cost-Effective MySQL-Compatible Database Engine for Amazon RDS". Amazon Web Services. November 12, 2014.
  2. Preimesberger, Chris (2014-11-12). "Amazon Claims New Aurora DB Engine Screams With Speed". eweek.com. Retrieved 2014-11-13.
  3. "Now Available – Amazon Aurora with PostgreSQL Compatibility". Amazon Web Services. 2017-10-24. Retrieved 2019-04-07.
  4. "Amazon Aurora Now Supports Stopping and Starting of Database Clusters". Amazon Web Services, Inc. Retrieved 2019-04-07.
  5. "Aurora Serverless MySQL Generally Available". Amazon Web Services. 2018-08-09. Retrieved 2019-04-07.
  6. "Awards - SIGMOD/PODS 2019". SIGMOD 2019. Retrieved 9 August 2019.
  7. "Amazon Aurora FAQs". Retrieved 14 September 2016.
  8. "Monitoring Amazon Aurora performance metrics". Datadog. Retrieved 15 September 2016.
  9. "Amazon Aurora Fast Database Cloning". Amazon Web Services. 2017-08-30. Retrieved 2019-04-12.
  10. "Amazon Aurora Product Details". Retrieved 15 September 2016.


This article is issued from Wikipedia. The text is licensed under Creative Commons - Attribution - Sharealike. Additional terms may apply for the media files.