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 Aurora November 2019 Update

Released on November 25th, 2019

Aurora Global Database is Now Supported on Amazon Aurora MySQL 5.7

An Amazon Aurora Global Database is a single database that spans multiple AWS regions, enabling low latency global reads and disaster recovery from region-wide outages. With today’s launch, the feature is supported on the MySQL 5.7-compatible edition of Aurora. You can create a new Global Database cluster by adding a region to an existing MySQL 5.7 cluster.

Aurora Global Database replicates writes in the primary region with typical latency of <1 second to secondary regions, for low latency global reads. In disaster recovery situations, you can promote the secondary region to take full read-write responsibilities in under a minute.

Aurora Global Database is supported on Aurora MySQL engine release 2.07 and above. You can create a global cluster with just a few clicks in the Amazon RDS Management Console or download the latest AWS SDK or CLI. Read the Aurora documentation to learn more. 

Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to five times better throughput than standard MySQL together with increased scalability, durability, and security.

Amazon Aurora Supports Machine Learning Directly from the Database

You can now use Amazon Aurora to add machine learning (ML) based predictions to your applications, using a simple, optimized, and secure integration with Amazon SageMaker and Amazon Comprehend. Aurora machine learning is based on the familiar SQL programming language, so you don’t need to build custom integrations, move data around, learn separate tools, or have prior machine learning experience.  

Since Aurora makes direct calls to SageMaker and Comprehend that don’t go through the application layer, Aurora machine learning is suitable for low-latency, real-time use cases such as fraud detection, ad targeting, and product recommendations, where machine learning-based predictions need to be quickly made on large amounts of data. You can use any ML model available in SageMaker, or you can run sentiment analysis using Comprehend.

There’s no additional charge beyond the price of the AWS services that you are using. Aurora machine learning is available for Amazon Aurora with MySQL 5.7 compatibility; the SageMaker integration is generally available and the Comprehend integration is in preview. You can get started with just a few clicks by upgrading to the latest version of Aurora and giving your Aurora cluster access to SageMaker or Comprehend in the Amazon RDS Management Console. Read our blog, the Aurora ML feature page, and the Aurora documentation to learn more.

Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to five times better performance than the typical MySQL database and three times the performance of the typical PostgreSQL database, together with increased scalability, durability, and security. For more information, please visit the Amazon Aurora product page, and view the AWS Region Table for regional availability.

Amazon Aurora with MySQL and PostgreSQL Compatibility are now FedRAMP-High Compliant in AWS GovCloud (US)

Amazon Aurora with MySQL compatibility and Amazon Aurora with PostgreSQL compatibility in AWS GovCloud (US) Regions are now compliant with the Federal Risk and Authorization Management Program (FedRAMP) High baseline, which includes over 400 security controls. 

Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to five times better throughput than standard MySQL and up to three times better throughput than standard PostgreSQL, together with increased scalability, durability, and security. 

Learn more about AWS GovCloud (US) here or contact the AWS GovCloud (US) team with any questions. 

Amazon Aurora with PostgreSQL Compatibility Supports PostgreSQL 11.4

Following the recent announcement of updates to the PostgreSQL database, Amazon had  updated Amazon Aurora with PostgreSQL compatibility to support PostgreSQL version 11.4. PostgreSQL 11 includes major improvements to partitioning, improvements to parallelism, and many other useful performance improvements like adding columns with a non-null column default faster. This version includes SQL stored procedures that allow embedded transactions within a procedure.

With this releasepgaudit has been updated to 1.3.0, pg_hint_plan to 1.3.4, pglogical to 2.2.1, PLV8 to 2.3.8, PostGIS to 2.5.1, prefix to 1.2.8, and wal2json to hash 9e962ba. 

This release is available in the US East (N. Virginia), US East (Ohio), US West (Oregon), Asia Pacific (Seoul), Asia Pacific (Tokyo), and EU (Ireland) regions. For additional release details, see the Release Notes.

Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to three times better performance than the typical PostgreSQL database, together with increased scalability, durability, and security. 

Amazon Aurora MySQL 5.7 Now Supports Zero-Downtime Patching

Amazon Aurora zero-downtime patching (ZDP), which attempts to preserve client connections through an engine patch, is now supported on Aurora MySQL engine release 2.07 and above. When ZDP executes successfully, application sessions are preserved and the database engine restarts while patching. Read the Aurora documentation to learn more. 

Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to five times better throughput than standard MySQL together with increased scalability, durability, and security. 

Aurora Global Database Supports Multiple Secondary Regions

An Amazon Aurora Global Database is a single database that spans multiple AWS regions, enabling low latency global reads and disaster recovery from region-wide outages. With today’s launch, you can add as many as five secondary regions to your global cluster, expanding the reach of your database worldwide.

Aurora Global Database replicates writes in the primary region with typical latency of <1 second to secondary regions, for low latency global reads. For example, you may choose to run one database in different parts of the world to serve users in those regions. In disaster recovery situations, you can promote any secondary region to take full read-write responsibilities in under a minute.

Global Database with multiple secondary region support is available with Aurora MySQL engine version 1.22, compatible with MySQL 5.6, and with engine version 2.07, compatible with MySQL 5.7. Read the Aurora documentation to learn more. You can create an Aurora Global Database with just a few clicks in the Amazon RDS Management Console or download the latest AWS SDK or CLI.

Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to five times better throughput than standard MySQL and up to three times better throughput than standard PostgreSQL, together with increased scalability, durability, and security.

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 Aurora Now Supports Additional Instance Sizes

The MySQL-compatible edition of Amazon Aurora has added support for db.r5.8xl, db.r5.16xl, and db.r5.24xl instance sizes.

R5 instances are based on the Amazon EC2 Nitro System, a combination of dedicated hardware and a lightweight hypervisor that delivers practically all the compute and memory resources of the host hardware to your database instance. With a 1:8 vCPU to memory ratio, R5 instances are well suited for running memory-intensive database workloads such as transaction processing, data warehousing, and analytics.

These instances are generally available on Aurora MySQL version 1.22.0 (compatible with MySQL 5.6) and Aurora MySQL version 2.06 (compatible with MySQL 5.7) and above. You can create a new R5 instance, or modify your existing Aurora database instance to scale up to the new instance sizes, in the Amazon RDS Management Console or download the latest AWS SDK or CLI. For pricing and regional availability, see Amazon Aurora Pricing.

Amazon Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. It provides up to five times better performance than the typical MySQL database and three times the performance of the typical PostgreSQL database, together with increased scalability, durability, and security. For more information, please visit the Amazon Aurora product 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.  

« Back to Releases

Trustpilot