Amazon Aurora is a proprietary

relational database A relational database (RDB) is a database based on the relational model of data, as proposed by E. F. Codd in 1970. A Relational Database Management System (RDBMS) is a type of database management system that stores data in a structured for ...

offered as a service by

Amazon Web Services Amazon Web Services, Inc. (AWS) is a subsidiary of Amazon.com, Amazon that provides Software as a service, on-demand cloud computing computing platform, platforms and Application programming interface, APIs to individuals, companies, and gover ...

(AWS) since October 2014. Aurora is available as part of the Amazon Relational Database Service (RDS).

History

Aurora offered

MySQL MySQL () is an Open-source software, 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 rel ...

compatible service upon its release in 2014. It added

PostgreSQL PostgreSQL ( ) also known as Postgres, is a free and open-source software, free and open-source relational database management system (RDBMS) emphasizing extensibility and SQL compliance. PostgreSQL features transaction processing, transactions ...

compatibility in October 2017. In August 2017, Aurora Fast Cloning (

copy-on-write Copy-on-write (COW), also called implicit sharing or shadowing, is a resource-management technique used in programming to manage shared data efficiently. Instead of copying data right away when multiple programs use it, the same data is shared ...

) feature was added allowing customers to create copies of their databases. In May 2018, Aurora Backtrack was added which allows developers to rewind database clusters without creating a new one. It became possible to stop and start Aurora Clusters in September 2018. In August 2018, Amazon began to offer a serverless version. In 2019 the developers of Aurora won the SIGMOD Systems Award for fundamentally redesigning relational database storage for cloud environments.

Features

Aurora automatically allocates database storage space in 10-gigabyte increments, as needed, up to a maximum of 128

terabyte The byte is a unit of digital information that most commonly consists of eight bits. Historically, the byte was the number of bits used to encode a single character of text in a computer and for this reason it is the smallest addressable un ...

s. Aurora offers automatic, six-way replication of those chunks across three availability zones for improved availability and

fault-tolerance Fault tolerance is the ability of a system to maintain proper operation despite failures or faults in one or more of its components. This capability is essential for high-availability, mission critical, mission-critical, or even life-critical sys ...

. Aurora provides users with performance metrics, such as query throughput and latency. It provides fast database cloning. 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. Amazon designed Aurora to be compatible with MySQL, meaning that tools for querying or managing MySQL databases (such as the 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. It supports InnoDB as a storage engine.

References

External links

Amazon Aurora: Design Considerations for High Throughput Cloud-Native Relational Databases
- SIGMOD'17 ( ACM digital library) * 2014 software Amazon Web Services Cloud databases {{Database-stub

History

Features

See also

References

External links