Software:Amazon Aurora

From HandWiki
Short description: Relational database service
Amazon Aurora
Developer(s)Amazon.com
Initial releaseOctober 2014; 9 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

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.0 1.1 "Amazon Aurora – New Cost-Effective MySQL-Compatible Database Engine for Amazon RDS". November 12, 2014. https://aws.amazon.com/blogs/aws/highly-scalable-mysql-compat-rds-db-engine/. 
  2. ↑ Preimesberger, Chris (2014-11-12). "Amazon Claims New Aurora DB Engine Screams With Speed". http://www.eweek.com/cloud/amazon-claims-new-aurora-db-engine-screams-with-speed.html. 
  3. ↑ "Now Available – Amazon Aurora with PostgreSQL Compatibility" (in en-US). 2017-10-24. https://aws.amazon.com/blogs/aws/now-available-amazon-aurora-with-postgresql-compatibility/. 
  4. ↑ "Amazon Aurora Fast Database Cloning" (in en-US). August 30, 2017. https://aws.amazon.com/blogs/aws/amazon-aurora-fast-database-cloning/. 
  5. ↑ "AWS launches an undo feature for its Aurora database service" (in en-US). May 10, 2018. https://social.techcrunch.com/2018/05/10/aws-launches-an-undo-feature-for-its-aurora-database-service/. 
  6. ↑ "Amazon Aurora Now Supports Stopping and Starting of Database Clusters" (in en-US). https://aws.amazon.com/about-aws/whats-new/2018/09/amazon-aurora-stop-and-start/. 
  7. ↑ "Aurora Serverless MySQL Generally Available" (in en-US). 2018-08-09. https://aws.amazon.com/blogs/aws/aurora-serverless-ga/. 
  8. ↑ "When should I use Amazon RDS vs. Aurora Serverless?" (in en). https://searchcloudcomputing.techtarget.com/answer/When-should-I-use-Amazon-RDS-vs-Aurora-Serverless. 
  9. ↑ "Awards - SIGMOD/PODS 2019". https://sigmod2019.org/awards. 
  10. ↑ "Amazon Aurora Increases Maximum Storage Size to 128TB". https://aws.amazon.com/about-aws/whats-new/2020/09/amazon-aurora-increases-maximum-storage-size-128tb/. 
  11. ↑ "Amazon Aurora FAQs | MySQL PostgreSQL Relational Database | Amazon Web Services" (in en-US). https://aws.amazon.com/rds/aurora/faqs/. 
  12. ↑ "Monitoring Amazon Aurora performance metrics". Datadog. November 19, 2015. https://www.datadoghq.com/blog/monitoring-amazon-aurora-performance-metrics/. 
  13. ↑ "Amazon Aurora Fast Database Cloning" (in en-US). 2017-08-30. https://aws.amazon.com/blogs/aws/amazon-aurora-fast-database-cloning/. 
  14. ↑ "Amazon Aurora Multi-Master is Now Generally Available". https://aws.amazon.com/about-aws/whats-new/2019/08/amazon-aurora-multimaster-now-generally-available/. 
  15. ↑ "Amazon Aurora supports MySQL 8.0". https://aws.amazon.com/about-aws/whats-new/2021/11/amazon-aurora-mysql-8-0/. 
  16. ↑ 16.0 16.1 "Amazon Aurora Product Details". https://aws.amazon.com/rds/aurora/faqs/. 

External links

  • Amazon Aurora: Design Considerations for High Throughput Cloud-Native Relational Databases - SIGMOD'17 (ACM digital library)
  • Amazon Web Services, Inc. (2014-11-12). "Amazon Web Services Announces Amazon Aurora". phx.corporate-ir.net (Press release). Seattle, WA. Retrieved 2014-11-13.





Retrieved from "https://handwiki.org/wiki/index.php?title=Software:Amazon_Aurora&oldid=3467204"