AWS Database Blog
Recap of Amazon RDS and Aurora features launched in 2019
Updated 04/2022 to reflect product changes.
Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. It provides cost-efficient and resizable capacity. At the same time, it automates time-consuming administration tasks such as hardware provisioning, database setup, patching, and backups. It frees you to focus on your applications so you can give them the fast performance, high availability, security, and compatibility they need.
Moving self-managed databases to managed database services is the new norm, and we’re continuing to add features to Amazon RDS at a rapid pace. 2019 was a busy year, so let’s do a recap of the features launched across the different database engines.
Amazon RDS first launched back in October of 2009, over 10 years ago! We started with Amazon RDS for MySQL; since then we’ve reached a total of seven database engine options: Amazon Aurora MySQL, Amazon Aurora PostgreSQL, PostgreSQL, MySQL, MariaDB, Oracle Database, and Microsoft SQL Server.
In 2019, we launched over 100 features across all Amazon RDS and Aurora database engines. For a quick reference, visit the 2018 recap, and the 2017 recap. We’ll start by covering each database engine and the key releases that we think will have the biggest impact on your database strategy and operations. We then list all of the features that we launched in 2019, categorized for convenience:
- New instance types, Regions, and versions– Providing you with a variety of database deployment options
- Manageability – Simplifying database management and providing expert recommendations
- Developer productivity – Enabling builders to focus on tasks meaningful to the business
- Performance – Improving database performance and scale to meet the application’s needs
- Availability/Disaster Recovery – Deploying highly available databases across Availability Zones and AWS Regions
- Security – Facilitating secure database operation
Key feature launches of 2019
Amazon Aurora MySQL
Aurora Global Database, originally launched at re:Invent 2018, expands your database into multiple Regions for disaster recovery and faster global reads. In 2019, this feature gained support for up to five secondary Regions, MySQL 5.7, and in-place upgrades from single-region databases.
The other two key features that we launched for Aurora MySQL in 2019 were Aurora Multi-Master and Aurora Machine Learning. Aurora Multi-Master increases availability by enabling you to create multiple read/write instances of your Aurora database across multiple Availability Zones. Aurora Machine Learning lets you add machine learning (ML) based predictions to your applications directly in your SQL queries. Read more on the AWS News Blog.
Amazon Aurora PostgreSQL
For Aurora PostgreSQL, we announced support for Serverless, where the database automatically starts up, shuts down, and scales capacity up or down based on your application’s needs. Aurora Serverless benefits use cases such as infrequently used applications, new applications, variable workloads, unpredictable workloads, development and test databases, and multi-tenant applications. We also launched support for Logical Replication using PostgreSQL replication slots, enabling you to use the same logical replication tools that they use with RDS for PostgreSQL. We launched support for Database Activity Streams to provide detailed auditing information in an encrypted JSON stream, Cluster Cache Management to resume the previous database performance after a failover, S3 import to make it easy and fast to load data from CSV files (S3 export was added in early 2020), export of logs to CloudWatch to make it easy to monitor PostgreSQL logs, support for PostgreSQL version 11 to give you access to the latest features from the PostgreSQL community, and FedRAMP HIGH compliance.
Amazon RDS for Oracle
We improved availability and disaster recovery by launching In-Region and Cross-Region Read Replicas using Oracle Active Data Guard. With read replicas, you can easily create up to five fully managed Oracle Active Data Guard standby databases that can be used for read scaling and offloading of long-running analytical queries. You can create read replicas in the same Region or a different Region from the primary instance, and replicas can be promoted into full read/write databases for disaster recovery purposes.
Last year, we also simplified migrations to RDS for Oracle with Amazon S3 Integration for Data Ingress and Egress Capabilities. With the S3 Integration option, you can easily set up fast and secure file transfer between an Amazon RDS for Oracle instance and Amazon Simple Storage Service (S3), significantly reducing the complexity of loading and unloading data.
Amazon RDS for SQL Server
By increasing the maximum number of databases per database instance from 30 to 100, we enable you to further consolidate database instances to save on costs.
Another exciting enhancement was around migrations. When some of our customers perform Native Backups and Restores when migrating to RDS SQL Server, they sometimes experience longer downtime during the final stages of the migration process than they would prefer. With support for Native Differential and Log Backups in conjunction with Full Native Backups, you can reduce downtime to as little as 5 minutes.
Last but not least, we launched Always On Availability Groups for SQL Server 2017 Enterprise Edition. With Always On, we also launched the Always On Listener Endpoint, which supports faster failover times.
Releases across multiple Amazon RDS database engines
For simplified single sign-on, you can use Microsoft Active Directory (AD) via AWS Managed Active Directory Service for Amazon RDS PostgreSQL, RDS Oracle, and RDS MySQL (AD is also supported on SQL Server, and was launched on MySQL in early 2020). Now you can use the same AD for different VPCs within the same AWS Region. You can also join instances to a shared Active Directory domain owned by different accounts.
Lastly, we announced the public preview of Amazon RDS Proxy for Amazon RDS MySQL and Aurora MySQL. As its name implies, Amazon RDS Proxy sits between your application and its database to pool and share database connections, improving database efficiency and application scalability. In case of a database failover, Amazon RDS Proxy automatically connects to a standby database instance while preserving connections from your application and reducing failover times for Amazon RDS and Aurora Multi-AZ databases by up to 66%. Lastly, database credentials and access can be managed through AWS Secrets Manager and AWS Identity and Access Management (IAM), eliminating the need to embed database credentials in application code. Support for Amazon RDS for PostgreSQL and Amazon Aurora with PostgreSQL compatibility is coming soon. You can learn more by reading Using Amazon RDS Proxy with AWS Lambda.
Features by database engine
Amazon Aurora MySQL
New instances types, Regions, and versions
- Launched the T3, and R5 instance family
- Launched support for R5.8xl, R5.16xl, and R5.24xl instances
- Available in the AWS Americas (São Paulo) Region
- Aurora Global Database Expands Availability to 14 AWS Regions
- Amazon Aurora Serverless with MySQL Compatibility available in AWS China (Ningxia) Region, Operated by NWCD
- Expanded List of Supported Features to Improve Performance and Manageability
Manageability
- Key 2019 launch: Multi-Master is Generally Available
- Aurora Serverless Supports Capacity of 1 Unit and a New Scaling Option
- Support for Cloning Across AWS Accounts
- Support for Cost Allocation Tags for Aurora Storage
- Support for GTID-Based Replication for MySQL 5.7
Developer productivity
- Key 2019 launch: Aurora Supports Machine Learning Directly from the Database
- Amazon Aurora Serverless MySQL 5.6 Now Supports Data API
- Faster Migration from MySQL 5.7 Databases to Amazon Aurora for MySQL
- Amazon RDS Recommendations Provide Best Practice Guidance for Amazon Aurora
Performance
Availability/Disaster Recovery
- Aurora Global Database is Supported on Aurora MySQL 5.7
- Aurora Global Database Supports Multiple Secondary Regions
- Aurora Supports In-Place Conversion to Global Database
- Amazon Aurora Serverless Supports Sharing and Cross-Region Copying of Snapshots
- Support for Zero-Downtime Patching
Security
- Aurora Serverless Publishes Logs to Amazon CloudWatch
- Aurora Serverless Clusters can Launch in a Shared VPC
- Aurora is FedRAMP-High Compliant on AWS GovCloud (US)
Amazon Aurora PostgreSQL
New instances types, Regions, and versions
- Aurora PostgreSQL 2.2, compatible with PostgreSQL 10.6
- Aurora PostgreSQL 2.3, compatible with PostgreSQL 10.7
- Aurora PostgreSQL 3.0, compatible with PostgreSQL 11.4
- Available in the AWS Americas (São Paulo) Region
- Support for R5, and Medium Instance Types
Manageability
- Copy Tags from an Aurora PostgreSQL Cluster to a Database Snapshot
- Aurora Supports Cost Allocation Tags for Aurora Storage
- Support for Cloning Across AWS Accounts
- Aurora Serverless Now Supports Data API
Developer productivity
- Key 2019 launch: Amazon Aurora with PostgreSQL Compatibility Supports Logical Replication
- Amazon RDS Recommendations Provide Best Practice Guidance for Amazon Aurora
- Support for Data Import from Amazon S3
Performance
Availability/Disaster Recovery
- Key 2019 launch: Support for AuroraPostgreSQL Serverless
Security
- Database Activity Streams for Real-time Monitoring
- Restore an Encrypted Aurora PostgreSQL Database from an Unencrypted Snapshot
- FedRAMP-High Compliant on AWS GovCloud (US)
- Aurora Serverless Clusters can Launch in a Shared VPC
- Publishing PostgreSQL Log Files to Amazon CloudWatch Logs
Amazon RDS for MySQL/MariaDB
New Instances Types, Regions, and Versions
- MySQL and MariaDB Support the R5 and T3 Instance Types
- Support for MySQL Versions 5.7.25, 5.7.24, and MariaDB Version 10.2.21
- Compatibility Checks for Upgrades from MySQL 5.7 to MySQL 8.0
- MySQL Support for Minor Version 8.0.16
Manageability
Developer productivity
- Key 2019 launch: Introducing Amazon RDS Proxy (Preview)
Performance
- Amazon RDS for MySQL and Maria DB increases maximum storage size to 64 TiB and maximum I/O performance to 80,000 IOPS
- Amazon Aurora and Amazon RDS Enable Faster Migration from MySQL 5.7 Databases
- Performance Insights is Generally Available on Amazon RDS for MariaDB
Security
Amazon RDS for PostgreSQL
New instances types, Regions, and versions
- PostgreSQL 11 now Supported in Amazon RDS
- Supports T3 Instance Types
- Support for Minor Versions 11.2, 10.7, 9.6.12, 9.5.16, and 9.4.21 and Minor Versions 11.4, 10.9, 9.6.14, 9.5.18, and 9.4.23
- Support for PostgreSQL 12 Beta 2 version in Preview
- Support for PostgreSQL 11 and Minor Versions 11.4, 10.9, 9.6.14, 9.5.18, and 9.4.23 AWS GovCloud (US) Regions
- Support for PG 12 Beta 3 in Preview
- Support for Minor Versions 11.5, 10.10, 9.6.15, 9.5.19, 9.4.24, adds Transportable Database Feature
- Support for Minor Versions 11.5 and 10.10, adds Transportable Database Feature in AWS GovCloud (US) Regions
Manageability
- Amazon RDS for PostgreSQL Supports Customer Initiated Snapshot Upgrades
- Amazon RDS for PostgreSQL Now Supports Multi Major Version Upgrades to PostgreSQL 11
Developer productivity
Performance
Security
- Key 2019 launch: Amazon RDS for PostgreSQL Supports User Authentication with Kerberos and Microsoft Active Directory
Amazon RDS for Oracle
New instances types, Regions, and versions
- Support for January 2019 Oracle Patch Set Updates (PSU) and Release Updates (RU), April PSU and RU, July 2019 PSU and RU
- Support for Oracle Database 18c and Oracle Database 19c
- Support for October 2019 Oracle Patch Set Updates (PSU) and Release Updates (RU)
- Support for SQLT Diagnostics Tool Version 12.2.180725
- Support for Oracle Application Express (APEX) Versions 18.1 and 18.2 and Version 19.1
- Support for Oracle Management Agent (OMA) version 13.3 for Oracle Enterprise Manager Cloud Control 13c
- Support for T3 and Z1d Instance Types
- Support for M5, T3, and R5 Instances Types are now available in the AWS China (Ningxia) Region, operated by NWCD, and the AWS China (Beijing) Region, operated by Sinnet
- Support for new Instance Sizes (R5/M5 8xl/16xl)
- Support for Z1d, X1, and X1e Instance Types in additional Regions
Manageability
Developer productivity
- Support for Oracle adds support to invoke EMCTL commands for Oracle Enterprise Manager Cloud Control
- Support for ALLOWED_LOGON_VERSION_SERVER and ALLOWED_LOGON_VERSION_CLIENT sqlnet.ora Parameters
Performance
- Amazon RDS for Oracle increases maximum storage size to 64 TiB and I/O performance to 80,000 IOPS
- Amazon RDS Performance Insights Supports SQL-level Metrics on Amazon RDS for Oracle
Availability/Disaster Recovery
- Key 2019 launch: Amazon RDS for Oracle Now Supports In-region Read Replicas with Active Data Guard for Read Scalability and Availability
- Key 2019 launch: Amazon RDS for Oracle Now Supports Managed Disaster Recovery and Data Proximity with Cross-region Read Replicas
Security
Amazon RDS for SQL Server
New instances types, Regions, and versions
- High Availability support in additional AWS Regions
- Supports for R5 and T3, X1, and X1e Instance Types
- Support for additional Instance Sizes (M5/R5 8xl/16xl)
Manageability
- Key 2019 launch: Increased the Database Limit Per Database Instance to up to 100
- Key 2019 launch: Support for Differential Restores and Log Restores
- Support for Multi-File Native Restores
- Supports changing the server-level collation
Developer productivity
Performance
Availability/Disaster Recovery
- Key 2019 launch: Support for Always On Availability Groups for SQL Server 2017
Security
Across Amazon RDS database engines
New instances types, Regions, and versions
Manageability
- Amazon RDS now supports per-second billing
- Amazon RDS now supports Storage Auto Scaling
- Amazon RDS Enables Detailed Backup Storage Billing
Performance
- Performance Insights Now Supports Counter Metrics on Amazon RDS for MySQL, RDS for PostgreSQL, Aurora MySQL, Amazon RDS for SQL Server, and Amazon RDS for Oracle
- Performance Insights Supports T2 and T3 Instance Types
Security
Summary
While the last 10 years have been extremely exciting, it is still Day 1 for our service and we are excited to keep innovating on behalf of our customers! If you haven’t tried Amazon RDS yet, you can try it for free via the Amazon RDS Free Tier. If you have any questions, feel free to comment on this blog post!
About the Authors
Justin Benton is a Sr Product Manager at Amazon Web Services.
Yoav Eilat is a Sr Product Manager at Amazon Web Services.