AWS Database Blog

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 […]

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 […]

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

October 2024: This post was reviewed for accuracy. Additional guidance was added about the trade-offs between high and low timeout settings. 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 […]

Running highly available Microsoft SQL Server containers in Amazon EKS with Portworx cloud native storage

In this blog post, we explain the deployment of Microsoft SQL Server on containers using Amazon Elastic Container Service for Kubernetes (Amazon EKS). The same approach and principles discussed here also apply to any other stateful application that needs high availability (HA) and durability combined with a reusable and repeatable DevOps practice. Example use cases […]

Analyze URL paths to search individual elements in Amazon Elasticsearch Service

September 8, 2021: Amazon Elasticsearch Service has been renamed to Amazon OpenSearch Service. See details. If you’re building a data lake in the AWS cloud, you’ll most likely want to have metadata and catalog search capability for the underlying data. We recommend Amazon Elasticsearch Service (Amazon ES) for storing and searching S3 keys, and S3 […]

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 […]

Sharding with Amazon Relational Database Service

  Sharding, also known as horizontal partitioning, is a popular scale-out approach for relational databases. Amazon Relational Database Service (Amazon RDS) is a managed relational database service that provides great features to make sharding easy to use in the cloud. In this post, I describe how to use Amazon RDS to implement a sharded database […]

Boosting application performance and reducing costs with Amazon ElastiCache for Redis

Contributed by Senior Software Development Engineer, Shawn Wang, Software Development Engineer, Maddy Olson, and Senior Manager, Software Engineering, Itay Maoz. Amazon ElastiCache for Redis helps customers achieve extreme performance with very low latencies at cloud scale and minimal management costs. Redis’s high performance, simplicity, and support for diverse data structures have made it the most […]

How to design Amazon DynamoDB global secondary indexes

Back in college, I created entity-relationship diagrams to model the system requirements of a relational database. The process involved finding all of the entities of the software system and defining relationships among them. I then modeled the relationships and entities into database tables before deciding which queries the database had to support. This method of […]