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 May 2019 Update

Released on May 30th, 2019

Amazon Aurora with PostgreSQL Compatibility Supports Database Activity Streams For Real-time Monitoring

Database Activity Streams for Amazon Aurora with PostgreSQL compatibility provides a near real-time data stream of the database activity in your relational database to help you monitor activity. When integrated with third party database activity monitoring tools, Database Activity Streams can monitor and audit database activity to provide safeguards for your database and help meet compliance and regulatory requirements.

Solutions built on top of Database Activity Streams can protect your database from internal and external threats by monitoring access to your database. The collection, transmission, storage, and subsequent processing of the database activity is managed outside your database providing access control independent of your database users. Your database activity is pushed to an Amazon Kinesis data stream that is provisioned on behalf of your Aurora Cluster.

Amazon RDS has partnered with IBM Security Guardium and McAfee's Data Center Security Suite (both available in AWS Marketplace) for a seamless integration with the Kinesis stream provisioned for your Aurora Cluster. These partner applications can use the database activity stream information to generate alerts and provide auditing of all activity on your Amazon Aurora databases.

You can learn more about using Database Activity Streams with Aurora PostgreSQL in the documentation and RDS Security pages.

Aurora combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open source databases. For more information, please visit the Amazon Aurora product page.

Amazon Aurora Serverless MySQL 5.6 Now Supports Data API

Amazon Aurora Serverless MySQL 5.6 can now be accessed using the built-in Data API enabling you to access Aurora Serverless with web services-based applications, including AWS LambdaAWS AppSync, and AWS Cloud9 

The Data API enables you to focus on building your applications without worrying about managing database connections or connection pools. Instead, you can now issue SQL commands against an Aurora Serverless cluster by simply invoking an API endpoint provided by the Data API and the Data API takes care of managing database connections and returning data.  

In addition, the Data API leverages database credentials stored in AWS Secrets Manager, eliminating the need to pass credentials in the API calls. For customers using AWS Lambda, the Data API provides a secure way to access your database without the additional overhead for Lambda functions to be launched in an Amazon VPC. Integration with the AWS SDK provides programmatic interface to execute SQL statements with parameters, transaction execution, and batch updates. For more information including instructions to get start with Data API, read the documentation

The Data API is available in US East (N. Virginia), US East (Ohio), US West (Oregon), Europe (Ireland), and Asia Pacific (Tokyo) Regions.

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 Recommendations Provide Best Practice Guidance for Amazon Aurora

The Amazon Relational Database Service (Amazon RDS) Recommendations feature now analyzes your Amazon Aurora configuration, usage, and performance data, and provides automated best practice guidance. In addition, Amazon RDS Recommendations suggests database parameter changes for all RDS engines.

Amazon RDS Recommendations cover a variety of common configuration issues such as outdated database engine versions, non-default security settings, and mismatched instance classes. First released in 2018, this feature now supports Aurora databases, including specific Aurora topics such as high availability settings.

This release also adds recommendations for specific parameters within DB Parameter Groups, across all Amazon RDS engines. For example, it will flag non-default custom memory parameters or query cache settings.

RDS Recommendations are presented in the Amazon RDS Management Console, and you can choose to apply, schedule, or dismiss them. For more information, read the Recommendations documentation for Amazon RDS and Amazon Aurora.

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

« Back to Releases