AWS Database Blog

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

Using Amazon EBS elastic volumes with Oracle databases (part 1): Introduction

Last year, we launched a new Amazon EBS feature called elastic volumes. Using elastic volumes for Amazon EBS, you can increase your EBS volume size or change IOPS or volume type while the volume is in use. You can make this change without having an impact on operations. In this series of three blog posts, […]

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

Replace SQL Server Agent Job with AWS Step Functions

If you’re migrating from Microsoft SQL Server to Amazon Aurora PostgreSQL, you might have discovered that the SQL agent jobs cannot be easily moved. The job agent tools are not supported for Aurora PostgreSQL. You can overcome this limitation though, by using AWS Step Functions to replace a SQL agent job. In this blog post […]

Read More

Monitor Amazon ElastiCache for Redis (cluster mode disabled) read replica endpoints using AWS Lambda, Amazon Route 53, and Amazon SNS

In Amazon ElastiCache for Redis, your applications use the provided endpoints to connect to an ElastiCache node or cluster. According to Amazon ElastiCache for Redis Components and Features in the ElastiCache for Redis User Guide, a multiple-node Redis (cluster mode disabled) cluster has two kinds of endpoints: “The primary endpoint always connects to the primary […]

Read More

Introducing the AWS Database Ready Program

Introducing the new AWS Database Ready Program, enabling software vendors to modernize their software to support Amazon Aurora. Customers are asking for cloud-native applications that take advantage of Amazon Aurora’s performance, availability and the simplicity of open source, but without the expense of commercial database licenses.

Read More

Replicate data from Amazon Aurora to Amazon S3 with AWS Database Migration Service

In this blog post, I’ll cover how to use an AWS CloudFormation template to automate the configuration that allows you to replicate data between a relational database like Amazon Aurora to Amazon Simple Storage Service (Amazon S3). I’ll walk you through a sample CloudFormation template so that you can customize for your needs. The AWS […]

Read More