AWS Database Blog

Category: Advanced (300)

Upgrade Amazon Aurora MySQL-Compatible Edition version 1 (with MySQL 5.6 compatibility)

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

Automate schema version control and migration with Flyway and AWS Lambda on Amazon Aurora PostgreSQL

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

Recreate an Amazon RDS Custom for Oracle database: Part 2

End of support notice: On March 31, 2027, AWS will end support for Amazon RDS Custom for Oracle. Existing customers can continue using the service until March 31, 2027. After March 31, 2027, you will no longer be able to access RDS Custom for Oracle resources including database instances, snapshots, and custom engine versions. We […]

Make configuration changes to an Amazon RDS Custom for Oracle instance: Part 1

End of support notice: On March 31, 2027, AWS will end support for Amazon RDS Custom for Oracle. Existing customers can continue using the service until March 31, 2027. After March 31, 2027, you will no longer be able to access RDS Custom for Oracle resources including database instances, snapshots, and custom engine versions. We […]

Best practices to deploy Amazon Aurora databases with AWS CloudFormation

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

IPv6 addressing with Amazon RDS

We all have our own individual identity in this world. It may be a home address or unique ID card number. But have you ever considered how you are perceived online? Generalizing, have you ever considered how complex or large a system should be to accommodate all unique identifiers around the world, considering devices also […]

AWS Nitro Enclaves for secure blockchain key management: Part 3

In Part 1 of this series, we gave a high-level introduction to the AWS Nitro System and explained why Nitro is well suited for flexible and secure blockchain key management workloads. In Part 2, we guided you through the steps to configure aspects like AWS Key Management Service (AWS KMS) key policies and how to […]

AWS Nitro Enclaves for secure blockchain key management: Part 2

In Part 1 of this series, we provided a high-level introduction to the AWS Nitro System and explained why Nitro is well suited for flexible and secure blockchain key management workloads. In this post, we guide you through the steps to configure aspects like AWS Key Management Service (AWS KMS) key policies and how to […]

Access Amazon RDS across VPCs using AWS PrivateLink and Network Load Balancer

November 2024: This post was reviewed for accuracy. In this post, we provide a solution to access Amazon Relational Database Service (Amazon RDS) across AWS accounts and VPCs, without using VPC peering with Amazon Virtual Private Cloud (Amazon VPC) or AWS Transit Gateway. We use AWS PrivateLink and Network Load Balancer to redirect database traffic […]

Manage long-running read queries on Amazon Aurora PostgreSQL-Compatible Edition

An Amazon Aurora PostgreSQL-Compatible Edition cluster consists of a primary/writer node and up to 15 reader nodes in a Region. You may offload read-only workloads to reader nodes to scale-out reads. Long-running queries on reader nodes that are accessing tables with high transactional activities on the primary node can cause conflicts, and lead to undesirable […]