Amazon Aurora

From Wikipedia, the free encyclopedia
Jump to navigation Jump to search
Amazon Aurora
Developer(s)Amazon.com
Initial releaseOctober 2014; 4 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[edit]

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[edit]

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[edit]

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[edit]

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.[11]

See also[edit]

References[edit]

  1. ^ a b "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. ^ a b "Amazon Aurora Product Details". Retrieved 15 September 2016.
  11. ^ Tusa, Marco. "AWS Aurora Benchmarking part 2". Percona. Retrieved 15 September 2016.

External links[edit]