AWS Beefs Up Database Services -- AWSInsider

AWS Beefs Up Database Services

By David Ramel
05/22/2019

Amid the steady stream of new cloud product and service announcements from Amazon Web Services Inc. (AWS), a number of database-themed items have recently come to light.

Data-related offerings abound in the AWS cloud, including: relational offerings such as Amazon Aurora (MySQL, PostgreSQL), Amazon RDS (MySQL, PostgreSQL, MariaDB, Oracle, SQL Server) and Amazon Redshift (data warehouse); the key-value Amazon DynamoDB (NoSQL); and document-oriented Amazon DocumentDB (with MongoDB compatibility).

Here's a capsule summation of recent data-related news, all published within the last week:

Amazon DocumentDB (with MongoDB compatibility) is now SOC 1, 2, and 3 compliant: "Amazon DocumentDB is now SOC 1, 2, and 3 compliant, allowing you to get deep insight into the security processes and controls that protect customer data. These reports are often leveraged by diverse industries, such as technology, healthcare, banking and financial services, and used for Sarbanes-Oxley (SOX) efforts." Read more here.
Amazon RDS for SQL Server Increases the Database Limit Per Database Instance up to 100: "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." Read more here.
Amazon RDS for MySQL, MariaDB and PostgreSQL increase maximum storage size to 64 TiB and I/O performance 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." Read more here.
Amazon DocumentDB (with MongoDB compatibility) now supports R5 instances in US East (N. Virginia), US East (Ohio), US West (Oregon), and EU (Ireland): "Amazon DocumentDB now supports R5 instances, the next generation of memory optimized instances, in US East (N. Virginia), US East (Ohio), US West (Oregon), and EU (Ireland). R5 instances provide up to 100% better performance over R4 instance for the same instance cost. As always, testing with your queries and data will give you the most accurate information about the improvements you’ll see for your workloads. With R5 instances, you can scale to r5.24xlarge instances that have 96 vCPU, 768 GiB of memory, and 25 Gbps network performance." Read more here.
Amazon RDS for Oracle now supports April Oracle Patch Set Updates (PSU) and Release Updates (RU): "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." Read more here.
Amazon RDS for MySQL Supports Password Validation: "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. Read more here.
AWS IoT Analytics Now Supports Data Set Content Delivery to Amazon S3: "You can now send IoT Analytics data set content results, which are materialized views of your IoT Analytics data, to an Amazon S3 bucket in your AWS account. This lets you easily use it with a downstream application for further processing or presentation to end-users. For example, you can automatically create a Glue Table containing a representation of your data set content results and its schema and run queries with Amazon Athena. Also, since the data set content results are saved in your Amazon S3 bucket, you can apply your own S3 permissions and manage them according to your governance policies." Read more here.