Amazon Aurora

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

In August 2017, Aurora Fast Cloning (Copy-on-write) feature was added allowing customers to create quick and cost-effective 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[edit]

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 multiple locations for improved availability and fault-tolerance.

Aurora provides users with performance metrics, such as query throughput and latency.[11] It provides fast database cloning.[12]

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

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".[13] 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[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 (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". Retrieved September 15, 2020.
  5. ^ "AWS launches an undo feature for its Aurora database service". TechCrunch. 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. ^ "Monitoring Amazon Aurora performance metrics". Datadog. Retrieved September 15, 2016.
  12. ^ "Amazon Aurora Fast Database Cloning". Amazon Web Services. August 30, 2017. Retrieved April 12, 2019.
  13. ^ a b "Amazon Aurora Product Details". Retrieved September 15, 2016.

External links[edit]