AWS Database Blog

Right-size Amazon RDS instances at scale based on Oracle performance metrics

Enterprise customers who are currently running on-premises, mission-critical applications on commercial databases are looking for cost-efficient, managed database service offerings. Amazon RDS is one of the target platforms for the relational database workload migration. RDS provides resizable capacity and manages time-consuming and undifferentiated heavy lifting administration tasks. For large-scale database migrations, there is a need […]

Build a real-time gaming leaderboard with Amazon ElastiCache for Redis

April 2024: This post was reviewed and updated for accuracy. Gaming leaderboards enable players to gauge their performance against each other. This important social feature increases players’ engagement and encourages competition. Leaderboard data can also inform in-game algorithms that match players against competitors of similar skill levels. In this post, I explore the challenges around […]

Transform data with AWS DMS version 3.1.3

AWS now supports new data transformation capabilities in the latest AWS Database Migration Service (AWS DMS) version 3.1.3. You can change schema, table, and column names; specify individual tablespace names for Oracle targets; and update a table’s primary and unique key on any target. DMS version 3.1.3 supports the following new data transformation capabilities: Explicit table […]

Configure Amazon ElastiCache for Redis for higher availability

This post was updated 3/10/2021 to include additional features and enhancements to Amazon ElastiCache for Redis. Amazon ElastiCache has become synonymous with real-time applications. Redis’ high performance, simplicity, and support for diverse data structures have made it one of the most popular non-relational key value stores. With the growth of business-critical, real-time use cases on […]

Improve Business Continuity with Amazon Aurora Global Database

As your business grows increasingly global, your database needs similarly expand. Resources must be just as available to your team in Zurich as they are to your office in Beijing, with the same speed, security, and ease of access. Amazon Aurora Global Database expands your Amazon Aurora database across the planet. Aurora builds its storage volumes […]

Optimize Amazon DynamoDB scan latency through schema design

In this post, we demonstrate how Amazon DynamoDB table structure can affect scan performance and offer techniques for optimizing table scan times. Amazon DynamoDB is a NoSQL database that allows for a flexible schema. This means that items in the same table may differ from each other in terms of what attributes are present for each […]

Python code to download DMS Task Logs using the AWS DMS Task ID

With AWS Database Migration Service (AWS DMS), you can migrate databases to AWS quickly and securely. In this post, we walk through the sample Python code required to download AWS DMS task logs on to your local computer using the AWS DMS task ID. Overview The DMS task logs contain task information logged during the […]

Build a Modern Application with Purpose-Built AWS Databases

In this blog post, we discuss AWS purpose-built databases and how to use them to create rich experiences for your customers. We also walk through a detailed example of these databases powering different experiences in an application, and provide the tools you need to spin up the app for yourself in minutes.

Migrating mission-critical SaaS production workloads to Aurora MySQL from RDS Classic

Sumo Logic started around the same time as the AWS stack was starting to mature. The company initially chose infrastructure that was tried and tested, but also cutting-edge at the time, namely Amazon RDS for MySQL instances. However, over time, that choice started to cost us a significant number of developer hours. Developers spent time […]