HAQM Relational Database Service – Looking Back at 2017

The HAQM RDS team launched nearly 80 features in 2017. Some of them were covered in this blog, others on the AWS Database Blog, and the rest in What’s New or Forum posts. To wrap up my week, I thought it would be worthwhile to give you an organized recap. So here we go!

Certification & Security

• January – FedRAMP Certification for HAQM RDS for MySQL, Oracle, and PostgreSQL.
• February – Forced SSL Support for SQL Server.
• April – Access Management for MySQL and Aurora Using IAM.
• June – TDE Encrypted Cross-Region Snapshots for RDS SQL Server and Oracle.
• June – RDS Encryption at Rest for Additional T2 Instance Types.
• September – Migration of Encrypted RDS MySQL to Aurora.
• September – HIPAA Eligibility for RDS for SQL Server and RDS for MariaDB.

Features

• January – Advanced Auditing for HAQM Aurora.
• January – RDS MySQL to Aurora Replication in Same Region.
• January – Cross-Region Read Replicas of Encrypted Database Instances.
• January – Outbound Oracle Network Access Using Custom DNS Servers.
• March – Cross-Region Snapshot Copy, Cross-Region Replication, Cross-Account Snapshot Sharing for Aurora.
• April – Fast, Online DDL Processing for Aurora.
• May – Linux Huge Page Support for HAQM RDS for PostgreSQL.
• June – HAQM Aurora Select Into HAQM S3.
• June – Stopping and Starting of RDS Database Instances.
• June – HAQM Aurora Copy on Write Database Cloning.
• August – HAQM Aurora Fast Database Cloning.
• August – 16 TB Maximum Database Storage Size for SQL Server.
• September – Open Preview of Performance Insights for Aurora PostgreSQL.
• September – HAQM Aurora Audit Log Upload to CloudWatch Logs.
• October – Size Flexibility for HAQM RDS Reserved Instances.
• October – General Availability of HAQM Aurora with PostgreSQL Compatibility.
• October – HAQM Aurora for MySQL Asynchronous Key Prefetch.
• October – HAQM RDS For Oracle Support for Oracle SQLT Diagnostics Tool.
• November – Restore MySQL Backup to HAQM RDS MySQL Database.
• November – Auto Scaling for Aurora Replicas.
• November – Scaling of Storage Size for HAQM RDS for SQL Server.
• November – Up to 16 TB of Storage & Faster Scaling for HAQM RDS for MySQL, MariaDB, Oracle, and PostgreSQL.
• November – HAQM RDS for SQL Server Storage Reconfiguration on Snapshot Restore.
• November – HAQM RDS for PostgreSQL Support for the pgrouting and postrgresql-hll Extensions, HyperLogLog Data, and decoder_raw Module.
• December – Batched Scans and Hashed Joins for Aurora with MySQL Compatibility.

Engine Versions & Features

• January – MariaDB 10.0.28.
• April – Open Preview of Aurora for PostgreSQL.
• May – HAQM RDS Support for Versions 9.6.2, 9.5.6, 9.4.11 and 9.3.16 of PostgreSQL.
• May – Oracle Patch Set Upgrades (PSU) for April 2017.
• June – HAQM RDS Support for Versions 9.6.2, 9.5.6, 9.4.11, and 9.3.16 in the AWS GovCloud (US) Region.
• June – SQL Server 2016 Service Pack 1 (SP1).
• July – HAQM RDS for Oracle Supports HugePages.
• July – HAQM RDS for SQL Server Enterprise Edition with License Included in More Regions.
• July – Oracle SE2 License Included Available in AWS GovCloud (US).
• July – MariaDB 10.1.23 and 10.0.31.
• July – PostgreSQL 9.6.3, 9.5.7, 9.4.12, and 9.3.17.
• September – PostgreSQL 9.6.3, 9.5.7, 9.4.12, and 9.3.17 in AWS GovCloud (US).
• September – HAQM RDS for Oracle Support for Oracle APEX.
• September – HAQM RDS for Oracle Support for Oracle Multimedia, Spatial, and Locator Options.
• September – HAQM RDS for Oracle Support for Customer-Initiated Snapshot Upgrades for Deprecated Database Versions.
• November – HAQM RDS for Oracle Support for Oracle Enterprise Manager Cloud Control 13c1 and 13c2.
• November – PostgreSQL 9.6.5, 9.5.9, 9.4.14, and 9.3.19 in Commercial and AWS GovCloud (US).
• November – Oracle Patch Set Upgrades (PSU) for July 2017.
• November – SQL Server 2016 SP1 CU5 and SQL Server 2017.
• November – MariaDB 10.1.26 and 10.0.32.
• December – Oracle Patch Set Upgrades (PSU) for October 2017.

Regional Support

• March – Aurora in the US West (N. California) Region.
• June – Aurora in the Europe (Frankfurt) Region.
• July – Windows Authentication for RDS for SQL Server in More Regions.
• August – Multi-AZ for RDS SQL Server in the Europe (Frankfurt) Region.
• November – HAQM Aurora for PostgreSQL in the Canada (Central), Europe (Frankfurt), Asia Pacific (Sydney), and Asia Pacific (Mumbai) Regions.
• December – HAQM Aurora for PostgreSQL in the Europe (Paris) Region.

Instance Support

• March – Aurora on T2.Small Instances.
• June – RDS on M4 Instances in the São Paulo Region.
• October – HAQM RDS for Oracle on New R4, T2, and M4 Instance Types.
• October – HAQM Aurora on R4 Instances.
• November – HAQM RDS for MySQL and MariaDB on R4, T2, and M4 Instance Types.
• November – HAQM RDS for SQL Server on R4 and M4 Instance Types.
• December – HAQM RDS for PostgreSQL on R4, T2, and M4 Instance Types.

Price Reductions

• July – Price Reduction for R3 Instances running SQL Server Enterprise License Included.

And That’s a Wrap
I’m pretty sure that’s everything. As you can see, 2017 was quite the year! I can’t wait to see what the team delivers in 2018.

— Jeff;

Modified 08/12/2020 – In an effort to ensure a great experience, expired links in this post have been updated or removed from the original post.