Read our blog for the latest insights on sales and marketing Take Me There

Webinar: Use Sugar Data to Easily Generate Complex Documents Register

Webinar: Advanced Calendar Solution for Sugar Register

Amazon RDS February 2020 Update

Released on February 26th, 2020

Amazon RDS Performance Insights Supports SQL-level Metrics on Amazon RDS for MySQL

Amazon RDS Performance Insights supports SQL-level metrics on Amazon RDS for MySQL databases so you can identify high-frequency, long-running, and stuck SQL queries in seconds.

Previously, gathering performance data on a database required configuration and maintenance of monitoring applications and related resources. Correlating performance data took hours without specialized expertise. To find a query of interest, such as a stuck or long-running SQL query, meant investigating each query one at a time.  

RDS Performance Insights allows non-experts to identify top SQL loads and from where they originated on a visual dashboard in seconds. Now, RDS Performance Insights also collects SQL-level metrics such as average latency, calls per second, and rows returned per call. You can determine if a SQL query takes too long to complete or if a particular SQL query is called at a different rate than you expect and then make improvements to your application such as optimizing a slow SQL query, adding an index to your database, and scaling your database. 

Amazon RDS Performance Insights is a database performance tuning and monitoring feature of RDS that allows you to visually assess the load on your database and determine when and where to take action. With one click in the Amazon RDS Management Console, you can add a fully managed performance monitoring solution to your Amazon RDS database. RDS Performance Insights is included with supported Amazon Aurora clusters and Amazon RDS instances and stores seven days of performance history in a rolling window at no additional cost. If you need longer-term retention, you can choose to pay for up to two years of performance history retention.  

For a complete list of regions where RDS Performance Insights is offered, see AWS Regions. To learn more about RDS Performance Insights and supported database engines, read the Amazon RDS User Guide.  

Amazon RDS Performance Insights Supports SQL-Level Metrics on Amazon RDS for MariaDB

Amazon RDS Performance Insights supports SQL-level metrics on Amazon RDS for MariaDB so you can identify high-frequency, long-running, and stuck SQL queries in seconds. 

Previously, gathering performance data on a database required configuration and maintenance of monitoring applications and related resources. Correlating performance data took hours without specialized expertise. To find a query of interest, such as a stuck or long-running SQL query, meant investigating each query one at a time.  

RDS Performance Insights allows non-experts and experts to identify top SQL loads and from where they originated on a visual dashboard in seconds. Now, RDS Performance Insights also collects SQL-level metrics such as average latency, calls per second, and rows returned per call. You can determine if a SQL query takes too long to complete or if a particular SQL query is called at a different rate than you expect and then make improvements to your application such as optimizing a slow SQL query, adding an index to your database, and scaling your database. 

Amazon RDS Performance Insights is a database performance tuning and monitoring feature of RDS that allows you to visually assess the load on your database and determine when and where to take action. With one click in the Amazon RDS Management Console, you can add a fully managed performance monitoring solution to your Amazon RDS database. RDS Performance Insights is included with supported Amazon Aurora clusters and Amazon RDS instances and stores seven days of performance history in a rolling window at no additional cost. If you need longer-term retention, you can choose to pay for up to two years of performance history retention.  

For a complete list of regions where RDS Performance Insights is offered, see AWS Regions. To learn more about RDS Performance Insights and supported database engines, read the Amazon RDS User Guide.  

Amazon RDS Data API Now Supports AWS PrivateLink

You can now use AWS PrivateLink to privately access Amazon RDS Data API for Aurora Serverless from your Amazon Virtual Private Cloud (Amazon VPC) without using public IPs, and without requiring the traffic to traverse across the Internet. You can now submit your SQL statements to Amazon RDS Data API without requiring an Internet Gateway in your VPC. AWS PrivateLink provides private connectivity between VPCs, AWS services, and on-premises applications, securely on the Amazon network. Amazon RDS Data API customers can now use private IP connectivity and security groups to meet their specific compliance requirements.  

RDS Data API enables you to focus on building your applications without worrying about managing database connections or connection pools. Instead, you can issue SQL commands against an Aurora Serverless cluster by simply invoking a secure API endpoint. Amazon RDS Data API uses HTTPS to communicate with your Aurora cluster and is secured via SSL and IAM authentication. With today’s launch, by using AWS PrivateLink you can execute SQL statements using the Data API, while significantly simplifying your internal network architecture. You no longer need to use an Internet Gateway, Network Address Translation (NAT) devices, or firewall proxies to connect to RDS Data API.

To use AWS PrivateLink, create an interface VPC endpoint for Data API for Aurora Serverless in your VPC using the Amazon VPC console, SDK, or CLI. You can also access the VPC endpoint from on-premises environments or from other VPCs using AWS VPN, AWS Direct Connect, or VPC Peering.

Amazon RDS Data API is available in US East (N. Virginia), US East (Ohio), US West (Oregon), Europe (Ireland), and Asia Pacific (Tokyo) Regions. To learn more, read the documentation, or get started in the AWS Console.  

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud, that combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open source databases. You can learn more about Amazon Aurora by visiting the product page.

Amazon RDS for PostgreSQL now Supports Additional Sizes for db.m5 and db.r5 Instance Classes

Starting today, Amazon RDS for PostgreSQL supports 8xlarge and 16xlarge sizes for db.m5 and db.r5 instance classes. With support for these new instance sizes, customers who are currently using m4.10xlarge, m4.16xlarge, r4.8xlarge, or r4.16xlarge now have an easy upgrade path to the latest generation of instances.  

M5 instances are the latest generation of general-purpose instances and provide improved performance over current generation M4 instances. The M5 instance family provides a balance of compute, memory, and network resources, and is a good choice for many database workloads.  

R5 instances are the latest generation of memory optimized instances that deliver 5% additional memory per vCPU and up to 20% increased CPU performance over R4 instances. R5 instances are well suited for running memory intensive database workloads. 

To get started, visit the AWS Management ConsoleAWS RDS Command Line Interface (CLI), and AWS RDS API. To learn more about pricing and regional availability, refer to the Amazon RDS for PostgreSQL pricing page

Amazon RDS for PostgreSQL Supports New Minor Versions 11.6, 10.11, 9.6.16, and 9.5.20

Following the announcement of updates to the PostgreSQL database, AWS has updated Amazon RDS for PostgreSQL to support PostgreSQL minor versions 11.6, 10.11, 9.6.16, and 9.5.20. This release contains bug fixes and improvements done by the PostgreSQL community. 

This release adds the PLProfiler extension, which allows you to create performance profiles of PL/pgSQL functions and stored procedures, and upgrades pgTap to version 1.1.0. This release also allows pg_prewarm in shared_preload_libraries for PostgreSQL 11 to automatically warm up the cache at startup of the database.

Amazon RDS for PostgreSQL makes it easy to set up, operate, and scale PostgreSQL deployments in the cloud. Learn more about upgrading your database instances from the Amazon RDS User Guide. See Amazon RDS for PostgreSQL Pricing for pricing details and regional availability.

Amazon RDS for Oracle now Supports Federal Information Processing Standard (FIPS) 140-2 for Secure Sockets Layer (SSL)

Amazon RDS for Oracle enables you to use the Federal Information Processing Standard (FIPS) 140-2 for the Secure Socket Layer (SSL). FIPS 140-2 is a U.S. government standard that defines cryptographic module security requirements.

You can enable FIPS.SSLFIPS_140 option setting for SSL option to configure the RDS Oracle DB instance to run in FIPS compliant mode. To use the FIPS.SSLFIPS_140 option setting, your Amazon RDS Oracle DB instance must be associated with an option group that includes the SSL option. You can set the option setting FIPS.SSLFIPS_140 to TRUE - to specify that the SSL connection uses only FIPS-verified cipher suites.

Amazon RDS makes it easy to set up, operate, and scale a relational database in the cloud. To learn more about using FIPS.SSLFIPS_140 on Amazon RDS for Oracle, please visit the documentation page for SSLFIPS_140.

Amazon RDS for Oracle now supports Oracle OLAP

Amazon RDS for Oracle now supports Oracle OLAP - a multidimensional analytic engine embedded in the Oracle Database Enterprise Edition. Oracle OLAP option provides SQL access to advanced analytics, and cube-organized materialized views to enhance the performance of business intelligence solutions.  

With its support for native SQL access to Oracle multidimensional objects and calculations, Oracle OLAP simplifies the development of dashboards, reports, business intelligence and analytical applications. And furthermore, since Oracle OLAP is embedded in the Oracle Database, it leverages the security, manageability, scalability and availability features of the Oracle Database Enterprise Edition. 

Amazon RDS for Oracle makes it easy to set up, operate, and scale Oracle Database deployments in the cloud. To learn more about using Oracle OLAP option on Amazon RDS for Oracle, please visit the documentation page. 

Amazon RDS for SQL Server Now Supports Joining a Domain Across AWS Accounts and VPCs using Managed Microsoft AD

Starting today, Amazon RDS for SQL Server supports joining DB instances to an AWS Managed Microsoft AD directory residing in a different AWS account or VPC. This makes it easier and cost-effective for you to deploy your directory-aware database workloads by reducing the manual configuration to domain join your DB instances and, the need to deploy directories in each account and VPC. Amazon RDS for SQL Server DB instances can now seamlessly join to a directory from any AWS account and any Amazon VPC within an AWS Region.

To join your Amazon RDS DB instances to a domain in a different account, share your AWS Managed Microsoft AD directory from the directory owner account and join the shared domain seamlessly using the AWS Management Console or CLI. Please refer to the Amazon RDS User Guide for more details.

Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server deployments in the cloud. See Amazon RDS for SQL Server Pricing for pricing details and regional availability.  

Amazon RDS for SQL Server now Supports Z1d Instances

Starting today, you can now launch Z1d instance types when using Amazon RDS for SQL Server in the following AWS Regions:

North America

  • US East (N. Virginia), US East (Ohio), US West (Oregon), and US West (N. California).

Europe, Middle East and Africa

  • EU (Ireland), EU (Frankfurt), and EU (London).

Asia Pacific

  • Asia Pacific (Mumbai), Asia Pacific (Seoul), Asia Pacific (Tokyo), Asia Pacific (Singapore), and Asia Pacific (Sydney).

Z1d instance types offer a combination of high compute performance and high memory which makes them ideally suited for relational database workloads with high per-core licensing costs. Z1d instances use the Nitro system, a rich collection of building blocks that enables high performance, high availability, and high security while also reducing virtualization overhead. 

Amazon RDS for SQL Server makes it easy to set up, operate, and scale SQL Server database deployments in the cloud. To get started, please visit the Amazon RDS for SQL Server user guide

For complete pricing and regional information, please visit the Amazon pricing page.

Amazon RDS for MariaDB Supports Minor Version 10.3.20

Amazon RDS for MariaDB has been updated to support release 10.3.20 of the MariaDB database. This release includes a number of bug fixes as well as functionality improvements.

To use the new version, you can create a new Amazon RDS database instance with just a few clicks in the Amazon RDS Management Console, or modify an existing instance using a point-and-click upgrade. See the documentation for more information about MariaDB versions and upgrade procedures.  

Amazon RDS for MariaDB makes it easy to set up, operate, and scale MariaDB deployments in the cloud. See Amazon RDS for MariaDB Pricing for regional availability.

Amazon RDS for Oracle now Supports January 2020 Oracle Patch Set Updates (PSU) and Release Updates (RU)

Amazon RDS for Oracle now supports the January 2020 Patch Set Updates (PSU) for Oracle Database 11.2 and 12.1, and January 2020 Release Update (RU) for Oracle Database 12.2, 18c and 19c.

Oracle PSUs contain bug fixes and other critical security updates. Beginning with Oracle Database version 12.2.0.1, Amazon RDS for Oracle supports Release Updates (RU) in place of the PSU. To learn more about the Oracle PSUs supported on Amazon RDS, please visit the Amazon RDS patch update documentation.  

Amazon RDS for Oracle makes it easy to set up, operate, and scale Oracle Database deployments in the cloud. See the Amazon RDS for Oracle Database Pricing page for complete regional availability information.  

« Back to Releases

Trustpilot