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
Starting today, Amazon RDS for SQL Server now supports SQL Server Audit! SQL Server Audit lets you create server audits, which can contain server audit specifications for server level events, and database audit specifications for database level events.
You can now directly access the audits on the database instance and automatically send the audit log files directly to Amazon S3. To learn more about how to setup and configure SQL Server Audit please visit the Amazon RDS User Guide for more details.
Starting today, Amazon RDS for SQL Server supports up to a maximum of 100 databases per database instance. The Microsoft system databases, such as master and model, don’t count toward this limit.
Existing database instances can support up to 100 databases without any downtime. The new database limit is an increase from 30 databases and will depend on the instance class and availability type.
This increase allows you to consolidate databases into a single database instance and simplify database management. You can see the exact limits by instance size and availability type by referring to the Amazon RDS SQL Server User Guide.
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.
Starting today, you can create Amazon RDS for MariaDB, Amazon RDS for MySQL and Amazon RDS for PostgreSQL, database instances with up to 64 TiB of storage and provisioned I/O performance of up to 80,000 IOPS.
Existing database instances can also be scaled up to 64 TiB storage without any downtime. The new storage limit is an increase from 32 TiB and is supported for Provisioned IOPS and General Purpose SSD storage types. For instances using Provisioned IOPS SSD storage, Amazon RDS also supports increased performance of up to 80,000 IOPS.
This increase allows you to consolidate database shards into a single database instance and simplify database management. To learn more, please visit the Storage for Amazon RDS documentation page.
Amazon RDS makes it easy to set up, operate, and scale a relational database in the cloud. See Amazon RDS for MariaDB, Amazon RDS for MySQL and Amazon RDS for PostgreSQL pricing pages for regional availability.
You can now enforce password policies in your Amazon RDS for MySQL databases using the MySQL validate_password plugin. This improves the security of your databases by defining minimum password length, required characters, and other rules.
Password validation is available for RDS database instances running MySQL versions 5.6, 5.7, and 8.0. You configure the parameters in the DB parameter group used by the instance. For more information, see the Amazon RDS documentation.
Amazon RDS for MySQL makes it easy to set up, operate, and scale MySQL deployments in the cloud. See Amazon RDS for MySQL Pricing for regional availability.
Amazon RDS Performance Insights, a database performance tuning and monitoring feature that makes it easy to diagnose and solve performance issues on Amazon Relational Database Services (RDS), now supports additional counter metrics on Amazon RDS for Oracle in addition to RDS for MySQL, RDS for MariaDB, RDS for PostgreSQL, Aurora MySQL and Aurora PostgreSQL. With counter metrics, you can customize the 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 and analyze performance.
Here's an example of a Performance Insights dashboard showing a counter metric for user calls per second:
Performance Insights allows experts as well as non-experts to detect performance problems with an easy-to-understand dashboard that visualizes database load. It supports Amazon Aurora with PostgreSQL compatibility, Amazon Aurora with MySQL compatibility, Amazon RDS for PostgreSQL, MySQL, and Oracle, with additional database engines coming soon.
Following the announcement of updates to the PostgreSQL database, Amazon has updated Amazon RDS for PostgreSQL to support PostgreSQL minor versions 11,2, 10.7, 9.6.12, 9.5.16, and 9.4.21. This release contains bug fixes and improvements done by the PostgreSQL community.
With this release, a new extension pgTAP, a suite of database functions that make it easy to write unit tests in psql script, is added and supported with PostgreSQL version 11.2.
Further to the previous announcement about support for Amazon S3 Import for PostgreSQL version 11.1, this release adds Amazon S3 Import support with PostgreSQL 11.2, 10.7 and later versions.
Amazon previously announced support for Multi Major Version Upgrades to PostgreSQL 11. This release adds support for Multi Major Version Upgrades to PostgreSQL 10.7 and PostgreSQL 11.2. Please refer to the major version upgrade documentation on details around the PostgreSQL versions that are supported as source and target versions and also any limitations associated with the upgrade process.
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.