Supported features in Amazon Aurora by AWS Region and Aurora DB engine
Aurora MySQL- and PostgreSQL-compatible database engines support several Amazon Aurora and Amazon RDS features and options. The support varies across specific versions of each database engine, and across AWS Regions. You can use the tables in this section to identify Aurora database engine version support and availability in a given AWS Region for the following features:
Topics
Some of these features are Aurora-only capabilities. For example, Aurora Serverless, Aurora global databases, and support for integration with AWS machine learning services aren't supported by Amazon RDS. Other features, such as Amazon RDS Proxy, are supported by both Amazon Aurora and Amazon RDS.
The tables use the following patterns to specify version numbers and level of support:
-
Version x.y – The specific version alone is supported.
-
Version x.y and later – The version and all minor versions are also supported. For example, "version 10.11 and later" means that versions 10.11, 10.11.1, and 10.12 are also supported.
-
- – The feature is not currently available for that particular Aurora feature for the given Aurora database engine, or in that specific AWS Region.
Backtracking in Aurora
By using backtracking in Aurora, you return the state of an Aurora cluster to a specific point in time, without restoring data from a backup. It completes within seconds, even for large databases. For more information, see Backtracking an Aurora DB cluster.
Aurora backtracking is available for Aurora MySQL only. It's not available for Aurora PostgreSQL.
| Region | Aurora MySQL 5.6 | Aurora MySQL 5.7 |
|---|---|---|
| US East (Ohio) | Version 5.6.10a | Version 2.06 and later |
| US East (N. Virginia) | Version 5.6.10a | Version 2.06 and later |
| US West (N. California) | Version 5.6.10a | Version 2.06 and later |
| US West (Oregon) | Version 5.6.10a | Version 2.06 and later |
| Africa (Cape Town) | - | - |
| Asia Pacific (Hong Kong) | - | - |
| Asia Pacific (Mumbai) | Version 5.6.10a | Version 2.06 and later |
| Asia Pacific (Osaka) | Version 5.6.10a; version 1.22 and later | Version 2.07.3 and later |
| Asia Pacific (Seoul) | Version 5.6.10a | Version 2.06 and later |
| Asia Pacific (Singapore) | Version 5.6.10a | Version 2.06 and later |
| Asia Pacific (Sydney) | Version 5.6.10a | Version 2.06 and later |
| Asia Pacific (Tokyo) | Version 5.6.10a | Version 2.06 and later |
| Canada (Central) | Version 5.6.10a | Version 2.06 and later |
| China (Beijing) | Version 5.6.10a | Version 2.06 and later |
| China (Ningxia) | - | - |
| Europe (Frankfurt) | Version 5.6.10a | Version 2.06 and later |
| Europe (Ireland) | Version 5.6.10a | Version 2.06 and later |
| Europe (London) | Version 5.6.10a | Version 2.06 and later |
| Europe (Milan) | - | - |
| Europe (Paris) | Version 5.6.10a | Version 2.06 and later |
| Europe (Stockholm) | - | - |
| Middle East (Bahrain) | - | - |
| South America (São Paulo) | - | - |
| AWS GovCloud (US-East) | - | - |
| AWS GovCloud (US-West) | - | - |
Aurora global databases
An Aurora global database is a single database that spans multiple AWS Regions, enabling low-latency global reads and disaster recovery from any Region-wide outage. It provides built-in fault tolerance for your deployment because the DB instance relies not on a single AWS Region, but upon multiple Regions and different Availability Zones.
Support for this feature varies by Aurora database engine and version. The following table shows the Regions and Aurora database versions that support this feature. For more information, see Using Amazon Aurora global databases.
| Region | Aurora MySQL 5.6 | Aurora MySQL 5.7 | Aurora PostgreSQL 10 | Aurora PostgreSQL 11 | Aurora PostgreSQL 12 |
|---|---|---|---|---|---|
| US East (Ohio) | Version 5.6.10a; version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.7 and later | Version 12.4 and later |
| US East (N. Virginia) | Version 5.6.10a; version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.7 and later | Version 12.4 and later |
| US West (N. California) | Version 5.6.10a; version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.7 and later | Version 12.4 and later |
| US West (Oregon) | Version 5.6.10a; version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.7 and later | Version 12.4 and later |
| Africa (Cape Town) | - | - | - | - | - |
| Asia Pacific (Hong Kong) | - | - | - | - | - |
| Asia Pacific (Mumbai) | Version 5.6.10a; Version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.7 and later | Version 12.4 and later |
| Asia Pacific (Osaka) | Version 1.22.3 and later | Version 2.07.3 and later | Version 10.12 and later | Version 11.7 and later | Version 12.4 and later |
| Asia Pacific (Seoul) | Version 5.6.10a; Version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.7 and later | Version 12.4 and later |
| Asia Pacific (Singapore) | Version 5.6.10a; Version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.7 and later | Version 12.4 and later |
| Asia Pacific (Sydney) | Version 5.6.10a; Version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.7 and later | Version 12.4 and later |
| Asia Pacific (Tokyo) | Version 5.6.10a; Version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.7 and later | Version 12.4 and later |
| Canada (Central) | Version 5.6.10a; Version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.7 and later | Version 12.4 and later |
| China (Beijing) | - | - | - | - | - |
| China (Ningxia) | - | - | - | - | - |
| Europe (Frankfurt) | Version 5.6.10a; Version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.7 and later | Version 12.4 and later |
| Europe (Ireland) | Version 5.6.10a; Version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.7 and later | Version 12.4 and later |
| Europe (London) | Version 5.6.10a; Version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.7 and later | Version 12.4 and later |
| Europe (Milan) | - | - | - | - | - |
| Europe (Paris) | Version 5.6.10a; Version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.7 and later | Version 12.4 and later |
| Europe (Stockholm) | Version 1.22.2 and later | Version 2.07.0 and later | Version 10.11 and later | Version 11.7 and later | Version 12.4 and later |
| Middle East (Bahrain) | - | - | - | - | - |
| South America (São Paulo) | Version 1.22.2 and later | Version 2.07.1 and later | Version 10.11 and later | Version 11.7 and later | Version 12.4 and later |
| AWS GovCloud (US-East) | - | - | - | - | - |
| AWS GovCloud (US-West) | - | - | - | - | - |
Aurora machine learning
Aurora machine learning provides simple, optimized, and secure integration between Aurora and AWS machine learning services without having to build custom integrations or move data around. Aurora exposes ML models as SQL functions, so you don't need to learn new programming languages or tools. Instead, you use standard SQL to build applications that call ML models, pass data to them, and return predictions as query results. For more information, see Using machine learning (ML) capabilities with Amazon Aurora.
| Region | Aurora MySQL 5.6 | Aurora MySQL 5.7 | Aurora PostgreSQL 10 | Aurora PostgreSQL 11 | Aurora PostgreSQL 12 |
|---|---|---|---|---|---|
| US East (Ohio) | - | Version 2.07 and later | Version 10.11 | Version 11.6 and later | Version 12.4 and later |
| US East (N. Virginia) | - | Version 2.07 and later | Version 10.11 | Version 11.6 and later | Version 12.4 and later |
| US West (N. California) | - | Version 2.07 and later (SageMaker only) | Version 10.11 (SageMaker only) | Version 11.6 and later (SageMaker only) | Version 12.4 and later (SageMaker only) |
| US West (Oregon) | - | Version 2.07 and later | Version 10.11 | Version 11.6 and later | Version 12.4 and later |
| Africa (Cape Town) | - | - | - | - | - |
| Asia Pacific (Hong Kong) | - | Version 2.07 and later (SageMaker only) | Version 10.11 | Version 11.6 and later | Version 12.4 and later |
| Asia Pacific (Mumbai) | - | Version 2.07 and later | Version 10.11 | Version 11.6 and later | Version 12.4 and later |
| Asia Pacific (Osaka) | - | Version 2.07.3 and later | Version 10.11 | Version 11.6 and later | Version 12.4 and later |
| Asia Pacific (Seoul) | - | Version 2.07 and later | Version 10.11 | Version 11.6 and later | Version 12.4 and later |
| Asia Pacific (Singapore) | - | Version 2.07 and later | Version 10.11 | Version 11.6 and later | Version 12.4 and later |
| Asia Pacific (Sydney) | - | Version 2.07 and later | Version 10.11 | Version 11.6 and later | Version 12.4 and later |
| Asia Pacific (Tokyo) | - | Version 2.07 and later | Version 10.11 | Version 11.6 and later | Version 12.4 and later |
| Canada (Central) | - | Version 2.07 and later | Version 10.11 | Version 11.6 and later | Version 12.4 and later |
| China (Beijing) | - | Version 2.07 and later (SageMaker only) | Version 10.11 (SageMaker only) | Version 11.6 and later (SageMaker only) | Version 12.4 and later |
| China (Ningxia) | - | Version 2.07 and later (SageMaker only) | Version 10.11 (SageMaker only) | Version 11.6 and later (SageMaker only) | Version 12.4 and later (SageMaker only) |
| Europe (Frankfurt) | - | Version 2.07 and later | Version 10.11 | Version 11.6 and later | Version 12.4 and later |
| Europe (Ireland) | - | Version 2.07 and later | Version 10.11 | Version 11.6 and later | Version 12.4 and later |
| Europe (London) | - | Version 2.07 and later | Version 10.11 | Version 11.6 and later | Version 12.4 and later |
| Europe (Milan) | - | - | - | - | - |
| Europe (Paris) | - | Version 2.07 and later (SageMaker only) | Version 10.11 (SageMaker only) | Version 11.6 and later (SageMaker only) | Version 12.4 and later |
| Europe (Stockholm) | - | Version 2.07 and later (SageMaker only) | Version 10.11 (SageMaker only) | Version 11.6 and later (SageMaker only) | Version 12.4 and later (SageMaker only) |
| Middle East (Bahrain) | - | Version 2.07 and later (SageMaker only) | Version 10.11 (SageMaker only) | Version 11.6 and later (SageMaker only) | Version 12.4 and later (SageMaker only) |
| South America (São Paulo) | - | Version 2.07 and later (SageMaker only) | Version 10.11 (SageMaker only) | Version 11.6 and later (SageMaker only) | Version 12.4 and later (SageMaker only) |
| AWS GovCloud (US-East) | - | Version 2.07 and later | Version 10.11 | Version 11.6 and later | Version 12.4 and later |
| AWS GovCloud (US-West) | - | Version 2.07 and later (SageMaker only) | Version 10.11 (SageMaker only) | Version 11.6 and later (SageMaker only) | Version 12.4 and later (SageMaker only) |
Aurora parallel queries
Aurora parallel queries can speed up your queries by up to two orders of magnitude, while maintaining high throughput for your core transactional workload. Using the unique Aurora architecture, parallel queries can push down and parallelize query processing across thousands of CPUs in the Aurora storage layer. By offloading analytical query processing to the Aurora storage layer, parallel queries reduce network, CPU, and buffer pool contention for transactional workloads. For more information, see Working with parallel query for Amazon Aurora MySQL. To learn more about Aurora MySQL versions available for parallel queries and any steps you might need to take based on that version to support parallel queries, see Planning for a parallel query cluster.
Aurora parallel queries are available for Aurora MySQL only. However, PostgreSQL has its own parallel query feature that is available on Amazon RDS. The capability is enabled by default when a new PostgreSQL instance is created (versions 10.1 and later). For more information, see PostgreSQL on Amazon RDS.
| Region | Aurora MySQL 5.6 | Aurora MySQL 5.7 |
|---|---|---|
| US East (Ohio) | Version 5.6.10a; version 1.19, 1.20, and 1.23 | Version 2.09 |
| US East (N. Virginia) | Version 5.6.10a; version 1.19, 1.20, 1.22, and 1.23 | Version 2.09 |
| US West (N. California) | Version 1.23 | Version 2.09 |
| US West (Oregon) | Version 5.6.10a; version 1.19, 1.20, 1.22, and 1.23 | Version 2.09 |
| Africa (Cape Town) | Version 1.23 | Version 2.09 |
| Asia Pacific (Hong Kong) | Version 1.23 | Version 2.09 |
| Asia Pacific (Mumbai) | Version 1.23 | Version 2.09 |
| Asia Pacific (Osaka) | Version 1.23.1 and later | Version 2.09.1 and later |
| Asia Pacific (Seoul) | Version 1.23 | Version 2.09 |
| Asia Pacific (Singapore) | Version 1.23 | Version 2.09 |
| Asia Pacific (Sydney) | Version 1.23 | Version 2.09 |
| Asia Pacific (Tokyo) | Version 5.6.10a; version 1.19, 1.20, 1.22, and 1.23 | Version 2.09 |
| Canada (Central) | Version 5.6.10a; version 1.23 | Version 2.09 |
| China (Beijing) | - | - |
| China (Ningxia) | - | - |
| Europe (Frankfurt) | Version 1.23 | Version 2.09 |
| Europe (Ireland) | Version 5.6.10a; version 1.19, 1.20, 1.22, and 1.23 | Version 2.09 |
| Europe (London) | Version 1.23 | Version 2.09 |
| Europe (Milan) | Version 1.23 | Version 2.09 |
| Europe (Paris) | Version 1.23 | Version 2.09 |
| Europe (Stockholm) | Version 1.23 | Version 2.09 |
| Middle East (Bahrain) | Version 1.23 | Version 2.09 |
| South America (São Paulo) | Version 1.23 | Version 2.09 |
| AWS GovCloud (US-East) | - | - |
| AWS GovCloud (US-West) | - | - |
Amazon RDS Proxy
Amazon RDS Proxy is a fully managed, highly available database proxy that makes applications more scalable by pooling and sharing established database connections. With RDS Proxy, failover times for Aurora are reduced by up to 66 percent. For more information, see Managing connections with Amazon RDS Proxy.
| Region | Aurora MySQL 5.6 | Aurora MySQL 5.7 | Aurora PostgreSQL 10 | Aurora PostgreSQL 11 |
|---|---|---|---|---|
| US East (Ohio) | Version 5.6.10a; version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.6 and later |
| US East (N. Virginia) | Version 5.6.10a; version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.6 and later |
| US West (N. California) | Version 5.6.10a; version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.6 and later |
| US West (Oregon) | Version 5.6.10a; version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.6 and later |
| Africa (Cape Town) | - | - | - | - |
| Asia Pacific (Hong Kong) | - | - | - | - |
| Asia Pacific (Mumbai) | Version 5.6.10a; version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.6 and later |
| Asia Pacific (Osaka) | - | - | - | - |
| Asia Pacific (Seoul) | Version 5.6.10a; version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.6 and later |
| Asia Pacific (Singapore) | Version 5.6.10a; version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.6 and later |
| Asia Pacific (Sydney) | Version 5.6.10a; version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.6 and later |
| Asia Pacific (Tokyo) | Version 5.6.10a; version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.6 and later |
| Canada (Central) | Version 5.6.10a; version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.6 and later |
| China (Beijing) | - | - | - | - |
| China (Ningxia) | - | - | - | - |
| Europe (Frankfurt) | Version 5.6.10a; version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.6 and later |
| Europe (Ireland) | Version 5.6.10a; version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.6 and later |
| Europe (London) | Version 5.6.10a; version 1.22 and later | Version 2.07 and later | Version 10.11 and later | Version 11.6 and later |
| Europe (Milan) | - | - | - | - |
| Europe (Paris) | - | - | - | - |
| Europe (Stockholm) | - | - | - | - |
| Middle East (Bahrain) | - | - | - | - |
| South America (São Paulo) | - | - | - | - |
| AWS GovCloud (US-East) | - | - | - | - |
| AWS GovCloud (US-West) | - | - | - | - |
Aurora Serverless v1
Aurora Serverless v1 is an on-demand, auto-scaling feature designed to be a cost-effective approach to running intermittent or unpredictable workloads on Amazon Aurora. It automatically starts up, shuts down, and scales capacity up or down, as needed by your applications. For more information, see Using Amazon Aurora Serverless v1.
| Region | Aurora MySQL 5.6 | Aurora MySQL 5.7 | Aurora PostgreSQL 10 | Aurora PostgreSQL 11 |
|---|---|---|---|---|
| US East (Ohio) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| US East (N. Virginia) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| US West (N. California) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| US West (Oregon) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Africa (Cape Town) | - | - | - | - |
| Asia Pacific (Hong Kong) | - | - | - | - |
| Asia Pacific (Mumbai) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Asia Pacific (Osaka) | - | - | - | - |
| Asia Pacific (Seoul) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Asia Pacific (Singapore) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Asia Pacific (Sydney) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Asia Pacific (Tokyo) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Canada (Central) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| China (Beijing) | - | - | - | - |
| China (Ningxia) | - | - | - | - |
| Europe (Frankfurt) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Europe (Ireland) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Europe (London) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Europe (Milan) | - | - | - | - |
| Europe (Paris) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Europe (Stockholm) | - | - | - | - |
| Middle East (Bahrain) | - | - | - | - |
| South America (São Paulo) | - | - | - | - |
| AWS GovCloud (US-East) | - | - | - | - |
| AWS GovCloud (US-West) | - | - | - | - |
Data API for Aurora Serverless
The Data API for Aurora Serverless provides a web-services interface to an Aurora Serverless cluster. Rather than managing database connections from client applications, you can run SQL commands against an HTTPS endpoint. For more information, see Using the Data API for Aurora Serverless.
| Region | Aurora MySQL 5.6 | Aurora MySQL 5.7 | Aurora PostgreSQL 10 | Aurora PostgreSQL 11 |
|---|---|---|---|---|
| US East (Ohio) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| US East (N. Virginia) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| US West (N. California) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| US West (Oregon) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Africa (Cape Town) | - | - | - | - |
| Asia Pacific (Hong Kong) | - | - | - | - |
| Asia Pacific (Mumbai) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Asia Pacific (Osaka) | - | - | - | - |
| Asia Pacific (Seoul) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Asia Pacific (Singapore) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Asia Pacific (Sydney) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Asia Pacific (Tokyo) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Canada (Central) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| China (Beijing) | - | - | - | - |
| China (Ningxia) | - | - | - | - |
| Europe (Frankfurt) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Europe (Ireland) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Europe (London) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Europe (Milan) | - | - | - | - |
| Europe (Paris) | Version 5.6.10a | Version 2.07.1 | Version 10.12 | - |
| Europe (Stockholm) | - | - | - | - |
| Middle East (Bahrain) | - | - | - | - |
| South America (São Paulo) | - | - | - | - |
| AWS GovCloud (US-East) | - | - | - | - |
| AWS GovCloud (US-West) | - | - | - | - |
