AWS Database Blog

Category: Amazon Aurora

Configure Amazon Aurora PostgreSQL database activity streams for monitoring in IBM Guardium

In this post, we guide you through the steps to setting up Amazon Aurora PostgreSQL-Compatible Edition database activity streams (DAS) for monitoring in IBM Guardium. Here, we are using IBM Guardium version 11.5. Aurora PostgreSQL-Compatible is a fully managed, PostgreSQL-compatible, ACID-compliant relational database engine that combines the speed, reliability, and manageability of Amazon Aurora with […]

Introducing the Advanced JDBC Wrapper Driver for Amazon Aurora

Today’s modern applications are expected to be scalable and resilient. The top of this list is scalability, which depending on the size of the application workload could mean the ability to handle millions of users on demand. With stateful applications such as eCommerce, Financial Services and Games, this means having highly available databases. With the release of Amazon Aurora in 2015, customers could run relational databases in an Aurora cluster comprising of one writer and up to 15 low-latency reader nodes. This enables applications to scale reads significantly. However, as with any database supporting multiple instances, developers have built complex application logic to deal with special events such as switchover or failover.

Create custom PostgreSQL data types using Trusted Language Extensions

In this post, we demonstrate how to create custom PostgreSQL data types using TLE. PostgreSQL ships with many robust data types that accommodate most customer workloads in a performant manner. Although PostgreSQL has the capabilities to deploy custom data types natively, introducing new data types at scale in architectures spanning multiple AWS accounts and Regions poses a unique challenge for builders. With Trusted Language Extensions (TLE), you can create and manage your custom data types, allowing the quick and easy deployment of PostgreSQL data types across your infrastructures in a secure and efficient manner.

Introducing Amazon RDS Extended Support for Amazon Aurora PostgreSQL and Amazon RDS for PostgreSQL 11

Amazon Aurora PostgreSQL-Compatible Edition and Amazon Relational Database Service (Amazon RDS) for PostgreSQL major versions are supported at least until the community end-of-life for the corresponding community versions. When the community PostgreSQL major version reaches its end of life, no further updates, security patches, or bug fixes are released by the community. Aurora PostgreSQL 11 clusters […]

Introducing Amazon RDS Extended Support for MySQL databases on Amazon Aurora and Amazon RDS

With the upcoming end-of-life of MySQL Community Version v5.7 in October 2023 (Page 24), Amazon Web Services (AWS) is actively preparing for this important transition. When MySQL 5.7 reaches community end of life, no further updates, bug fixes, or security patches will be released by the community. We understand that Amazon Relational Database Service (Amazon […]

Secure Amazon Aurora clusters in HIPAA-compliant workloads

NextGen Healthcare, Inc., a leading provider of innovative, cloud-based healthcare technology solutions is on a mission to improve the lives of those who practice medicine and their patients. Our NextGen Population Health solution provides actionable insights directly to care teams via the aggregation and transformation of multi-source data. Built as a cloud native product, NextGen […]

Introducing – Aurora Global Database Failover

Amazon Aurora is a MySQL and PostgreSQL-compatible relational database built for the cloud. Aurora combines the performance and availability of traditional enterprise databases with the simplicity and cost-effectiveness of open-source databases. Aurora Global Database lets you span your relational database across multiple Regions. Global Database is an ideal choice for use cases when you want […]

Upgrade from Amazon Aurora Serverless v1 to v2 with minimal downtime

When Amazon Aurora Serverless v1 came out, it was one of the most exciting new features of 2018. The ability to have a relational database without having to worry about paying for idle compute, and without having a poor user experience due to periods of high load with insufficient capacity, was game-changing, and many AWS […]

Manage case-insensitive data in PostgreSQL

It’s important to be aware of the case sensitivity of text data in PostgreSQL when performing queries or comparisons to ensure that the results match your intended expectations. Case also affects how the database performs sorting operations. By default, PostgreSQL is case sensitive when sorting or comparing string values. For example, PostgreSQL considers “amazon” and […]

Amazon Aurora PostgreSQL: cross-account synchronization using logical replication

In this post, we show you how to set up cross-account logical replication using Amazon Aurora PostgreSQL-Compatible Edition. By leveraging Aurora’s cross-account clone and PostgreSQL logical replication, you can achieve near real-time synchronization between a source and a target database in different AWS accounts. You can customize the solution to meet specific requirements, including selective […]