Amazon Aurora
User Guide for Aurora (API Version 2014-10-31)

Document History

  • Latest documentation update: May 22, 2019

  • Current API version: 2014-10-31

The following table describes important changes to the Amazon Aurora User Guide. For notification about updates to this documentation, you can subscribe to an RSS feed. For information about Amazon Relational Database Service (Amazon RDS), see the Amazon Relational Database Service User Guide.

Note

Before August 31, 2018, Amazon Aurora was documented in the Amazon Relational Database Service User Guide. For earlier Aurora document history, see Document History in the Amazon Relational Database Service User Guide.

Change Description Date

Amazon Aurora recommendations

Amazon Aurora now provides automated recommendations for Aurora resources. For more information, see Using Amazon Aurora Recommendations.

May 22, 2019

Aurora PostgreSQL versions 1.2.2, 1.3.2, 2.0.1, 2.1.1, 2.2.1

The following patch versions for Amazon Aurora with PostgreSQL compatibility are now available and include versions 1.2.2, 1.3.2, 2.0.1, 2.1.1, and 2.2.1. For more information, see Database Engine Versions for Amazon Aurora PostgreSQL.

May 21, 2019

Performance Insights support for Aurora Global Database

You can now use Performance Insights with Aurora Global Database. For information about Performance Insights for Aurora, see Using Amazon RDS Performance Insights. For information about Aurora global databases, see Working with Aurora Global Database.

May 13, 2019

Aurora PostgreSQL version 1.4

Version 1.4 of Amazon Aurora with PostgreSQL compatibility is available and compatible with PostgreSQL 9.6.11. For more information, see Version 1.4.

May 9, 2019

Aurora PostgreSQL now provides fast failover recovery with cluster cache management

Aurora with PostgreSQL compatibility now provides cluster cache management to ensure fast recovery of the primary DB instance in the event of a failover. For more information, see Fast Recovery after Failover with Cluster Cache Management.

May 9, 2019

Performance Insights is available for Aurora MySQL 5.7

Amazon RDS Performance Insights is now available for Aurora MySQL 2.x versions, which are compatible with MySQL 5.7. For more information, see Using Amazon RDS Performance Insights.

May 3, 2019

Aurora global databases available in more AWS Regions

You can now create Aurora global databases in most AWS Regions where Aurora is available. For information about Aurora global databases, see Working with Amazon Aurora Global Databases.

April 30, 2019

Minimum Capacity of 1 for Aurora Serverless

The minimum capacity setting you can use for an Aurora Serverless cluster is 1. Formerly, the minimum was 2. For information about specifying Aurora Serverless capacity values, see Setting the Capacity of an Aurora Serverless DB Cluster.

April 29, 2019

Aurora Serverless timeout action

You can now specify the action to take when an Aurora Serverless capacity change times out. For more information, see Timeout Action for Capacity Changes.

April 29, 2019

Per-second billing

Amazon RDS is now billed in 1-second increments in all AWS Regions except AWS GovCloud (US) for on-demand instances. For more information, see DB Instance Billing for Aurora.

April 25, 2019

Sharing Aurora Serverless snapshots across AWS Regions

With Aurora Serverless, snapshots are always encrypted. If you encrypt the snapshot with your own AWS Key Management Service key, you can now copy or share the snapshot across AWS Regions. For information about snapshots of Aurora Serverless DB clusters, see Aurora Serverless and Snapshots.

April 17, 2019

Restore MySQL 5.7 backups from Amazon S3

You can now create a backup of your MySQL version 5.7 database, store it on Amazon S3, and then restore the backup file onto a new Aurora MySQL DB cluster. For more information, see Migrating Data from an External MySQL Database to an Aurora MySQL DB Cluster.

April 17, 2019

Aurora proof-of-concept tutorial

You can learn how to perform a proof of concept to try your application and workload with Aurora. For the full tutorial, see Performing an Aurora Proof of Concept.

April 16, 2019

New modifiable parameters for Aurora Serverless

You can now modify the following DB parameters for an Aurora Serverless cluster: innodb_file_format, innodb_file_per_table, innodb_large_prefix, innodb_lock_wait_timeout, innodb_monitor_disable, innodb_monitor_enable, innodb_monitor_reset, innodb_monitor_reset_all, innodb_print_all_deadlocks, log_warnings, net_read_timeout, net_retry_count, net_write_timeout, sql_mode, and tx_isolation. For more information about configuration parameters for Aurora Serverless clusters, see Aurora Serverless and Parameter Groups.

April 4, 2019

Aurora PostgreSQL supports db.r5 DB instance classes

You can now create Aurora PostgreSQL DB clusters that use the db.r5 DB instance classes. For more information, see DB Instance Class.

April 4, 2019

Aurora PostgreSQL logical replication

You can now use PostgreSQL logical replication to replicate parts of a database for an Aurora PostgreSQL DB cluster. For more information, see Using PostgreSQL Logical Replication.

March 28, 2019

GTID support for Aurora MySQL 2.04

You can now use replication with the global transaction ID (GTID) feature of MySQL 5.7. This feature simplifies performing binary log (binlog) replication between Aurora MySQL and an external MySQL 5.7-compatible database. The replication can use the Aurora MySQL cluster as the source or the destination. This feature is available for Aurora MySQL 2.04 and higher. For more information about GTID-based replication and Aurora MySQL, see Using GTID-Based Replication for Aurora MySQL.

March 25, 2019

Uploading Aurora Serverless logs to Amazon CloudWatch

You can now have Aurora upload database logs to CloudWatch for an Aurora Serverless cluster. For more information, see Viewing Aurora Serverless DB Clusters. As part of this enhancement, you can now define values for instance-level parameters in a DB cluster parameter group, and those values apply to all DB instances in the cluster unless you override them in the DB parameter group. For more information, see Working with DB Parameter Groups and DB Cluster Parameter Groups.

February 25, 2019

Aurora MySQL supports db.t3 DB instance classes

You can now create Aurora MySQL DB clusters that use the db.t3 DB instance classes. For more information, see DB Instance Class.

February 25, 2019

Aurora MySQL supports db.r5 DB instance classes

You can now create Aurora MySQL DB clusters that use the db.r5 DB instance classes. For more information, see DB Instance Class.

February 25, 2019

Performance Insights counters for Aurora MySQL

You can now add performance counters to your Performance Insights charts for Aurora MySQL DB instances. For more information, see Performance Insights Dashboard Components.

February 19, 2019

Aurora PostgreSQL version 2.2.0

Version 2.2.0 of Aurora with PostgreSQL compatibility is available and compatible with PostgreSQL 10.6. For more information, see Version 2.2.0.

February 13, 2019

Amazon RDS Performance Insights supports viewing more SQL text for Aurora MySQL

Amazon RDS Performance Insights now supports viewing more SQL text in the Performance Insights dashboard for Aurora MySQL DB instances. For more information, see Viewing More SQL Text in the Performance Insights Dashboard.

February 6, 2019

Amazon RDS Performance Insights supports viewing more SQL text for Aurora PostgreSQL

Amazon RDS Performance Insights now supports viewing more SQL text in the Performance Insights dashboard for Aurora PostgreSQL DB instances. For more information, see Viewing More SQL Text in the Performance Insights Dashboard.

January 24, 2019

Aurora backup billing

You can use the Amazon CloudWatch metrics TotalBackupStorageBilled, SnapshotStorageUsed, and BackupRetentionPeriodStorageUsed to monitor the space usage of your Aurora backups. For more information about how to use CloudWatch metrics, see Overview of Monitoring. For more information about how to manage storage for backup data, see Understanding Aurora Backup Storage Usage.

January 3, 2019

Performance Insights counters

You can now add performance counters to your Performance Insights charts. For more information, see Performance Insights Dashboard Components.

December 6, 2018

Aurora global databases

You can now create Aurora global databases. An Aurora global database spans multiple AWS Regions, enabling low latency global reads and disaster recovery from region-wide outages. For more information, see Working with Amazon Aurora Global Databases.

November 28, 2018

Query plan management in Aurora PostgreSQL

Aurora with PostgreSQL compatibility now provides query plan management that you can use to manage PostgreSQL query execution plans. For more information, see Managing Query Execution Plans for Aurora PostgreSQL.

November 20, 2018

Query editor for Aurora Serverless (beta)

You can run SQL statements in the Amazon RDS console on Aurora Serverless clusters. For more information, see Using the Query Editor for Aurora Serverless.

November 20, 2018

Data API for Aurora Serverless (beta)

You can access Aurora Serverless clusters with web services–based applications using the Data API. For more information, see Using the Data API for Aurora Serverless.

November 20, 2018

Aurora PostgreSQL version 2.1

Aurora with PostgreSQL compatibility version 2.1 is available and compatible with PostgreSQL 10.5. For more information, see Version 2.1.

November 20, 2018

TLS support for Aurora Serverless

Aurora Serverless clusters support TLS/SSL encryption. For more information, see TLS/SSL for Aurora Serverless.

November 19, 2018

Custom endpoints

You can now create endpoints that are associated with an arbitrary set of DB instances. This feature helps with load balancing and high availability for Aurora clusters where some DB instances have different capacity or configuration than others. You can use custom endpoints instead of connecting to a specific DB instance through its instance endpoint. For more information, see Amazon Aurora Connection Management.

November 12, 2018

IAM authentication support in Aurora PostgreSQL

Aurora with PostgreSQL compatibility now supports IAM authentication. For more information see IAM Database Authentication.

November 8, 2018

Custom parameter groups for restore and point in time recovery

You can now specify a custom parameter group when you restore a snapshot or perform a point in time recovery operation. For more information, see Restoring from a DB Cluster Snapshot and Restoring a DB Cluster to a Specified Time.

October 15, 2018

Deletion protection for Aurora DB clusters

When you enable deletion protection for a DB cluster, the database cannot be deleted by any user. For more information, see Deleting a DB Instance in a DB Cluster.

September 26, 2018

Aurora PostgreSQL version 2.0

Aurora with PostgreSQL compatibility version 2.0 is available and compatible with PostgreSQL 10.4. For more information, see Version 2.0.

September 25, 2018

Stop/Start feature Aurora

You can now stop or start an entire Aurora cluster with a single operation. For more information, see Stopping and Starting an Aurora Cluster.

September 24, 2018

Parallel Query feature for Aurora MySQL

Aurora MySQL now offers an option to parallelize I/O work for queries across the Aurora storage infrastructure. This feature speeds up data-intensive analytic queries, which are often the most time-consuming operations in a workload. For more information, see Working with Parallel Query for Aurora MySQL.

September 20, 2018

Aurora PostgreSQL version 1.3

Aurora PostgreSQL version 1.3 is now available and is compatible with PostgreSQL 9.6.9. For more information, see Version 1.3.

September 11, 2018

New guide

This is the first release of the Amazon Aurora User Guide.

August 31, 2018