AWS Database Blog

Category: Database

Best practices for Amazon Aurora MySQL database configuration

After migrating or launching your new Amazon Aurora MySQL instance in the AWS Cloud, have you asked yourself one or more of the following questions? “What are the next steps? How can I make it run optimally?” “Is it recommended to modify any existing parameters?” “What parameters should I modify?” If so, I hope that […]

Read More

Amazon DynamoDB: Ad tech use cases and design patterns

Advertising technology (ad tech) companies use Amazon DynamoDB to store various kinds of marketing data, such as user profiles, user events, clicks, and visited links. Some of the uses include real-time bidding (RTB), ad targeting, and attribution. In this blog post, I identify the most common use cases and design patterns of ad tech companies […]

Read More

Using new aggregation pipeline capabilities in Amazon DocumentDB to build powerful aggregation queries

Amazon DocumentDB (with MongoDB compatibility) is a fast, scalable, highly available, and fully managed document database service that supports MongoDB workloads. You can use the same MongoDB application code, drivers, and tools as you do today to run, manage, and scale workloads on Amazon DocumentDB. This way, you can enjoy improved performance, scalability, and availability, […]

Read More

Applying best practices for securing sensitive data in Amazon RDS

In the first post of the series, I described some generic security concepts and corresponding AWS security controls that can be applied to data stores on AWS. Using these, you can create a stronger security posture around your data. In this second post, I demonstrate how these concepts can be implemented to Amazon RDS databases. […]

Read More

Amazon DynamoDB: Gaming use cases and design patterns

Gaming companies use Amazon DynamoDB in all parts of game platforms, including game state, player data, session history, and leaderboards. The main benefits that these companies get from DynamoDB are its ability to scale reliably to millions of concurrent users and requests while ensuring consistently low latency—measured in single-digit milliseconds. In addition, as a fully […]

Read More

How to determine whether Kaigen (Japan era name transition) affects your MySQL compatible engines running on RDS

If you have software or systems that support Japanese customers, and if your software or systems need to display a Japan era name, you may need to make changes to display the new name. The new Japan era name comes into effect on May 1, 2019, when the current Japanese Emperor abdicates. In this blog […]

Read More

Understanding Amazon DynamoDB encryption by using AWS Key Management Service and analysis of API calls with Amazon Athena

As applications evolve to be more scalable for the web, customers are adopting flexible data structures and database engines for their use cases. Using NoSQL data stores has become increasing popular because of NoSQL’s flexible data model for building modern applications. Amazon DynamoDB is a fast and flexible NoSQL database service that can provide consistent […]

Read More

Tuning AWS Java SDK HTTP request settings for latency-aware Amazon DynamoDB applications

Amazon DynamoDB is a NoSQL cloud database service that is designed to provide low-latency and high-throughput performance for applications and services running at scale. Example use cases include: Massively multiplayer online games (MMOGs) Virtual and augmented reality Checkout and order processing in ecommerce Real-time stock pricing and trading When you operate such systems globally, you […]

Read More

How to Scale AWS Database Migration Service (DMS) replication instances 

AWS Database Migration Service (DMS) helps you migrate databases to AWS quickly and securely. The AWS DMS migration process encompasses setting up a replication instance, source and target endpoints, and replication tasks. Your replication instance uses resources like CPU, memory, storage, and I/O, which may get constrained depending on the size of your instance and the […]

Read More