AWS Database Blog

Build an Oracle AWR-style report for RDS/Aurora PostgreSQL

Build an Oracle AWR-style report for RDS/Aurora PostgreSQL

PostgreSQL has no built-in Oracle AWR equivalent. This post shows how to build an AWR-style, snapshot-based performance report for Amazon RDS for PostgreSQL and Amazon Aurora PostgreSQL using pg_stat_statements and pg_cron, producing top-SQL, database-activity, wait-event, and load-profile reports between any two snapshot IDs, entirely in SQL.

Migrate from Amazon EC2 to Amazon ElastiCache Serverless with zero downtime

Migrate from Amazon EC2 to Amazon ElastiCache Serverless with zero downtime

On October 20, 2026, Amazon ElastiCache introduced online migration to ElastiCache Serverless for Valkey from self-managed Valkey and Redis OSS on Amazon EC2 with zero downtime. This post shows what’s supported at launch, how online migration works, and how to run a migration in the ElastiCache console.

Automating Oracle Data Guard switchover and failover on Amazon EC2

Automating Oracle Data Guard switchover and failover on Amazon EC2

Oracle Data Guard keeps a standby database in sync for high availability and disaster recovery, but running switchover and failover by hand on Amazon EC2 is slow and error-prone. This post shows how to automate both with AWS Step Functions and AWS Lambda, running validated pre-checks, the role transition, post-checks, and RTO/RPO tracking end to end.

Diagnose Amazon Aurora MySQL performance using CloudWatch Database Insights

Diagnose Amazon Aurora MySQL performance using CloudWatch Database Insights

When an Aurora MySQL or Amazon RDS for MySQL database slows down, it can be hard to tell why. This post shows how to read DB load in Amazon CloudWatch Database Insights, interpret the most common MySQL wait events, and turn each into a concrete action, so you can fix the real bottleneck instead of scaling up to a larger instance.

Automate Aurora zero-ETL recovery after global failover

Automate Aurora zero-ETL recovery after global failover

After an Amazon Aurora Global Database switchover or failover, the Aurora zero-ETL integration with Amazon Redshift keeps referencing the former primary and stops ingesting. Learn how to automate integration recreation with Amazon EventBridge and AWS Lambda so your analytics pipeline recovers without manual intervention.

How Flickr modernized caching with Amazon ElastiCache for Valkey

How Flickr modernized caching with Amazon ElastiCache for Valkey

Flickr, part of SmugMug, serves over 100 million photographers. In this post, the Flickr team shares how they modernized their caching layer by migrating from Redis and Twemproxy to Amazon ElastiCache for Valkey, consolidating more than 40 clusters, enabling cluster mode and multi-AZ failover, and moving to PhpRedis, all with no end-user disruption.

Multi-tenancy with Amazon ElastiCache: Choosing the right isolation model

Multi-tenancy with Amazon ElastiCache: Choosing the right isolation model

Choosing a multi-tenancy isolation model for Amazon ElastiCache for Valkey comes up in nearly every SaaS architecture review. This post walks through the options, from dedicated clusters to shared infrastructure with per-tenant encryption, and shows how to match each model to your blast radius and compliance requirements.