- Amazon DynamoDB Auto Scaling This fully managed cloud database is described as a “fast, flexible NoSQL service for any size” and provides both key-value and document store models with consistent, single-digit millisecond latency regardless of its scale. This service was redesigned to make it easier for users to manage the resources they use. Previously, this was done using a provisioned capacity model which allowed them to specify the read-write capacity required by applications. AWS has announced DynamoDB Auto Scaling to automate capacity management for users’ tables and global secondary indicles. This service is now being used for serverless computing jobs. In a blog post, spokesperson Jeff Barr stated that you simply need to specify the target utilization and set upper and lower limits for read and write capacities. “DynamoDB will monitor throughput consumption via Amazon CloudWatch alarms, and then adjust provisioned capacity as necessary. Auto Scaling will automatically be enabled for all new tables or indexes. You can also set it up for existing tables. DynamoDB Auto Scaling can monitor your tables and indexes to adjust throughput to respond to changes in traffic. This will make it easier for you to manage your DynamoDB data and increase availability for your applications. It can also help you reduce DynamoDB costs. Developers have two options to manage the service — which is now available in all regions — via a command-line interface or via APIs. This allows for control functionality such as the ability enable or disable scaling policies. The regular prices for DynamoDB apply to provisioned capacity.
- Expansion of the Schema Conversion tool AWS and other cloud providers strive to make it easier to import databases and data warehouses into their platforms. The Amazon cloud is a pioneer in such measures (see “AWS Data Warehouse Imports” & “AWS Database Migrating Service Now Available”). According to AWS, the AWS Schema Converter Tool (SCT), “makes heterogeneous data warehouse migrations simple by automatically converting a majority of custom code, including stored procedures and views, to a format compatible to the target database.” The tool’s goal is to make it easy to migrate proprietary commercial data warehouses and databases to cloud-based, open-source solutions. This includes: Source Database Target Database on Amazon RDS Oracle Database Amazon Aurora MySQL, PostgreSQL MariaDB Teradata Amazon Redshift IBM Netezza Amazon Redshift Greenplum Amazon Redshift HPE Vertica Amazon Redshift MySQL.
