Category: Amazon Aurora

Keeping your database version up to date provides benefits like improved performance and security, access to new features, fixes to known issues, compliance with regulatory requirements, and more. However, there is also a risk of some queries experiencing performance regression following a database upgrade. This risk is higher with major version upgrades because they can […]

PostgreSQL is one of the most widely used database engines and is supported by a very large and active community. It’s a viable open-source option to use compared to many commercial databases, which require heavy license costs. Amazon Relational Database Service (Amazon RDS) for PostgreSQL and Amazon Aurora PostgreSQL-Compatible Edition are AWS managed offerings that […]

July 2023: This post was reviewed for accuracy. Amazon Relational Database Service (Amazon RDS) makes it easy to set up, operate, and scale a relational database in the cloud. A highly performant database is key to delivering latency SLAs, so monitoring is critical. Amazon CloudWatch is a monitoring and observability service built for DevOps engineers, […]

April, 2026: Aurora Serverless v2 has been renamed Aurora serverless. No action required. Important AWS has announced the end-of-life date for Aurora Serverless v1: March 31st, 2025. We strongly recommend upgrading any Aurora Serverless v1 DB clusters to Aurora Serverless v2 before that date. The upgrade can involve a change in the major version number […]

April, 2026: Aurora Serverless v2 has been renamed Aurora serverless. No action required. Join us at re:Invent 2020, a free 3-week virtual conference, from November 30 to December 18. This year’s virtual conference is going to be the industry event of the year, offering five keynotes, 18 leadership sessions, and unlimited access to hundreds of […]

July 2023: This post was reviewed for accuracy. At Amazon, we listen to our customers and work backward from your needs. Our AWS Database Specialist Solutions Architect team helps you architect your database landscape. In this post, we address 11 frequently asked questions with videos from our Database Specialist Solutions Architects. Let’s begin the learning […]

To migrate an Oracle database to Amazon Aurora with PostgreSQL compatibility, you usually need to perform both automated and manual tasks. The automated tasks involve schema conversion using AWS Schema Conversion Tool (AWS SCT) and data migration using AWS Database Migration Service (AWS DMS). The manual tasks involve post-AWS SCT migration touch-ups for certain database […]

This post shows how you can perform a major upgrade for Aurora MySQL with minimal downtime using a blue-green deployment. This is useful for database administrators or DevOps team members responsible for the Aurora MySQL upgrades.

January 2024: This post was reviewed and updated for accuracy. Amazon Aurora PostgreSQL-Compatible Edition combines the performance and availability of high-end commercial databases with the simplicity and cost-effectiveness of open-source databases. Aurora provides this by scaling storage across three Availability Zones in the same Region, and supports up to 15 read replica instances for scaling […]

Your organization may require you to connect to databases using secure SSL connections so all traffic communicating with the database is encrypted. In this post, we provide guidance on how to connect to an Amazon Aurora PostgreSQL database from a C++ application using the libpq library. We show you how to enforce SSL connections to your Aurora PostgreSQL database and connect to this from a C++ application using a secured SSL connection. You can also apply the same principles to an Amazon RDS for PostgreSQL database.