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

Webinar: Document Merge in wMobile Desktop for GoldMine Register

Amazon RDS November 2019 Update

Released on November 29th, 2019

Amazon Relational Database Service (RDS) Data API Client Library Supports Java (Preview)

You can use the Amazon Relational Database Service (Amazon RDS) Data API Client Library with support for Java, now available in preview, to quickly and easily build applications for Amazon Aurora Serverless.  

The Data API Client Library makes it easy to build applications with the Amazon RDS Data API, by providing support for data type translation and object mapping. You can use the Client Library to reduce the complexity of data type handling and write less code when invoking the Data API. For more information, including instructions on getting started with client library, read the documentation.

The 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 HTTPS API endpoint. To get started with Data API, read the documentation.  

The Data API client library preview is available in US East (N. Virginia), US East (Ohio), US West (Oregon), Europe (Ireland), and Asia Pacific (Tokyo) Regions. It supports both PostgreSQL-compatible and MySQL-compatible Aurora Serverless databases.

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 Minor Versions 11.5 and 10.10, adds Transportable Database Feature in Amazon RDS for AWS GovCloud (US) Regions

Amazon RDS now supports PostgreSQL minor versions 11.5 and 10.10 in the AWS GovCloud (US) Regions. Following the announcement of updates to the PostgreSQL database, Amazon has updated Amazon RDS for PostgreSQL to support PostgreSQL minor versions 11.5 and 10.10. This release contains cumulative fixes including an important security fix, bug fixes, and other improvements done by the PostgreSQL community.  

With this release, a new Transportable Database feature is added which allows a fast and convenient method of data import and export between databases. By using a new extension pg_transport, large databases can be quickly migrated between RDS for PostgreSQL instances. PostgreSQL Transportable Databases is available in RDS for PostgreSQL versions 10.10, 11.5, and newer. For more details about the feature, please refer to the documentation.  

Amazon has also added support for PostGIS 2.5 for all supported major versions. This enables multi major version upgrades to be performed with PostGIS extension, such as upgrading from 9.4.24 directly to 11.5 with PostGIS.  

The precheck process used while doing major version upgrades is also improved with this release. Previously, when customers perform major version upgrade, the precheck process scanned for incompatibilities across databases in the instance, but reported only the first issue it encountered. This caused customers to run the major version upgrade process more than once to fix all the incompatible issues and do a successful instance upgrade. The new enhanced precheck process scans for all potential compatibility issues across all databases in the instance and generates detailed, database-level logs. Customers can resolve all the issues based on the logs instead of retrying multiple times. To learn more about the major version upgrade paths and precheck feature, please refer to the documentation.  

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 Managed Disaster Recovery and Data Proximity with Cross-region Read Replicas

Starting today, Amazon Relational Database Service (RDS) for Oracle supports Cross-region Read Replicas with Oracle Active Data Guard. Amazon RDS for Oracle makes it easy to create physical standby DB instances in different AWS Regions from the primary DB instance. It fully manages the configuration of Active Data Guard, and replicates data over secured network connections between a primary DB instance and its replicas running across regions. 

The Cross-region Read Replicas feature enables managed disaster recovery capability for mission critical databases by allowing a read replica in another region be "promoted" as a new standalone production database. This feature also supports data proximity by enabling replicas be placed closer to the application users of a given region to reduce read latencies. Additionally, this feature allows Amazon RDS for Oracle customers to offload their read workload from the primary DB Instance, and also scale out read workloads over a farm of up to five read replicas that can reside in any region.  

The Cross-region Read Replicas feature is supported for Amazon RDS for Oracle customers who are using the Bring Your Own License model with Oracle Database Enterprise Edition and own a license for Oracle Active Data Guard.  

Amazon RDS for Oracle supports this feature for Oracle Enterprise Edition versions of 12.1 (starting from 12.1.0.2.v10) and higher. You can create Cross-region Read Replicas in all commercial regions where Amazon RDS for Oracle is available. 

A Read Replica is billed as a standard DB instance and at the same rates. Data transfer between the primary DB instance and the read replica DB instance across regions is billed based on the data transfer rates for the source and destination regions. See Amazon RDS for Oracle Pricing for up-to-date pricing of instances, storage, data transfer and regional availability.

Amazon RDS makes it easy to set up, operate, and scale a relational database in the cloud. To learn more about Cross-region Read Replicas, please visit the Amazon RDS for Oracle documentation page.  

Now Publish Log Files From Amazon RDS for SQL Server to Amazon CloudWatch

You can now publish logs from your Amazon RDS for SQL Server database to CloudWatch Logs. Supported logs include both agent logs and error Logs. Publishing these logs to CloudWatch allows you to maintain continuous visibility into database errors and activity. For example, Customers can set up CloudWatch Alarms to notify them on frequent restarts that are recorded in the error log. Similarly, Customers can create alarms for errors or warnings recorded in SQL Server Agent logs related to their SQL agent jobs.

CloudWatch Logs provide a durable archive destination for your database logs. You can specify a retention period to indicate how long you want CloudWatch to retain your logs. Additionally, with CloudWatch Logs, you can perform ad hoc searches across multiple logs. This capability is particularly useful for troubleshooting and log analysis.

Please refer to the documentation on RDS for SQL Server for more information. To start publishing logs from RDS for SQL Server databases to CloudWatch Logs, visit the AWS management console or download the latest AWS SDK or CLI

For complete information on pricing and regional availability, please refer to the Amazon RDS pricing page.

 Amazon RDS for SQL Server now Supports X1 and X1e Instance Types

Starting today you can now launch X1 and X1e instance types using Amazon RDS for SQL Server

X1 and X1e instances are part of the Amazon EC2 memory-optimized instance family and are designed for running large-scale and in-memory applications in the AWS Cloud. X1 instances offer up to 1,952 GiB of memory while X1e instances offer up to 3,904 GiB of memory. Both X1 and X1e instances are powered by four Intel® Xeon® E7 8880 v3 processors and offer up to 128 vCPUs. X1 instances offer up to 1,952 GiB of memory and 128 vCPUs, making them ideal for running in-memory databases. 

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 Amazon RDS User Guide.  

To learn more about X1 and X1e instances please visit the Amazon RDS instance types page

Amazon RDS for SQL Server Adds High Availability Support in Additional AWS Regions

Starting today, Amazon RDS for SQL Server now supports Multi-AZ deployments in the following AWS regions: Middle East (Bahrain), Asia Pacific (Hong Kong), EU (Stockholm) and China (Beijing).

Amazon RDS for SQL Server Multi-AZ is a high availability option which leverages either SQL Server Database Mirroring (DBM) or Always On Availability Groups (AGs), depending on your configuration. DBM and AGs meet the requirements of enterprise-grade production workloads running on SQL Server. The Multi-AZ deployment option provides enhanced availability, data durability and fault tolerance by automatically replicating database updates between two AWS Availability Zones. Availability Zones are physically separate locations with independent infrastructure engineered to be insulated from failures in other Availability Zones. 

When you create or modify your SQL Server database instance to run using Multi-AZ, Amazon RDS will automatically provision a primary database in one Availability Zone and maintain a synchronous "standby" replica in a different Availability Zone. In the event of planned database maintenance or unplanned service disruption, Amazon RDS will automatically fail over the primary SQL Server database to the up-to-date standby so that database operations can resume quickly without any manual intervention. 

To get started, please visit the Amazon RDS for SQL Server documentation. For pricing and complete regional availability, please refer the Amazon RDS for SQL Server Pricing page

Amazon RDS for SQL Server now Supports Differential Restores and Log Restores

Amazon RDS for SQL Server now supports differential restores and log restores on to an RDS SQL Server db instance. With this enhancement you can now migrate to RDS for SQL Server while significantly increasing the availability of your application during the migration process.

Depending on your business needs you can decide if you want to do log restores or just a full restore followed by a differential restore. To learn more about this enhancement please visit our documentation.

For complete information on pricing and regional availability, please refer to the Amazon RDS pricing page

Amazon RDS Performance Insights Supports SQL-level Metrics on Amazon Aurora with PostgreSQL Compatibility

Amazon RDS Performance Insights supports SQL-level metrics on Amazon Aurora with PostgreSQL-compatibility, a relational database built for the cloud. With RDS Performance Insights SQL-level metrics, 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 Oracle 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 for SQL Server now Supports Outbound Network Access

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

Amazon RDS for SQL Server now supports outbound network access removing the dependency for linked servers to be joined within a VPC. Linked servers can now have traffic configured from an RDS for SQL Server instance in AWS directing traffic to an on-premise or EC2 SQL Server instance.

To learn more about setting up linked servers on Amazon RDS for SQL Server please refer to this blog

For complete information on pricing and regional availability, please refer to the Amazon RDS pricing page.

Amazon RDS for Oracle now supports ALLOWED_LOGON_VERSION_SERVER and ALLOWED_LOGON_VERSION_CLIENT sqlnet.ora Parameters

Amazon RDS for Oracle now supports new customer modifiable sqlnet.ora parameters - ALLOWED_LOGON_VERSION_SERVER and ALLOWED_LOGON_VERSION_CLIENT.  

You can use the SQLNET.ALLOWED_LOGON_VERSION_SERVER parameter to set the minimum authentication protocol allowed when connecting to Amazon RDS for Oracle DB instances, and the SQLNET.ALLOWED_LOGON_VERSION_CLIENT parameter to set the minimum authentication protocol allowed for clients, and when a server is acting as a client, when connecting to Amazon RDS for Oracle DB instances. 

You can change the settings of the sqlnet.ora parameters as described in the Amazon RDS for Oracle documentation

Amazon RDS for Oracle makes it easy to set up, operate, and scale Oracle database deployments in the cloud. See Amazon RDS for Oracle Pricing for up-to-date pricing and regional availability. 

Amazon RDS for SQL Server now supports Additional Instance Sizes

Starting today, Amazon RDS for SQL Server db.m5 and db.r5 instance classes are available in 8xlarge and 16xlarge sizes. With support for these new instance sizes, customers who are currently using either 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 previous 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 including transaction processing, data warehousing, and analytics. 

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

To learn more about pricing and regional availability, refer to the Amazon RDS for SQL Server pricing page

Amazon RDS Performance Insights Supports Counter Metrics on Amazon RDS for SQL Server

Amazon RDS Performance Insights now supports counter metrics on Amazon RDS for SQL Server. With counter metrics, you can customize the RDS Performance Insights dashboard to include up to 10 additional graphs that show a selection from dozens of operating system and database performance metrics. Counter metrics provide additional information that can be correlated with the database load chart to help identify performance issues and analyze performance. 

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 for Oracle Z1d Instances are now Available in Additional Regions

Starting today, you can now launch Amazon RDS for Oracle Z1d instances in the following additional AWS regions:

  • US East (Ohio), EU (London), Asia Pacific (Seoul), and Asia Pacific (Mumbai).

Amazon RDS for Oracle Z1d instances were launched in June 2019. The combination of high compute performance and high memory makes Z1d instances ideal for relational database workloads with high per-core licensing costs. Z1d instances use the Nitro system, a combination of dedicated hardware and a lightweight hypervisor which delivers practically all of the compute and memory resources of the host hardware to your database instance. 

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

Amazon RDS for SQL Server now Supports R5 and T3 Instances Types

Starting today you can now launch R5 and T3 instance types when using Amazon RDS for SQL Server.  

Amazon EC2 R5 instance types are the next generation of memory optimized instances. R5 instances feature Intel Xeon Platinum 8000 series processors with a sustained all core frequency of up to 3.1 GHz, delivering up to 50% more vCPUs and 60% more memory as compared to R4 instances. With a 1:8 vCPU to memory ratio, R5 instances are ideally suited for high-performance databases, mid-size in-memory databases and other data warehousing and analytics applications. 

Amazon EC2 T3 instance types are the next generation of burstable general-purpose instances. T3 instances feature Intel Xeon Platinum 8000 series (Skylake-SP) processors with a sustained all core Turbo CPU clock speed of up to 3.1 GHz. With a balance of compute, memory, and network resources, T3 instances are well suited for small to medium sized database workloads. 

You can easily scale up to these new instance classes by modifying your existing DB instance in the AWS Management Console. Please refer to the Amazon RDS User Guide for more details.  

For complete information on pricing and regional availability, please refer to the Amazon RDS pricing page

Amazon RDS for PostgreSQL Supports Customer Initiated Snapshot Upgrades

Amazon RDS for PostgreSQL now enables you to perform minor and major version upgrades of PostgreSQL instance snapshots.  

Currently, both System and User Initiated snapshots are based on the engine version used by your Amazon RDS instance. The snapshots are immutable and can only be restored to the same version. This becomes a challenge if you have snapshots for PostgreSQL versions that are already out of support, such as PostgreSQL 9.3 or an older minor version. With this snapshot upgrade feature, you can now upgrade the engine version of user-initiated database snapshots to a higher supported version. 

You can also perform multi major version upgrades of your snapshots which can then be directly restored to the upgraded version, which greatly reduces major version upgrade time.  

To learn more about customer initiated snapshot upgrades, please refer to the Amazon RDS documentation.  

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 Oracle Database 19c

You can now launch Amazon RDS instances for Oracle Database 19c. 

Oracle Database 19c is the long term support release of the Oracle Database 12.2 family of products (terminal release for 12.2.0.1 and 18c/12.2.0.2). Oracle has announced support for 19c through 2023 for Premier Support customers, and through 2026 for customers who acquire Extended Support. Please refer to the Licensing and Support section of the Amazon RDS for Oracle FAQs for more details. 

To create a new Oracle Database 19c RDS instance with just a few clicks in the AWS Management Console, use the "Launch DB Instance" wizard and select the DB engine version "Oracle 19.0.0.0.ru-2019-07.rur-2019-07.r1" (contains the July 2019 Release Update). Amazon RDS for Oracle also supports major version upgrade from 11.2.0.4, 12.1.0.2, 12.2.0.1, and 18c to 19c. To upgrade your existing RDS for Oracle instances to 19c with just a few clicks from the "Modify DB Instance Wizard" in the AWS Management Console select the DB Engine version "19.0.0.0.ru-2019-07.rur-2019-07.r1". Refer to the upgrade documentation for details. 

Learn more by visiting the Amazon RDS for Oracle 19c feature overview and release notes. Please visit Amazon RDS for Oracle Pricing for complete regional availability information. 

PostgreSQL 12.0 Now Available in Amazon RDS Database Preview Environment

PostgreSQL 12.0 is now available in the Amazon RDS Database Preview Environment, allowing customers to test the initial version of PostgreSQL 12 on Amazon RDS

PostgreSQL 12.0 can now be deployed for development and testing in the Amazon RDS Database Preview Environment without the hassle of installing, provisioning, and managing the database software. This release includes support for 51 extensions including PostGIS 3.0.0alpha3, and also adds support for the wal2json and decoder_raw plugins for logical decoding. 

The PostgreSQL community released PostgreSQL 12.0 on October 3, 2019. PostgreSQL 12 includes improved functionality, performance, management of indexing, improved partitioning capabilities, JSON path queries per SQL/JSON specifications, nondeterministic collations which support case-insensitive and accent-insensitive comparisons for ICU provided collations, most common-value statistics for improved query plans, creation of generated columns that computes values with an expression, pluggable table storage interface, ability to enable/disable page checksums, and many additional features. 

The Amazon RDS Database Preview Environment now supports both Single-AZ and Multi-AZ deployments on the latest generation of instance classes (T3, M5 and R5) along with previous generation (T2, M4, and R4), and can be encrypted at rest using KMS keys. Amazon RDS Database Preview Environment database instances are retained for a maximum period of 60 days and are automatically deleted after the retention period. Amazon RDS database snapshots that are created in the preview environment can only be used to create or restore database instances within the preview environment. Customers can use standard PostgreSQL dump and load functionality to import or export their databases from the preview environment. 

Amazon RDS Database Preview Environment database instances are priced the same as production RDS instances created in the US East (Ohio) Region.

The Amazon RDS Database Preview Environment Forum is available for customers and the Amazon RDS team to share information and concerns about both the candidate versions of PostgreSQL 12 and the Amazon RDS Database Preview Environment. 

« Back to Releases

Trustpilot