Amazon Aurora

Last updated

Amazon Aurora
Developer(s) Amazon.com
Initial releaseOctober 2014;9 years ago (2014-10) [1]
Operating system Cross-platform
Available inEnglish
Type relational database SaaS
License Proprietary
Website aws.amazon.com/rds/aurora/

Amazon Aurora is a proprietary relational database offered as a service by Amazon Web Services (AWS) since October 2014. [1] [2] Aurora is available as part of the Amazon Relational Database Service (RDS).

Contents

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]

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]

See also

Related Research Articles

<span class="mw-page-title-main">MySQL</span> SQL database engine software

MySQL is an open-source relational database management system (RDBMS). Its name is a combination of "My", the name of co-founder Michael Widenius's daughter My, and "SQL", the acronym for Structured Query Language. A relational database organizes data into one or more data tables in which data may be related to each other; these relations help structure the data. SQL is a language that programmers use to create, modify and extract data from the relational database, as well as control user access to the database. In addition to relational databases and SQL, an RDBMS like MySQL works with an operating system to implement a relational database in a computer's storage system, manages users, allows for network access and facilitates testing database integrity and creation of backups.

<span class="mw-page-title-main">PostgreSQL</span> Free and open-source object relational database management system

PostgreSQL, also known as Postgres, is a free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transactions with atomicity, consistency, isolation, durability (ACID) properties, automatically updatable views, materialized views, triggers, foreign keys, and stored procedures. It is supported on all major operating systems, including Linux, FreeBSD, OpenBSD, macOS, and Windows, and handles a range of workloads from single machines to data warehouses or web services with many concurrent users.

Multi-master replication is a method of database replication which allows data to be stored by a group of computers, and updated by any member of the group. All members are responsive to client data queries. The multi-master replication system is responsible for propagating the data modifications made by each member to the rest of the group and resolving any conflicts that might arise between concurrent changes made by different members.

<span class="mw-page-title-main">LAMP (software bundle)</span> Acronym for a common web hosting solution

LAMP is an acronym denoting one of the most common software stacks for the web's most popular applications. Its generic software stack model has largely interchangeable components.

In database computing, Oracle Real Application Clusters (RAC) — an option for the Oracle Database software produced by Oracle Corporation and introduced in 2001 with Oracle9i — provides software for clustering and high availability in Oracle database environments. Oracle Corporation includes RAC with the Enterprise Edition, provided the nodes are clustered using Oracle Clusterware.

<span class="mw-page-title-main">EnterpriseDB</span> American software company

EnterpriseDB (EDB), a privately held company based in Massachusetts, provides software and services based on the open-source database PostgreSQL, and is one of the largest contributors to Postgres. EDB develops and integrates performance, security, and manageability enhancements into Postgres to support enterprise-class workloads. EDB has also developed database compatibility for Oracle to facilitate the migration of workloads from Oracle to EDB Postgres and to support the operation of many Oracle workloads on EDB Postgres.

<span class="mw-page-title-main">Navicat</span> SQL database management software

Navicat is a series of graphical database management and development software produced by CyberTech Ltd. for MySQL, MariaDB, Redis, MongoDB, Oracle, SQLite, PostgreSQL and Microsoft SQL Server. It has an Explorer-like graphical user interface and supports multiple database connections for local and remote databases. Its design is made to meet the needs of a variety of audiences, from database administrators and programmers to various businesses/companies that serve clients and share information with partners.

<span class="mw-page-title-main">Amazon Elastic Block Store</span> Cloud-based raw storage service

Amazon Elastic Block Store (EBS) provides raw block-level storage that can be attached to Amazon EC2 instances and is used by Amazon Relational Database Service (RDS). It is one of the two block-storage options offered by AWS, with the other being the EC2 Instance Store.

Amazon Relational Database Service is a distributed relational database service by Amazon Web Services (AWS). It is a web service running "in the cloud" designed to simplify the setup, operation, and scaling of a relational database for use in applications. Administration processes like patching the database software, backing up databases and enabling point-in-time recovery are managed automatically. Scaling storage and compute resources can be performed by a single API call to the AWS control plane on-demand. AWS does not offer an SSH connection to the underlying virtual machine as part of the managed service.

A cloud database is a database that typically runs on a cloud computing platform and access to the database is provided as-a-service. There are two common deployment models: users can run databases on the cloud independently, using a virtual machine image, or they can purchase access to a database service, maintained by a cloud database provider. Of the databases available on the cloud, some are SQL-based and some use a NoSQL data model.

<span class="mw-page-title-main">Amazon DynamoDB</span> NoSQL database service

Amazon DynamoDB is a fully managed proprietary NoSQL database offered by Amazon.com as part of the Amazon Web Services portfolio. DynamoDB offers a fast persistent key–value datastore with built-in support for replication, autoscaling, encryption at rest, and on-demand backup among other features.

<span class="mw-page-title-main">Basho Technologies</span>

Basho Technologies was a distributed systems' company that developed a key-value NoSQL database technology, Riak, and an object storage system built upon the Riak platform, called Riak CS.

Amazon Redshift is a data warehouse product which forms part of the larger cloud-computing platform Amazon Web Services. It is built on top of technology from the massive parallel processing (MPP) data warehouse company ParAccel, to handle large scale data sets and database migrations. Redshift differs from Amazon's other hosted database offering, Amazon RDS, in its ability to handle analytic workloads on big data data sets stored by a column-oriented DBMS principle. Redshift allows up to 16 petabytes of data on a cluster compared to Amazon RDS Aurora's maximum size of 128 tebibytes.

Google Cloud Platform (GCP), offered by Google, is a suite of cloud computing services that provides a series of modular cloud services including computing, data storage, data analytics, and machine learning, alongside a set of management tools. It runs on the same infrastructure that Google uses internally for its end-user products, such as Google Search, Gmail, and Google Docs, according to Verma, et.al. Registration requires a credit card or bank account details.

Presto is a distributed query engine for big data using the SQL query language. Its architecture allows users to query data sources such as Hadoop, Cassandra, Kafka, AWS S3, Alluxio, MySQL, MongoDB and Teradata, and allows use of multiple data sources within a query. Presto is community-driven open-source software released under the Apache License.

This is a timeline of Amazon Web Services, which offers a suite of cloud computing services that make up an on-demand computing platform.

Serverless computing is a cloud computing execution model in which the cloud provider allocates machine resources on demand, taking care of the servers on behalf of their customers. "Serverless" is a misnomer in the sense that servers are still used by cloud service providers to execute code for developers. However, developers of serverless applications are not concerned with capacity planning, configuration, management, maintenance, fault tolerance, or scaling of containers, VMs, or physical servers. Serverless computing does not hold resources in volatile memory; computing is rather done in short bursts with the results persisted to storage. When an app is not in use, there are no computing resources allocated to the app. Pricing is based on the actual amount of resources consumed by an application. It can be a form of utility computing.

Amazon DocumentDB is a managed proprietary NoSQL database service that supports document data structures, with some compatibility with MongoDB version 3.6 and version 4.0. As a document database, Amazon DocumentDB can store, query, and index JSON data. It is available on Amazon Web Services. As of March 2023, AWS introduced some compliance with MongoDB 5.0 but lacks time series collection support.

<span class="mw-page-title-main">YugabyteDB</span> Transactional distributed SQL database

YugabyteDB is a high-performance transactional distributed SQL database for cloud-native applications, developed by Yugabyte.

HammerDB is an open source database benchmarking application developed by Steve Shaw. HammerDB supports databases such as Oracle, SQL Server, Db2, MySQL and MariaDB. HammerDB is written in TCL and C, and is licensed under the GPL v3.

References

  1. 1 2 "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". August 30, 2017. Retrieved September 15, 2020.
  5. ↑ "AWS launches an undo feature for its Aurora database service". TechCrunch. May 10, 2018. 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. ↑ "Amazon Aurora FAQs | MySQL PostgreSQL Relational Database | Amazon Web Services". Amazon Web Services, Inc. Retrieved March 9, 2021.
  12. ↑ "Monitoring Amazon Aurora performance metrics". Datadog. November 19, 2015. Retrieved September 15, 2016.
  13. ↑ "Amazon Aurora Fast Database Cloning". Amazon Web Services. August 30, 2017. Retrieved April 12, 2019.
  14. ↑ "Amazon Aurora Multi-Master is Now Generally Available".
  15. ↑ "Amazon Aurora supports MySQL 8.0" . Retrieved December 24, 2021.
  16. ↑ "Amazon Aurora Product Details" . Retrieved September 15, 2016.


This page is based on this Wikipedia article
Text is available under the CC BY-SA 4.0 license; additional terms may apply.
Images, videos and audio are available under their respective licenses.