Amazon Aurora

{{Short description|Relational database service}}

{{Use mdy dates|date=October 2020}}

{{Infobox software

| logo =

| name = Amazon Aurora

| developer = Amazon.com

| released = {{Release date and age|2014|10}} {{Cite web|url=https://aws.amazon.com/blogs/aws/highly-scalable-mysql-compat-rds-db-engine/|title=Amazon Aurora – New Cost-Effective MySQL-Compatible Database Engine for Amazon RDS|date=November 12, 2014|website=Amazon Web Services}}

| operating system = Cross-platform

| language = English

| genre = relational database SaaS

| license = Proprietary

| website = {{URL|https://aws.amazon.com/rds/aurora/}}

}}

Amazon Aurora is a proprietary relational database offered as a service by Amazon Web Services (AWS) since October 2014.{{Cite web |url=http://www.eweek.com/cloud/amazon-claims-new-aurora-db-engine-screams-with-speed.html |first=Chris |last=Preimesberger |title=Amazon Claims New Aurora DB Engine Screams With Speed |website=eweek.com |date=2014-11-12 |access-date=2014-11-13}} 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.{{Cite web|url=https://aws.amazon.com/blogs/aws/now-available-amazon-aurora-with-postgresql-compatibility/|title=Now Available – Amazon Aurora with PostgreSQL Compatibility|date=2017-10-24|website=Amazon Web Services|language=en-US|access-date=2019-04-07}}

In August 2017, Aurora Fast Cloning (copy-on-write) feature was added allowing customers to create copies of their databases.{{Cite web|title=Amazon Aurora Fast Database Cloning |date=August 30, 2017|url=https://aws.amazon.com/blogs/aws/amazon-aurora-fast-database-cloning/|access-date=2020-09-15|language=en-US}} In May 2018, Aurora Backtrack was added which allows developers to rewind database clusters without creating a new one.{{Cite web|title=AWS launches an undo feature for its Aurora database service|url=https://techcrunch.com/2018/05/10/aws-launches-an-undo-feature-for-its-aurora-database-service/|access-date=2020-09-11|website=TechCrunch|date=May 10, 2018 |language=en-US}} It became possible to stop and start Aurora Clusters in September 2018.{{Cite web|url=https://aws.amazon.com/about-aws/whats-new/2018/09/amazon-aurora-stop-and-start/|title=Amazon Aurora Now Supports Stopping and Starting of Database Clusters|website=Amazon Web Services, Inc.|language=en-US|access-date=2019-04-07}} In August 2018, Amazon began to offer a serverless version.{{Cite web|url=https://aws.amazon.com/blogs/aws/aurora-serverless-ga/|title=Aurora Serverless MySQL Generally Available|date=2018-08-09|website=Amazon Web Services|language=en-US|access-date=2019-04-07}}{{Cite web|title=When should I use Amazon RDS vs. Aurora Serverless?|url=https://searchcloudcomputing.techtarget.com/answer/When-should-I-use-Amazon-RDS-vs-Aurora-Serverless|access-date=2020-09-11|website=SearchCloudComputing|language=en}}

In 2019 the developers of Aurora won the SIGMOD Systems Award for fundamentally redesigning relational database storage for cloud environments.{{cite web |title=Awards - SIGMOD/PODS 2019 |url=https://sigmod2019.org/awards |website=SIGMOD 2019 |access-date=9 August 2019}}

Features

Aurora automatically allocates database storage space in 10-gigabyte increments, as needed, up to a maximum of 128 terabytes.{{cite web|title=Amazon Aurora Increases Maximum Storage Size to 128TB|url=https://aws.amazon.com/about-aws/whats-new/2020/09/amazon-aurora-increases-maximum-storage-size-128tb/|access-date=28 September 2020}} Aurora offers automatic, six-way replication of those chunks across three availability zones for improved availability and fault-tolerance.{{Cite web|title=Amazon Aurora FAQs {{!}} MySQL PostgreSQL Relational Database {{!}} Amazon Web Services|url=https://aws.amazon.com/rds/aurora/faqs/|access-date=2021-03-09|website=Amazon Web Services, Inc.|language=en-US}}

Aurora provides users with performance metrics, such as query throughput and latency.{{cite web|title=Monitoring Amazon Aurora performance metrics|date=November 19, 2015|url=https://www.datadoghq.com/blog/monitoring-amazon-aurora-performance-metrics/|publisher=Datadog|access-date=15 September 2016}} It provides fast database cloning.{{Cite web|url=https://aws.amazon.com/blogs/aws/amazon-aurora-fast-database-cloning/|title=Amazon Aurora Fast Database Cloning|date=2017-08-30|website=Amazon Web Services|language=en-US|access-date=2019-04-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.{{cite web|title=Amazon Aurora Multi-Master is Now Generally Available|url=https://aws.amazon.com/about-aws/whats-new/2019/08/amazon-aurora-multimaster-now-generally-available/}}

Amazon designed Aurora to be compatible with MySQL, meaning that tools for querying or managing MySQL databases (such as the {{Mono|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.{{cite web|title=Amazon Aurora supports MySQL 8.0|url=https://aws.amazon.com/about-aws/whats-new/2021/11/amazon-aurora-mysql-8-0/|access-date=24 December 2021}} It supports InnoDB as a storage engine.{{cite web|title= Amazon Aurora Product Details |url= https://aws.amazon.com/rds/aurora/faqs/|access-date= 15 September 2016}}

See also

References

{{Reflist}}