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]

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

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]

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

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

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".[14] Other independent tests have shown that Aurora performs better than competing technologies on some, but not all, combinations of workload and instance type.

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 (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. "Amazon Aurora Multi-Master is Now Generally Available".
  14. "Amazon Aurora Product Details". Retrieved September 15, 2016.


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