Amazon Aurora
Cloud service · AWS · Updated

Amazon Aurora

In short

Amazon Aurora is a fully managed relational database service by Amazon Web Services (AWS) that is designed to be compatible with MySQL and PostgreSQL while offering the performance and availability of commercial databases with improved scalability, durability, and security.

Cloud Services Hub →

Free Amazon Aurora tools

8 key features of Amazon Aurora

Amazon Aurora is a highly scalable, durable, and secure fully managed relational database with MySQL and PostgreSQL compatibility, offering superior performance, automated backups, easy monitoring, and recovery features.

01
High Performance and Scalability

Amazon Aurora offers six times the throughput of PostgreSQL and MySQL and automatically scales to workload demand. It is designed for up to 99.99% single-Region and 99.999% multi-Region availability.

02
Fully Managed

As a fully managed service, Aurora handles time-consuming tasks such as provisioning, patching, backup, recovery, failure detection, and repair. You also benefit from the integration with AWS services such as AWS Lambda and Amazon RDS.

03
Compatibility with MySQL and PostgreSQL

Amazon Aurora is fully compatible with existing MySQL and PostgreSQL open source databases, making it easy for database developers to transition applications without having to re-engineer their entire database.

04
Security

Aurora includes multiple layers of security, including network isolation using Amazon VPC, encryption at rest using keys you create and control through AWS Key Management Service (KMS), and encryption of data in transit using SSL. You also have the option to use IAM to define who can access the RDS databases.

05
Durability and Availability

Aurora is designed for up to 99.99% single-Region and 99.999% multi-Region availability. It also provides fault-tolerant distributed storage to ensure continuous data access and durability.

06
Automated Backups, Database Snapshots, and Point-in-Time Recovery

Continuous backups to Amazon S3 and automated snapshots enable point-in-time recovery. You can also easily create database snapshots, which allow you to quickly replicate databases across regions or accounts.

07
Monitoring and Management

Aurora provides an advanced monitoring system allowing you to track over 70 metrics through the AWS Management Console. Enhanced RDS monitoring provides visibility into your databases' performance and allows you to set alarms and automate actions based on specific conditions.

08
Migration from RDS MySQL and PostgreSQL

Bring data from RDS for MySQL or RDS for PostgreSQL into Aurora by creating and restoring snapshots or by setting up one-way replication.

Where Amazon Aurora is used

Amazon Aurora is employed for hosting web and SaaS applications, analytics, e-commerce systems, gaming databases, legacy database migrations, and disaster recovery, highlighting its high performance, scalability, and availability.

  1. 01
    Web Applications Hosting

    Amazon Aurora serves as a scalable and reliable database engine for web applications, handling multiple concurrent user requests and large amounts of data with ease, while maintaining high performance and availability.

  2. 02
    Enterprise SaaS Applications

    Designed for software-as-a-service (SaaS) providers, Amazon Aurora allows for multi-tenancy architecture support while offering each tenant isolated, secure, and compliant data environments, crucial for enterprise-level SaaS solutions.

  3. 03
    High-Throughput Analytics

    Amazon Aurora is optimized for scenarios requiring complex queries and high-throughput analytics, with features like parallel query processing, which significantly speed up data analysis tasks.

  4. 04
    E-commerce Systems

    E-commerce platforms leverage Aurora for its high transactional throughput, automatic scaling, and data durability, ensuring that spikes in shopping traffic do not compromise database performance or data integrity.

  5. 05
    Gaming Databases

    Gaming platforms utilize Aurora to manage user data, support real-time leaderboards, and ensure high availability and fast access during peak gaming times, thereby enhancing player experience and engagement.

  6. 06
    Migration of Legacy Databases

    Aurora provides a seamless migration path for legacy databases, allowing businesses to move away from traditional, costly database solutions to a more cost-effective, managed database service without sacrificing features or performance.

  7. 07
    Disaster Recovery

    By utilizing Aurora's cross-region replication and automated backups, organizations can implement robust disaster recovery plans, ensuring that data remains safe and accessible even after system outages or regional disruptions.

How Amazon Aurora is priced

Amazon Aurora offers pricing models including On-Demand Instances, Reserved Instances, Aurora Serverless with pay-per-use, and charges for additional storage and I/O usage.

On-Demand Instances

Amazon Aurora on-demand instances charge by the hour with no long-term commitments or upfront fees. You pay for the compute capacity by the hour your instance is running.

Reserved Instances

Reserved Instances offer discounts of up to 45% for a one-year term and up to 66% for a three-year term compared with On-Demand Instances.

Aurora Serverless

Aurora Serverless pricing is based on the actual amount of resources consumed by your database, offering a variable pricing model that scales with your workloads automatically.

Additional Storage and I/O Costs

Storage is billed per GB-month. Aurora Standard additionally charges for read and write I/O in increments of one million requests; Aurora I/O-Optimized has no read or write I/O operation charges.

Database Savings Plans

Eligible Aurora usage can receive savings in exchange for a commitment to a specified amount of usage, measured in dollars per hour, over a one-year term.

Aurora DSQL

Aurora DSQL uses a separate serverless pricing model described on the Aurora DSQL pricing page.

Aurora PostgreSQL Limitless Database

Limitless Database compute capacity is measured in Aurora Capacity Units (ACUs) and billed per second; one ACU includes approximately 2 GiB of memory with corresponding CPU and networking.

CPU Credits

T4g and T3 instances run in Unlimited mode and incur CPU-credit charges when average CPU utilization over a rolling 24-hour period exceeds the instance baseline. Credits cost $0.09 per vCPU-hour across instance sizes and Regions for both cluster configurations and are not covered by Reserved Instances.

Aurora Global Database

Global Database charges for replicated write I/O between the primary Region and each secondary Region under both Aurora Standard and Aurora I/O-Optimized configurations.

Backtrack

Backtrack charges an hourly rate for storing change records retained for the configured backtrack duration.

Backup Storage

Backup storage up to 100% of the database cluster size and snapshots created within the backup retention period are free. Other backups and snapshots, including those from deleted clusters, are metered per GB-month.

Data API

Data API charges for API and data requests without minimum fees or upfront commitments. Request payloads are metered in 32 KB increments, with an additional billable request for each increment.

Data Transfer

Aurora data transfer with EC2 in the same Availability Zone and cross-AZ DB cluster replication are free. Transfers between EC2 and Aurora instances in different Availability Zones of the same Region incur EC2 Regional Data Transfer charges.

RDS Extended Support

RDS Extended Support is charged per vCPU-hour for provisioned Aurora instances and per consumed ACU-hour for Aurora serverless. Rates depend on AWS Region and calendar date.

Snapshot and Cluster Export

Snapshot and cluster exports are metered per gigabyte of snapshot data. Exporting only part of a cluster still incurs charges for the entire cluster, and repeated exports from the same snapshot are not incremental.

Zero-ETL Integrations

Zero-ETL integrations have no additional integration fee, but resources used to create and process their change data can incur charges.

AWS Free Tier

New AWS customers receive $100 in credits at sign-up and can earn another $100, usable across eligible services including Aurora for up to 12 months. The Free plan supports Aurora PostgreSQL serverless instances with up to 4 ACUs and 1 GiB of storage per cluster.

On-Demand Capacity Reservations

Reserve DB instance capacity in a specific Availability Zone for as long as needed. Reserved capacity is charged at the On-Demand rate whether used or unused; when used, you pay for the instance without a separate reservation charge. There are no upfront or additional charges.

Services Amazon Aurora works with

Amazon RDSAmazon RDS

Amazon Aurora is a fully managed relational database engine, built within the Amazon RDS ecosystem, and provides MySQL and PostgreSQL compatible database engines.

AWS LambdaAWS Lambda

You can use AWS Lambda to trigger functions in response to events in Amazon Aurora, allowing for serverless computing within your database environment.

Amazon S3Amazon S3

Amazon Aurora integrates with Amazon S3 for importing and exporting data, allowing for easy data migration and backups.

Amazon CloudWatchAmazon CloudWatch

Integration with Amazon CloudWatch allows you to monitor Amazon Aurora database instances for performance and operational health.

AWS CloudFormationAWS CloudFormation

You can use AWS CloudFormation to deploy and manage Amazon Aurora databases as part of infrastructure as code.

Amazon AthenaAmazon Athena

Aurora databases can be queried from Athena through federated query connectors for MySQL and PostgreSQL. This lets you join Aurora records with data in Amazon S3 without first copying the database into a data lake.

Amazon Aurora ServerlessAmazon Aurora Serverless

Aurora supports serverless database capacity that adjusts to application demand. Aurora Serverless v2 can provide automatically scaling writer and reader instances within an Aurora cluster.

Amazon Bedrock

Aurora PostgreSQL can store embeddings and source metadata for Amazon Bedrock Knowledge Bases using the pgvector extension. Bedrock retrieves relevant records from Aurora to ground generated answers in your documents.

Amazon ComprehendAmazon Comprehend

Aurora machine learning lets SQL queries call Amazon Comprehend for natural-language analysis. For example, a query can classify the sentiment of customer feedback stored in an Aurora table.

Amazon Data FirehoseAmazon Data Firehose

Aurora can serve as a database source for Amazon Data Firehose, which captures database changes and delivers them to configured destinations. This supports continuously moving transactional data into analytics storage without maintaining a custom ingestion application.

Amazon Aurora exam questions

Real practice exam questions on Amazon Aurora, with the correct answer and its explanation. Answer them with every option in the exam simulator.

AIF-C01

A company is building a generative AI assistant that retrieves relevant product documentation before answering customer questions. The application uses PostgreSQL drivers and SQL joins to combine documentation with product and customer records. The company wants to store document embeddings alongside these relational records in one managed database and retrieve documents by semantic similarity without rewriting the existing PostgreSQL queries. Which solution best meets these requirements?

Show answerCORRECT ANSWER

Use Amazon Aurora PostgreSQL-Compatible Edition with the pgvector extension to store embeddings and perform vector similarity searches alongside relational queries.

Aurora PostgreSQL supports the pgvector extension for storing and searching embeddings. It can keep embeddings and relational records in the same managed database while supporting PostgreSQL drivers and SQL joins.

MLA-C02 (beta)

A distributor is building a generative AI assistant for sales analysts. Its source data consists of millions of relational records for orders, order items, products, and refunds. Analysts ask questions such as, "What was net revenue for industrial pumps in the western region last quarter, after subtracting refunds?"

The assistant must calculate exact results across all qualifying records, support different combinations of product, region, and date filters, and explain the results using retrieved evidence. The company wants to avoid maintaining a separate search index or precomputing summaries for every possible filter combination.

Which retrieval architecture BEST meets these requirements?

Show answerCORRECT ANSWER

Store the records in Amazon Aurora PostgreSQL-Compatible Edition. Map each question to a validated, parameterized, read-only SQL query that joins and aggregates the required tables. Supply the query results and calculation metadata to the foundation model as grounding context.

Structured-data RAG can retrieve evidence through SQL rather than vector search. Aurora can perform joins, filtering, and exact aggregation across all qualifying records. Validated query templates and parameters constrain database access, while the returned totals, filters, and calculation definitions ground the generated explanation.

SAP-C03

A manufacturer built a production-planning prototype in Amazon Redshift to analyze completed factory jobs. The historical analysis has since moved to a separate platform. The remaining database will support an interactive application used by thousands of factory operators.

Each application request retrieves a few job records by identifier or atomically updates a job assignment, a machine reservation, and a material balance. Requests must complete within 100 milliseconds at the expected peak load. The application also executes SQL joins across current jobs, machines, and materials. Its existing relational schema and SQL transaction logic must be retained.

Load tests show that large historical scans are no longer significant, but frequent small updates and concurrent point lookups do not meet the latency requirement. The company wants a managed database architecture suited to this new workload, without application-managed sharding.

Which solution should a solutions architect recommend?

Show answerCORRECT ANSWER

Migrate the operational tables to Amazon Aurora PostgreSQL-Compatible Edition. Adapt engine-specific SQL as needed while retaining the relational schema and transaction logic, index the application's lookup and join columns, and execute the short transactions on the writer.

The remaining workload is OLTP: concurrent indexed lookups and small, atomic updates across related records. Aurora provides a managed relational engine suited to these operations and preserves relational joins and multi-table transactions. Appropriate indexes and writer sizing should be validated against the latency target. A separate analytical copy is unnecessary because historical analysis has already moved elsewhere.

Practice Amazon Aurora in a full exam

Questions on Amazon Aurora in each practice exam, with every answer option and an explanation for each:

Start a free practice exam

What is Amazon Aurora

4 min read

Amazon Aurora is a fully managed relational database engine that combines the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases.

Introduced by Amazon Web Services (AWS) in 2014, Aurora has quickly become one of the popular choices for companies looking to deploy databases in the cloud. At its core, Aurora is designed to be compatible with MySQL and PostgreSQL, which allows developers to use the same code, drivers, and tools that they are already familiar with. However, under the hood, Amazon has heavily optimized Aurora for the cloud, providing performance improvements while ensuring strong durability and reliability. 

Aurora also offers Aurora DSQL, a serverless, distributed SQL database with PostgreSQL compatibility and active-active multi-Region availability.

One of the critical innovations of Amazon Aurora is its distributed, fault-tolerant, self-healing storage system, which automatically replicates data across multiple Availability Zones (AZs). Each Aurora database volume is backed by a fleet of storage instances that AWS manages across three AZs to ensure high availability and durability. The system is designed to handle the loss of up to two copies of data without affecting database write availability and up to three copies without affecting read availability. 

Aurora PostgreSQL and Aurora MySQL offer Aurora Standard and Aurora I/O-Optimized cluster configurations. I/O-Optimized is intended for I/O-intensive applications that need improved price performance and predictable pricing.

Feature and option support varies by database engine version and AWS Region.

Aurora offers six times the throughput of PostgreSQL and MySQL. This boost is achieved through a combination of optimizations like advanced read-ahead and write-behind mechanisms, as well as the tight integration within the AWS ecosystem. Moreover, Amazon Aurora is highly scalable. The underlying storage automatically scales up to 256 TiB per database instance. 

Aurora PostgreSQL and Aurora MySQL can run with provisioned instances, whose resources depend on the selected instance type, or with Aurora serverless, which automatically starts, shuts down, and adjusts capacity to application demand.

The engine supports up to 15 low-latency read replicas, which helps in scaling read operations and enhancing the performance of read-heavy applications. Amazon Aurora also simplifies database management tasks. Since it's a managed service, many of the time-consuming tasks such as provisioning, patching, backup, recovery, failure detection, and repair are automated. 

An Aurora MySQL cluster has a single primary open for reads and writes, with read-only replicas that can be automatically promoted to primary after a failure. The primary sends redo log records over the network rather than data pages.

The RDS management API has default throttling limits per AWS account and Region: a token bucket capacity of 300 requests and a refill rate of 12 requests per second. Account-specific increases can raise these limits.

Aurora Global Database lets a single Aurora database span multiple Regions, providing low-latency local reads in each Region and disaster recovery from Region-wide outages.

RDS Extended Support lets Aurora MySQL and PostgreSQL databases continue using major versions after community end-of-life. AWS supplies critical security and bug fixes through patch releases for up to three additional years while you prepare an upgrade.

Aurora PostgreSQL Limitless Database provides automated horizontal scaling beyond a single instance's write-throughput and storage limits by distributing workloads over multiple writer instances while retaining a single database.

Aurora continuously backs up your data to Amazon S3, and these backups are incremental and continuous, meaning that you can quickly recover your database to any point within the saved history. 

For Aurora MySQL, Backtrack can move a database to an earlier point in time without restoring a backup, helping recover from mistakes such as dropping a table or deleting the wrong row.

Snapshot export and cluster export write data from an Aurora snapshot or database cluster to Amazon S3 in Parquet format for analysis with services such as Amazon Athena, Amazon EMR, and Amazon SageMaker.

A comprehensive set of security features also comes built into Amazon Aurora. It integrates with AWS Identity and Access Management (IAM) and offers encryption at rest using AWS Key Management Service (KMS), as well as encryption in transit with SSL. Network isolation using Amazon VPC, along with the ability to create private endpoints, ensures that your data is protected within your own virtual network. 

Data API provides a secure HTTPS API for executing SQL queries against Aurora databases, eliminating the network and application configuration tasks otherwise needed to establish a secure database connection.

Given these sophisticated features, Amazon Aurora is well-suited to a wide range of applications. Its high-performance characteristics make it ideal for enterprise applications, SaaS products, and any scenario that requires a robust, fault-tolerant, and scalable database. With Aurora, businesses and developers have the ability to support heavy workloads while benefiting from the ease of use and cost savings that come with a cloud-native database service.

Learn Amazon Aurora in lessons

22 short lessons on Amazon Aurora in 9 certification courses.

and 16 more lessons

Open the lessons

Concepts related to Amazon Aurora

AWS architecture icons are the property of Amazon Web Services. BlowStack is not affiliated with or endorsed by AWS.