Document history - Amazon Aurora

Document history

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.

You can filter new Amazon Aurora features on the What's New with Database? page. For Products, choose Amazon Aurora. Then search using keywords such as global database or Serverless.

ChangeDescriptionDate

Amazon Aurora supports in-place upgrade for MySQL 5.7-compatible Aurora MySQL

You can perform an in-place upgrade to change an existing MySQL 5.7-compatible Aurora MySQL cluster into a MySQL 8.0-compatible Aurora MySQL cluster. For more information, see Upgrading from Aurora MySQL 2.x to 3.x.

September 26, 2022

Performance Insights shows the top 25 SQL queries

In the Performance Insights dashboard, the Top SQL tab shows the 25 SQL queries that are contributing the most to DB load. For more information, see Overview of the Top SQL tab.

September 13, 2022

Aurora MySQL supports a new DB instance class

You can now use the db.r6i DB instance class for Aurora MySQL DB clusters. For more information, see DB instance classes.

September 13, 2022

Amazon Aurora available in the Middle East (UAE) Region

Aurora is now available in the Middle East (UAE) Region. For more information, see Regions and Availability Zones.

August 30, 2022

Amazon Aurora supports automatically setting up connectivity with an EC2 instance

When you create an Aurora DB cluster, you can use the AWS Management Console to set up connectivity between an Amazon Elastic Compute Cloud instance and the new DB cluster. For more information, see Configure automatic network connectivity with an EC2 instance.

August 22, 2022

Amazon Aurora supports dual-stack mode

DB clusters can now run in dual-stack mode. In dual-stack mode, resources can communicate with the DB cluster over IPv4, IPv6, or both. For more information, see Amazon Aurora IP addressing.

August 17, 2022

Amazon Aurora supports in-place upgrade for PostgreSQL-compatible Aurora Serverless v1

You can perform an in-place upgrade for a PostgreSQL 10-compatible Aurora Serverless v1 cluster to change an existing cluster into a PostgreSQL 11-compatible Aurora Serverless v1 cluster. For the in-place upgrade procedure, see Modifying an Aurora Serverless v1 DB cluster.

August 8, 2022

Performance Insights supports the Asia Pacific (Jakarta) Region

Formerly, you couldn't use Performance Insights in the Asia Pacific (Jakarta) Region. This restriction has been removed. For more information, see AWS Region support for Performance Insights.

July 21, 2022

Amazon Aurora supports a new DB instance class

You can now use the db.r6i DB instance class for Aurora PostgreSQL DB clusters. For more information, see DB instance classes.

July 14, 2022

RDS Performance Insights supports additional retention periods

Previously, Performance Insights offered only two retention periods: 7 days (default) or 2 years (731 days). Now, if you need to retain your performance data for longer than 7 days, you can specify from 1–24 months. For more information, see Pricing and data retention for Performance Insights.

July 1, 2022

Amazon Aurora supports in-place upgrade for MySQL-compatible Aurora Serverless v1

You can perform an in-place upgrade for a MySQL 5.6-compatible Aurora Serverless v1 cluster to change an existing cluster into a MySQL 5.7-compatible Aurora Serverless v1 cluster. For the in-place upgrade procedure, see Modifying an Aurora Serverless v1 DB cluster.

June 16, 2022

Aurora supports turning on Amazon DevOps Guru in the RDS console

You can turn on DevOps Guru coverage for your Aurora databases from within the RDS console. For more information, see Setting up DevOps Guru for RDS.

June 9, 2022

Amazon Aurora supports publishing events to encrypted Amazon SNS topics

Amazon Aurora can now publish events to Amazon Simple Notification Service (Amazon SNS) topics that have server-side encryption (SSE) enabled, for additional protection of events that carry sensitive data. For more information, see Subscribing to Amazon RDS event notification.

June 1, 2022

Amazon RDS publishes usage metrics to Amazon CloudWatch

The AWS/Usage namespace in Amazon CloudWatch includes account-level usage metrics for your Amazon RDS service quotas. For more information, see Amazon CloudWatch usage metrics for Amazon Aurora.

April 28, 2022

Data API result sets in JSON format

An optional parameter for the ExecuteStatement function causes the query result set to be returned as a string in JSON format. The JSON result set is simple and convenient to transform into a data structure in your application's language. For more information, see Processing query results in JSON format.

April 27, 2022

Amazon Aurora Serverless v2 is now generally available

Amazon Aurora Serverless v2 is generally available for all users. For more information, see Using Aurora Serverless v2.

April 21, 2022

Aurora MySQL supports configurable cipher suites

With Aurora MySQL, you can now use configurable cipher suites to control the connection encryption that your database server accepts. For more information, see Configuring cipher suites for connections to Aurora MySQL DB clusters.

April 15, 2022

Aurora PostgreSQL supports RDS Proxy with PostgreSQL 13

You can now create an RDS Proxy with an Aurora PostgreSQL 13 DB cluster. For more information about RDS Proxy, see Using Amazon RDS Proxy.

April 4, 2022

Release Notes for Aurora PostgreSQL

There is now a separate guide for the Amazon Aurora PostgreSQL release notes. For more information, see Release Notes for Aurora PostgreSQL.

March 22, 2022

Release Notes for Aurora MySQL

There is now a separate guide for the Amazon Aurora MySQL release notes. For more information, see Release Notes for Aurora MySQL.

March 22, 2022

Aurora PostgreSQL supports multi-major version upgrades

You can now perform version upgrades of Aurora PostgreSQL DB clusters across multiple major versions. For more information, see How to perform a major version upgrade.

March 4, 2022

Aurora PostgreSQL supports configurable cipher suites

With Aurora PostgreSQL versions 11.8 and higher, you can now use configurable cipher suites to control the connection encryption that your database server accepts. For information about using configurable cipher suites with Aurora PostgreSQL, see Configuring cipher suites for connections to Aurora PostgreSQL DB clusters.

March 4, 2022

AWS JDBC Driver for MySQL generally available

The AWS JDBC Driver for MySQL is a client driver designed for the high availability of Aurora MySQL. The AWS JDBC Driver for MySQL is now generally available. For more information, see Connecting with the Amazon Web Services JDBC Driver for MySQL.

March 2, 2022

Aurora PostgreSQL 13.5 supports Babelfish for Aurora PostgreSQL 1.1.0

Aurora PostgreSQL 13.5 supports Babelfish 1.1.0. For a list of new features, see 13.5. For a list of features supported in each Babelfish release, see Supported functionality in Babelfish by version. For usage information, see Working with Babelfish for Aurora PostgreSQL.

February 28, 2022

Amazon Aurora supports Database Activity Streams in the Asia Pacific (Jakarta) Region

For more information, see Support for AWS Regions for database activity streams.

February 16, 2022

Performance Insights supports new API operations

Performance Insights now supports the following API operations: GetResourceMetadata, ListAvailableResourceDimensions, and ListAvailableResourceMetrics. For more information, see Retrieving metrics with the Performance Insights API in this manual and the Amazon RDS Performance Insights API Reference.

January 12, 2022

Amazon RDS Proxy supports events

RDS Proxy now generates events that you can subscribe to and view in CloudWatch Events or configure to send to Amazon EventBridge. For more information, see Working with RDS Proxy events.

January 11, 2022

RDS Proxy available in additional AWS Regions

RDS Proxy is now available in the following Regions: Africa (Cape Town), Asia Pacific (Hong Kong), Asia Pacific (Osaka), Europe (Milan), Europe (Paris), Europe (Stockholm), Middle East (Bahrain), and South America (São Paulo). For more information about RDS Proxy, see Using Amazon RDS Proxy.

January 5, 2022

Amazon Aurora available in the Asia Pacific (Jakarta) Region

Aurora is now available in the Asia Pacific (Jakarta) Region. For more information, see Regions and Availability Zones.

December 13, 2021

DevOps Guru for Amazon RDS provides detailed insights and recommendations for Amazon Aurora

DevOps Guru for RDS mines Performance Insights for performance-related data. Using this data, the service analyzes the performance of your Amazon Aurora DB instances and can help you resolve performance issues. To learn more, see Analyzing performance anomalies with DevOps Guru for RDS in this guide and see Overview of DevOps Guru for RDS in the Amazon DevOps Guru User Guide.

December 1, 2021

Aurora PostgreSQL supports RDS Proxy with PostgreSQL 12

You can now create an RDS Proxy with an Aurora PostgreSQL 12 database cluster. For more information about RDS Proxy, see Using Amazon RDS Proxy.

November 22, 2021

Aurora supports AWS Graviton2 instance classes for Database Activity Streams

You can use database activity streams with the db.r6g instance class for Aurora MySQL and Aurora PostgreSQL. For more information, see Supported DB instance classes.

November 3, 2021

Amazon Aurora support for cross-account AWS KMS keys

You can use a KMS key from a different AWS account for encryption when exporting DB snapshots to Amazon S3. For more information, see Exporting DB snapshot data to Amazon S3.

November 3, 2021

Amazon Aurora supports Babelfish for Aurora PostgreSQL

Babelfish for Aurora PostgreSQL extends your Amazon Aurora PostgreSQL-Compatible Edition database with the ability to accept database connections from Microsoft SQL Server clients. For more information, see Working with Babelfish for Aurora PostgreSQL.

October 28, 2021

Aurora Serverless v1 can require SSL for connections

The Aurora cluster parameters force_ssl for PostgreSQL and require_secure_transport for MySQL are supported now for Aurora Serverless v1. For more information, see Using TLS/SSL with Aurora Serverless v1.

October 26, 2021

Amazon Aurora supports Performance Insights in additional AWS Regions

Performance Insights is available in the Middle East (Bahrain), Africa (Cape Town), Europe (Milan), and Asia Pacific (Osaka) Regions. For more information, see AWS Region support for Performance Insights.

October 5, 2021

Configurable autoscaling timeout for Aurora Serverless v1

You can choose how long Aurora Serverless v1 waits to find an autoscaling point. If no autoscaling point is found during that period, Aurora Serverless v1 cancels the scaling event or forces the capacity change, depending on the timeout action that you selected. For more information, see Autoscaling for Aurora Serverless v1.

September 10, 2021

Aurora supports X2g and T4g instance classes

Both Aurora MySQL and Aurora PostgreSQL can now use X2g and T4g instance classes. The instance classes that you can use depend on the version of Aurora MySQL or Aurora PostgreSQL. For information about supported instance types, see DB instance classes.

September 10, 2021

Amazon RDS supports RDS Proxy in a shared VPC

You can now create an RDS Proxy in a shared virtual private cloud (VPC). For more information about RDS Proxy, see "Managing Connections with Amazon RDS Proxy" in the Amazon RDS User Guide or the Aurora User Guide.

August 6, 2021

Aurora version policy page

The Amazon Aurora User Guide now includes a section with general information about Aurora versions and associated policies. For details, see Amazon Aurora versions.

July 14, 2021

Exclude Data API events from an AWS CloudTrail trail

You can exclude Data API events from a CloudTrail trail. For more information, see Excluding Data API events from an AWS CloudTrail trail.

July 2, 2021

Amazon Aurora PostgreSQL-Compatible Edition supports additional extensions

Newly supported extensions include pg_bigm, pg_cron, pg_partman, and pg_proctab. For more information, see Extension versions for Amazon Aurora PostgreSQL-Compatible Edition.

June 17, 2021

Cloning for Aurora Serverless clusters

You can now create cloned clusters that are Aurora Serverless. For information about cloning, see Cloning a volume for an Aurora DB cluster.

June 16, 2021

Aurora global databases available in China (Beijing) and China (Ningxia) Regions

You can now create Aurora global databases in the China (Beijing) and China (Ningxia) Regions. For information about Aurora global databases, see Working with Amazon Aurora global databases.

May 19, 2021

FIPS 140-2 support for Data API

The Data API supports the Federal Information Processing Standard Publication 140-2 (FIPS 140-2) for SSL/TLS connections. For more information, see Data API availability.

May 14, 2021

AWS JDBC Driver for PostgreSQL (preview)

The AWS JDBC Driver for PostgreSQL, now available in preview, is a client driver designed for the high availability of Aurora PostgreSQL. For more information, see Connecting with the Amazon Web Services JDBC Driver for PostgreSQL (preview).

April 27, 2021

The Data API available in additional AWS Regions

The Data API is now available in the Asia Pacific (Seoul) and Canada (Central) Regions. For more information, see Availability of the Data API.

April 9, 2021

Amazon Aurora supports the Graviton2 DB instance classes

You can now use the Graviton2 DB instance classes db.r6g.x to create DB clusters running MySQL or PostgreSQL. For more information, see DB instance class types.

March 12, 2021

RDS Proxy endpoint enhancements

You can create additional endpoints associated with each RDS proxy. Creating an endpoint in a different VPC enables cross-VPC access for the proxy. Proxies for Aurora MySQL clusters can also have read-only endpoints. These reader endpoints connect to reader DB instances in the clusters and can improve read scalability and availability for query-intensive applications. For more information about RDS Proxy, see "Managing Connections with Amazon RDS Proxy" in the Amazon RDS User Guide or the Aurora user guide.

March 8, 2021

Amazon Aurora available in the Asia Pacific (Osaka) Region

Aurora is now available in the Asia Pacific (Osaka) Region. For more information, see Regions and Availability Zones.

March 1, 2021

Aurora PostgreSQL supports enabling both IAM and Kerberos authentication on the same DB cluster

Aurora PostgreSQL now supports enabling both IAM authentication and Kerberos authentication on the same DB cluster. For more information, see Database authentication with Amazon Aurora.

February 24, 2021

Aurora global database now supports managed planned failover

Aurora global database now supports managed planned failover, allowing you to more easily change the primary AWS Region of your Aurora global database. You can use managed planned failover with healthy Aurora global databases only. To learn more, see Disaster recovery and Amazon Aurora global databases. For reference information, see FailoverGlobalCluster in the Amazon RDS API Reference.

February 11, 2021

Data API for Aurora Serverless now supports more data types

With the Data API for Aurora Serverless, you can now use UUID and JSON data types as input to your database. Also with the Data API for Aurora Serverless, you can now have a LONG type value returned from your database as a STRING value. To learn more, see Calling the Data API. For reference information about supported data types, see SqlParameter in the Amazon RDS Data Service API Reference.

February 2, 2021

Aurora PostgreSQL supports major version upgrades to PostgreSQL 12

With Aurora PostgreSQL, you can now upgrade the DB engine to major version 12. For more information, see Upgrading the PostgreSQL DB engine for Aurora PostgreSQL.

January 28, 2021

Aurora MySQL supports in-place upgrade

You can upgrade your Aurora MySQL 1.x cluster to Aurora MySQL 2.x, preserving the DB instances, endpoints, and so on of the original cluster. This in-place upgrade technique avoids the inconvenience of setting up a whole new cluster by restoring a snapshot. It also avoids the overhead of copying all your table data into a new cluster. For more information, see Upgrading the major version of an Aurora MySQL DB cluster from 1.x to 2.x.

January 11, 2021

AWS JDBC Driver for MySQL (preview)

The AWS JDBC Driver for MySQL, now available in preview, is a client driver designed for the high availability of Aurora MySQL. For more information, see Connecting with the Amazon Web Services JDBC Driver for MySQL (preview).

January 7, 2021

Aurora supports database activity streams on secondary clusters of a global database

You can start a database a database activity stream on a primary or secondary cluster of Aurora PostgreSQL or Aurora MySQL. For supported engine versions, see Limitations of Aurora global databases.

December 22, 2020

Multi-master clusters with 4 DB instances

The maximum number of DB instances in an Aurora MySQL multi-master cluster is now four. Formerly, the maximum was two DB instances. For more information, see Working with Aurora Multi-Master Clusters.

December 17, 2020

Aurora PostgreSQL supports AWS Lambda functions

You can now invoke AWS Lambda function for your Aurora PostgreSQL DB clusters. For more information, see Invoking a Lambda function from an Aurora PostgreSQL DB cluster.

December 11, 2020

Amazon Aurora supports the Graviton2 DB instance classes in preview

You can now use the Graviton2 DB instance classes db.r6g.x in preview to create DB clusters running MySQL or PostgreSQL. For more information, see DB instance class types.

December 11, 2020

Amazon Aurora Serverless v2 is now available in preview.

Amazon Aurora Serverless v2 is available in preview. To work with Amazon Aurora Serverless v2, apply for access. For more information, see the Aurora Serverless v2 page.

December 1, 2020

Aurora PostgreSQL is now available for Aurora Serverless in more AWS Regions.

Aurora PostgreSQL is now available for Aurora Serverless in more AWS Regions. You can now choose to run Aurora PostgreSQL Serverless v1 in the same AWS Regions that offer Aurora MySQL Serverless v1. Additional AWS Regions with Aurora Serverless support include US West (N. California), Asia Pacific (Singapore) Asia Pacific (Sydney) Asia Pacific (Seoul) Asia Pacific (Mumbai) Canada (Central) Europe (London) and Europe (Paris). For a list of all Regions and supported Aurora DB engines for Aurora Serverless, see Aurora Serverless. Amazon RDS Data API for Aurora Serverless is also now available in these same AWS Regions. For a list of all Regions with support for the Data API for Aurora Serverless, see Data API for Aurora Serverless

November 24, 2020

Amazon RDS Performance Insights introduces new dimensions

You can group database load according to the dimension groups for database, application (PostgreSQL), and session type (PostgreSQL). Amazon RDS also supports the dimensions db.name, db.application.name (PostgreSQL), and db.session_type.name (PostgreSQL). For more information, see Top load table.

November 24, 2020

Aurora Serverless supports Aurora PostgreSQL version 10.12

Aurora PostgreSQL for Aurora Serverless has been upgraded to Aurora PostgreSQL version 10.12 throughout the AWS Regions where Aurora PostgreSQL for Aurora Serverless is supported. For more information, see Aurora Serverless.

November 4, 2020

The Data API now supports tag-based authorization

The Data API supports tag-based authorization. If you've labeled your RDS cluster resources with tags, you can use these tags in your policy statements to control access through the Data API. For more information, see Authorizing access to the Data API.

October 27, 2020

Amazon Aurora extends support for exporting snapshots to Amazon S3

You can now export DB snapshot data to Amazon S3 in all commercial AWS Regions. For more information, see Exporting DB snapshot data to Amazon S3.

October 22, 2020

Aurora global database supports cloning

You can now create clones of the primary and secondary DB clusters of your Aurora global databases. You can do so by using the AWS Management Console and choosing the Create clone menu option. You can also use the AWS CLI and run the restore-db-cluster-to-point-in-time command with the --restore-type copy-on-write option. Using the AWS Management Console or the AWS CLI, you can also clone DB clusters from your Aurora global databases across AWS accounts. For more information about cloning, see Cloning an Aurora DB cluster volume.

October 19, 2020

Amazon Aurora supports dynamic resizing for the cluster volume

Starting with Aurora MySQL 1.23 and 2.09, and Aurora PostgreSQL 3.3.0 and Aurora PostgreSQL 2.6.0, Aurora reduces the size of the cluster volume after you remove data through operations such as DROP TABLE. To take advantage of this enhancement, upgrade to one of the appropriate versions depending on the database engine that your cluster uses. For information about this feature and how to check used and available storage space for an Aurora cluster, see Managing Performance and Scaling for Aurora DB Clusters.

October 13, 2020

Amazon Aurora supports volume sizes up to 128 TiB

New and existing Aurora cluster volumes can now grow to a maximum size of 128 tebibytes (TiB). For more information, see How Aurora storage grows.

September 22, 2020

Aurora PostgreSQL supports the db.r5 and db.t3 DB instance classes in the China (Ningxia) Region

You can now create Aurora PostgreSQL DB clusters in the China (Ningxia) Region that use the db.r5 and db.t3 DB instance classes. For more information, see DB instance classes.

September 3, 2020

Aurora parallel query enhancements

Starting with Aurora MySQL 2.09 and 1.23, you can take advantage of enhancements to the parallel query feature. Creating a parallel query cluster no longer requires a special engine mode. You can now turn parallel query on and off using the aurora_parallel_query configuration option for any provisioned cluster that's running a compatible Aurora MySQL version. You can upgrade an existing cluster to a compatible Aurora MySQL version and use parallel query, instead of creating a new cluster and importing data into it. You can use Performance Insights for parallel query clusters. You can stop and start parallel query clusters. You can create Aurora parallel query clusters that are compatible with MySQL 5.7. Parallel query works for tables that use the DYNAMIC row format. Parallel query clusters can use AWS Identity and Access Management (IAM) authentication. Reader DB instances in parallel query clusters can take advantage of the READ COMMITTED isolation level. You can also now create parallel query clusters in additional AWS Regions. For more information about the parallel query feature and these enhancements, see Working with parallel query for Aurora MySQL.

September 2, 2020

Changes to Aurora MySQL parameter binlog_rows_query_log_events

You can now change the value of the Aurora MySQL configuration parameter binlog_rows_query_log_events. Formerly, this parameter wasn't modifiable.

August 26, 2020

Support for automatic minor version upgrades for Aurora MySQL

With Aurora MySQL, the setting Enable auto minor version upgrade now takes effect when you specify it for an Aurora MySQL DB cluster. When you enable auto minor version upgrade, Aurora automatically upgrades to new minor versions as they are released. The automatic upgrades occur during the maintenance window for the database. For Aurora MySQL, this feature applies only to Aurora MySQL version 2, which is compatible with MySQL 5.7. Initially, the automatic upgrade procedure brings Aurora MySQL DB clusters to version 2.07.2. For more information about how this feature works with Aurora MySQL, see Database Upgrades and Patches for Amazon Aurora MySQL.

August 3, 2020

Aurora PostgreSQL supports major version upgrades to PostgreSQL version 11

With Aurora PostgreSQL, you can now upgrade the DB engine to major version 11. For more information, see Upgrading the PostgreSQL DB engine for Aurora PostgreSQL.

July 28, 2020

Amazon Aurora supports AWS PrivateLink

Amazon Aurora now supports creating Amazon VPC endpoints for Amazon RDS API calls to keep traffic between applications and Aurora in the AWS network. For more information, see Amazon Aurora and interface VPC endpoints (AWS PrivateLink).

July 9, 2020

RDS Proxy generally available

RDS Proxy is now generally available. You can use RDS Proxy with RDS for MySQL, Aurora MySQL, RDS for PostgreSQL, and Aurora PostgreSQL for production workloads. For more information about RDS Proxy, see "Managing Connections with Amazon RDS Proxy" in the Amazon RDS User Guide or the Aurora user guide.

June 30, 2020

Aurora global database write forwarding

You can now enable write capability on secondary clusters in a global database. With write forwarding, you issue DML statements on a secondary cluster, Aurora forwards the write to the primary cluster, and the updated data is replicated to all the secondary clusters. For more information, see Write forwarding for secondary AWS Regions with an Aurora global database.

June 18, 2020

Aurora supports integration with AWS Backup

You can use AWS Backup to manage backups of Aurora DB clusters. For more information, see Overview of backing up and restoring an Aurora DB cluster.

June 10, 2020

Aurora PostgreSQL supports db.t3.large DB instance classes

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

June 5, 2020

Aurora global database supports PostgreSQL version 11.7 and managed recovery point objective (RPO)

You can now create Aurora global databases for the PostgreSQL database engine version 11.7. You can also manage how a PostgreSQL global database recovers from a failure using a recovery point objective (RPO). For more information, see Cross-Region Disaster Recovery for Aurora global databases.

June 4, 2020

Aurora MySQL supports database monitoring with database activity streams

Aurora MySQL now includes database activity streams, which provide a near-real-time data stream of the database activity in your relational database. For more information, see Using database activity streams.

June 2, 2020

The query editor available in additional AWS Regions

The query editor for Aurora Serverless is now available in additional AWS Regions. For more information, see Availability of the query editor.

May 28, 2020

The Data API available in additional AWS Regions

The Data API is now available in additional AWS Regions. For more information, see Availability of the Data API.

May 28, 2020

RDS Proxy available in Canada (Central) Region

You can now use the RDS Proxy preview in the Canada (Central) Region. For more information about RDS Proxy, see Managing connections with Amazon RDS proxy (preview).

May 28, 2020

Aurora global database and cross-Region read replicas

For an Aurora global database, you can now create an Aurora MySQL cross-Region read replica from the primary cluster in the same region as a secondary cluster. For more information about Aurora Global Database and cross-Region read replicas, see Working with Amazon Aurora global database and Replicating Amazon Aurora MySQL DB.

May 18, 2020

RDS Proxy available in more AWS Regions

You can now use the RDS Proxy preview in the US West (N. California) Region, the Europe (London) Region, the Europe (Frankfurt) Region, the Asia Pacific (Seoul) Region, the Asia Pacific (Mumbai) Region, the Asia Pacific (Singapore) Region, and the Asia Pacific (Sydney) Region. For more information about RDS Proxy, see Managing connections with Amazon RDS proxy (preview).

May 13, 2020

Aurora PostgreSQL-Compatible Edition supports on-premises or self-hosted Microsoft active directory

You can now use an on-premises or self-hosted Active Directory for Kerberos authentication of users when they connect to your Aurora PostgreSQL DB clusters. For more information, see Using Kerberos authentication with Aurora PostgreSQL.

May 7, 2020

Aurora MySQL multi-master clusters available in more AWS Regions

You can now create Aurora multi-master clusters in the Asia Pacific (Seoul) Region, the Asia Pacific (Tokyo) Region, the Asia Pacific (Mumbai) Region, and the Europe (Frankfurt) Region. For more information about multi-master clusters, see Working with Aurora multi-master clusters.

May 7, 2020

Performance Insights supports analyzing statistics of running Aurora MySQL queries

You can now analyze statistics of running queries with Performance Insights for Aurora MySQL DB instances. For more information, see Analyzing statistics of running queries.

May 5, 2020

Java client library for Data API generally available

The Java client library for the Data API is now generally available. You can download and use a Java client library for Data API. It enables you to map your client-side classes to requests and responses of the Data API. For more information, see Using the Java client library for Data API.

April 30, 2020

Amazon Aurora available in the Europe (Milan) Region

Aurora is now available in the Europe (Milan) Region. For more information, see Regions and Availability Zones.

April 28, 2020

Amazon Aurora available in the Europe (Milan) Region

Aurora is now available in the Europe (Milan) Region. For more information, see Regions and Availability Zones.

April 27, 2020

Amazon Aurora available in the Africa (Cape Town) Region

Aurora is now available in the Africa (Cape Town) Region. For more information, see Regions and Availability Zones.

April 22, 2020

Aurora PostgreSQL now supports db.r5.16xlarge and db.r5.8xlarge DB instance classes

You can now create Aurora PostgreSQL DB clusters running PostgreSQL that use the db.r5.16xlarge and db.r5.8xlarge DB instance classes. For more information, see Hardware specifications for DB instance classes for Aurora.

April 8, 2020

Amazon RDS proxy for PostgreSQL

Amazon RDS Proxy is now available for PostgreSQL. You can use RDS Proxy to reduce the overhead of connection management on your cluster and also the chance of "too many connections" errors. The RDS Proxy is currently in public preview for PostgreSQL. For more information, see Managing connections with Amazon RDS proxy (preview).

April 8, 2020

Aurora global databases now support Aurora PostgreSQL

You can now create Aurora global databases for the PostgreSQL database engine. 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 database.

March 10, 2020

Support for major version upgrades for Aurora PostgreSQL

With Aurora PostgreSQL, you can now upgrade the DB engine to a major version. By doing so, you can skip ahead to a newer major version when you upgrade select PostgreSQL engine versions. For more information, see Upgrading the PostgreSQL DB engine for Aurora PostgreSQL.

March 4, 2020

Aurora PostgreSQL supports Kerberos authentication

You can now use Kerberos authentication to authenticate users when they connect to your Aurora PostgreSQL DB clusters. For more information, see Using Kerberos authentication with Aurora PostgreSQL.

February 28, 2020

The Data API supports AWS PrivateLink

The Data API now supports creating Amazon VPC endpoints for Data API calls to keep traffic between applications and the Data API in the AWS network. For more information, see Creating an Amazon VPC endpoint (AWS PrivateLink) for the Data API.

February 6, 2020

Aurora machine learning support in Aurora PostgreSQL

The aws_ml Aurora PostgreSQL extension provides functions you use in your database queries to call Amazon Comprehend for sentiment analysis and SageMaker to run your own machine learning models. For more information, see Using machine learning (ML) capabilities with Aurora.

February 5, 2020

Aurora PostgreSQL supports exporting data to Amazon S3

You can query data from an Aurora PostgreSQL DB cluster and export it directly into files stored in an Amazon S3 bucket. For more information, see Exporting data from an Aurora PostgreSQL DB cluster to Amazon S3.

February 5, 2020

Support for exporting DB snapshot data to Amazon S3

Amazon Aurora supports exporting DB snapshot data to Amazon S3 for MySQL and PostgreSQL. For more information, see Exporting DB snapshot data to Amazon S3.

January 9, 2020

Aurora MySQL release notes in document history

This section now includes history entries for Aurora MySQL-Compatible Edition release notes for versions released after August 31, 2018. For the full release notes for a specific version, choose the link in the first column of the history entry.

December 13, 2019

Amazon RDS proxy

You can reduce the overhead of connection management on your cluster, and reduce the chance of "too many connections" errors, by using the Amazon RDS Proxy. You associate each proxy with an RDS DB instance or Aurora DB cluster. Then you use the proxy endpoint in the connection string for your application. The Amazon RDS Proxy is currently in a public preview state. It supports the Aurora MySQL database engine. For more information, see Managing connections with Amazon RDS proxy (preview).

December 3, 2019

Data API for Aurora Serverless v1 supports data type mapping hints

You can now use a hint to instruct the Data API for Aurora Serverless v1 to send a String value to the database as a different type. For more information, see Calling the data API.

November 26, 2019

Data API for Aurora Serverless v1 supports a Java client library (preview)

You can download and use a Java client library for Data API. It enables you to map your client-side classes to requests and responses of the Data API. For more information, see Using the Java client library for Data API.

November 26, 2019

Aurora PostgreSQL is FedRAMP HIGH eligible

Aurora PostgreSQL is FedRAMP HIGH eligible. For details about AWS and compliance efforts, see AWS services in scope by compliance program.

November 26, 2019

READ COMMITTED isolation level enabled for Amazon Aurora MySQL replicas

You can now enable the READ COMMITTED isolation level on Aurora MySQL Replicas. Doing so requires enabling the aurora_read_replica_read_committed_isolation_enabled configuration setting at the session level. Using the READ COMMITTED isolation level for long-running queries on OLTP clusters can help address issues with history list length. Before enabling this setting, be sure to understand how the isolation behavior on Aurora Replicas differs from the usual MySQL implementation of READ COMMITTED. For more information, see Aurora MySQL isolation levels.

November 25, 2019

Performance Insights supports analyzing statistics of running Aurora PostgreSQL queries

You can now analyze statistics of running queries with Performance Insights for Aurora PostgreSQL DB instances. For more information, see Analyzing statistics of running queries.

November 25, 2019

More clusters in an Aurora global database

You can now add multiple secondary regions to an Aurora global database. You can take advantage of low latency global reads and disaster recovery across a wider geographic area. For more information about Aurora global databases, see Working with Amazon Aurora global databases.

November 25, 2019

Aurora machine learning support in Aurora MySQL

In Aurora MySQL 2.07 and higher, you can call Amazon Comprehend for sentiment analysis and SageMaker for a wide variety of machine learning algorithms. You use the results directly in your database application by embedding calls to stored functions in your queries. For more information, see Using machine learning (ML) capabilities with Aurora.

November 25, 2019

Aurora global database no longer requires engine mode setting

You no longer need to specify --engine-mode=global when creating a cluster that is intended to be part of an Aurora global database. All Aurora clusters that meet the compatibility requirements are eligible to be part of a global database. For example, the cluster currently must use Aurora MySQL version 1 with MySQL 5.6 compatibility. For information about Aurora global databases, see Working with Amazon Aurora global databases.

November 25, 2019

Aurora global database is available for Aurora MySQL version 2

Starting in Aurora MySQL 2.07, you can create an Aurora global database with MySQL 5.7 compatibility. You don't need to specify the global engine mode for the primary or secondary clusters. You can add any new provisioned cluster with Aurora MySQL 2.07 or higher to an Aurora Global Database. For information about Aurora Global Database, see Working with Amazon Aurora global database.

November 25, 2019

Aurora MySQL hot row contention optimization available without lab mode

The hot row contention optimization is now generally available for Aurora MySQL and does not require the Aurora lab mode setting to be ON. This feature substantially improves throughput for workloads with many transactions contending for rows on the same page. The improvement involves changing the lock release algorithm used by Aurora MySQL.

November 19, 2019

Aurora MySQL hash joins available without lab mode

The hash join feature is now generally available for Aurora MySQL and does not require the Aurora lab mode setting to be ON. This feature can improve query performance when you need to join a large amount of data by using an equijoin. For more information about using this feature, see Working with hash joins in Aurora MySQL.

November 19, 2019

Aurora MySQL 2.* support for more db.r5 instance classes

Aurora MySQL clusters now support the instance types db.r5.8xlarge, db.r5.16xlarge, and db.r5.24xlarge. For more information about instance types for Aurora MySQL clusters, see Choosing the DB instance class.

November 19, 2019

Aurora MySQL 2.* support for backtracking

Aurora MySQL 2.* versions now offer a quick way to recover from user errors, such as dropping the wrong table or deleting the wrong row. Backtrack allows you to move your database to a prior point in time without needing to restore from a backup, and it completes within seconds, even for large databases. For details, see Backtracking an Aurora DB cluster.

November 19, 2019

Billing tag support for Aurora

You can now use tags to keep track of cost allocation for resources such as Aurora clusters, DB instances within Aurora clusters, I/O, backups, snapshots, and so on. You can see costs associated with each tag using AWS Cost Explorer. For more information about using tags with Aurora, see Tagging Amazon RDS resources. For general information about tags and ways to use them for cost analysis, see Using cost allocation tags and User-defined cost allocation tags.

October 23, 2019

Data API for Aurora PostgreSQL

Aurora PostgreSQL now supports using the Data API with Amazon Aurora Serverless v1 DB clusters. For more information, see Using the Data API for Aurora Serverless v1.

September 23, 2019

Aurora PostgreSQL supports uploading database logs to CloudWatch logs

You can configure your Aurora PostgreSQL DB cluster to publish log data to a log group in Amazon CloudWatch Logs. With CloudWatch Logs, you can perform real-time analysis of the log data, and use CloudWatch to create alarms and view metrics. You can use CloudWatch Logs to store your log records in highly durable storage. For more information, see Publishing Aurora PostgreSQL logs to Amazon CloudWatch Logs.

August 9, 2019

Multi-master clusters for Aurora MySQL

You can set up Aurora MySQL multi-master clusters. In these clusters, each DB instance has read/write capability. For more information, see Working with Aurora multi-master clusters.

August 8, 2019

Aurora PostgreSQL supports Aurora Serverless v1

You can now use Amazon Aurora Serverless v1 with Aurora PostgreSQL. An Aurora Serverless DB cluster automatically starts up, shuts down, and scales up or down its compute capacity based on your application's needs. For more information, see Using Amazon Aurora Serverless v1.

July 9, 2019

Cross-account cloning for Aurora MySQL

You can now clone the cluster volume for an Aurora MySQL DB cluster between AWS accounts. You authorize the sharing through AWS Resource Access Manager (AWS RAM). The cloned cluster volume uses a copy-on-write mechanism, which only requires additional storage for new or changed data. For more information about cloning for Aurora, see Cloning databases in an Aurora DB cluster.

July 2, 2019

Aurora PostgreSQL supports db.t3 DB instance classes

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

June 20, 2019

Support for importing data from Amazon S3 for Aurora PostgreSQL

You can now import data from an Amazon S3 file into a table in an Aurora PostgreSQL DB cluster. For more information, see Importing Amazon S3 data into an Aurora PostgreSQL DB cluster.

June 19, 2019

Aurora PostgreSQL now provides fast failover recovery with cluster cache management

Aurora PostgreSQL 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.

June 11, 2019

Data API for Aurora Serverless v1 generally available

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

May 30, 2019

Aurora PostgreSQL supports database monitoring with database activity streams

Aurora PostgreSQL now includes database activity streams, which provide a near-real-time data stream of the database activity in your relational database. For more information, see Using database activity streams.

May 30, 2019

Amazon Aurora recommendations

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

May 22, 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

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 v1

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

April 29, 2019

Aurora Serverless v1 timeout action

You can now specify the action to take when an Aurora Serverless v1 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 v1 snapshots across AWS Regions

With Aurora Serverless v1, snapshots are always encrypted. If you encrypt the snapshot with your own AWS KMS key, you can now copy or share the snapshot across AWS Regions. For information about snapshots of Aurora Serverless v1 DB clusters, see Aurora Serverless v1 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

Sharing Aurora Serverless v1 snapshots across regions

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

April 16, 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

Aurora Serverless v1 supports restoring from an Amazon S3 backup

You can now import backups from Amazon S3 to an Aurora Serverless cluster. For details about that procedure, see Migrating data from MySQL by using an Amazon S3 bucket.

April 16, 2019

New modifiable parameters for Aurora Serverless v1

You can now modify the following DB parameters for an Aurora Serverless v1 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 v1 clusters, see Aurora Serverless v1 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 v1 logs to Amazon CloudWatch

You can now have Aurora upload database logs to CloudWatch for an Aurora Serverless v1 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

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 database

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 database.

November 28, 2018

Query plan management in Aurora PostgreSQL

Aurora PostgreSQL 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 v1 (beta)

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

November 20, 2018

Data API for Aurora Serverless v1 (beta)

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

November 20, 2018

TLS support for Aurora Serverless v1

Aurora Serverless v1 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 PostgreSQL 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 cluster.

September 26, 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

New guide

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

August 31, 2018