Category: Database

December 2022: This post was updated with support for blue/green deployments for Amazon RDS and Amazon Aurora. November 2022: This post was updated with changes introduced with the launch of Amazon Aurora MySQL-Compatible Edition versions 2 and 3, and in-place upgrade from version 2 to 3. Amazon Aurora MySQL-Compatible Edition version 1 (with MySQL 5.6 […]

Amazon Aurora is a relational database management system (RDBMS) built for the cloud with full MySQL and PostgreSQL compatibility. Aurora is designed to take advantage of the cloud in areas of scalability, availability, and durability, as well as combine the speed and reliability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. […]

Monthly releases are always hectic, and companies face challenges with SQL deployments and schema versioning. It’s very time-consuming when multiple developers are developing code and need to run multiple SQL files across multiple production databases. To maintain environment integrity and consistency across applications, code and schema changes need to sync across multiple non-production and production […]

In this series, we discuss best practices and step-by-step instructions to perform common customizations on Amazon Relational Database Service (Amazon RDS) Custom for Oracle without breaking the support perimeter: Part 1 covers customizing the time zone and character set of the database Part 2 (this post) discusses customizations such as changing the default block size, […]

Amazon Relational Database Service (Amazon RDS) Custom is a managed database service that provides the flexibility to customize your database, underlying server, and operating system configurations to support applications that require more control than a typical managed RDS provides. Amazon RDS Custom for Oracle is built for legacy, custom, packaged applications and any application that […]

Today marks the one-year anniversary of the launch of Amazon MemoryDB for Redis. On 8/19/2021, AWS announced the general availability of Amazon MemoryDB for Redis, a fully managed, Redis-compatible database, that delivers both in-memory performance and Multi-AZ durability. Over the past year, thousands of customers have adopted MemoryDB as their primary database for critical workloads […]

Today we’re launching new functionality that makes it easier for you to import data from Amazon Simple Storage Service (Amazon S3) into new DynamoDB tables. This is a fully managed feature that doesn’t require writing code or managing infrastructure. In this post, we introduce DynamoDB import from S3 and show you how to use it […]

Many organizations prefer infrastructure as code (IaC) for provisioning and maintaining IT infrastructure. With IaC, you can replicate DevOps practices for application code such as storing the infrastructure code in a source control system, automated testing, and automated deployment through a continuous integration and continuous delivery (CI/CD) pipeline. AWS CloudFormation is an IaC service that […]

This is a guest post by Alex DeBrie, an AWS Hero. For people learning about Amazon DynamoDB, the idea of single-table design is one of the most mind-bending concepts out there. Rather than the relational notion of having a table per entity, DynamoDB tables often include multiple different entities in a single table. You can […]

Amazon DocumentDB (with MongoDB compatibility) is a scalable, highly durable, and fully managed database service for operating mission-critical MongoDB workloads without having to worry about managing the underlying infrastructure. As a document database, Amazon DocumentDB makes it easy to store, query, and index JSON data. Amazon DocumentDB has added support for auditing Data Manipulation Language […]