AWS Database Blog

Category: Database

Using Sort Keys to Organize Data in Amazon DynamoDB

It’s easy to start filling an Amazon DynamoDB table with data. However, without forethought about organizing your data, you can limit your data-retrieval options later. Data organization and planning for data retrieval are critical steps when designing a table. Without proper data organization, the only options for retrieving data are retrieval by partition key or […]

Read More

Your guide to Amazon DynamoDB sessions, workshops, and chalk talks at AWS re:Invent 2018

AWS re:Invent 2018 is almost here! This post includes a complete list of Amazon DynamoDB sessions, workshops, and chalk talks at AWS re:Invent 2018. Use the information on this page to help schedule your conference week in Las Vegas this year. If you still haven’t registered for re:Invent and need some help convincing your manager, consider […]

Read More

Tuning Amazon RDS for MySQL with Performance Insights

Amazon RDS Performance Insights brings an intuitive tuning interface to Amazon RDS to help you discover and investigate performance issues on your RDS databases. The look and feel of Performance Insights is the same across all database engine types, such as RDS for MySQL, RDS for PostgreSQL, and Amazon Aurora. However, every engine has a […]

Read More

Amazon DynamoDB highlights from the last 18 months you may have missed

Amazon DynamoDB is a nonrelational database that delivers reliable performance at any scale. It’s a fully managed, multiregion, multimaster database that provides consistent single-digit millisecond latency, and offers built-in security, backup and restore, and in-memory caching. This blog post recaps DynamoDB highlights from the last 18 months. Read this post to learn how to fuel your […]

Read More

Set alarms on Performance Insights metrics using Amazon CloudWatch

Amazon RDS Performance Insights recently released a feature that sends key performance metrics from Performance Insights to Amazon CloudWatch. Using this feature, you can set alerts on these metrics. When Performance Insights is enabled, it automatically sends the following three metrics to CloudWatch: DBLoad DBLoadCPU DBLoadNonCPU I describe these three metrics following. DBLoad The first […]

Read More

Migrate Apache Cassandra databases to Amazon DynamoDB more easily

Customers tell us that migrating data between different database engines—also known as a heterogeneous migration—can be challenging and time consuming. Some customers such as Samsung had to figure out on their own how to migrate their Apache Cassandra databases to Amazon DynamoDB (see Moving a Galaxy into the Cloud: Best Practices from Samsung on Migrating […]

Read More

Simplify Amazon DynamoDB data extraction and analysis by using AWS Glue and Amazon Athena

More than 100,000 AWS customers have chosen Amazon DynamoDB for mobile, web, gaming, ad tech, IoT, and many other applications. For example, Duolingo uses DynamoDB to store 31 billion items in tables that reach 24,000 read capacity units per second and 3,300 write capacity units per second. DynamoDB can address a wide variety of applications […]

Read More

Migrate to native partitioned tables in PostgreSQL 10 using AWS Database Migration Service

We’re excited to introduce AWS Database Migration Service (AWS DMS) version 2.4.3, which includes support for migrating data to native partitioned tables in PostgreSQL 10. In this post, we discuss how you can use AWS DMS version 2.4.3 to migrate data from Oracle partitioned tables to PostgreSQL 10 natively partitioned tables. You can do so […]

Read More