AWS Database Blog
Building a multi-tenant CRM with Amazon Aurora DSQL
Learn how to design and implement a multi-tenant CRM on Amazon Aurora DSQL using the pooled tenancy model. Tenant isolation is enforced in a centralized data-access layer, with Aurora DSQL-specific design considerations, and a working proof of concept you can deploy on Amazon ECS Express Mode.
Offline assessment and conversion with AI agents in AWS DMS
Learn how to use an AI agent with AWS DMS Schema Conversion to assess and convert SQL Server database schemas from exported DDL scripts in Amazon S3, using offline source and virtual target mode. You can start migration planning before you have source database connectivity or a provisioned target.
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
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
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.
Help prevent out-of-memory restarts on Aurora MySQL 8.4
Out-of-memory restarts drop every connection and force an Aurora MySQL cluster restart. Learn how Aurora MySQL 8.4’s automatic memory management prevents them: confirm protection is active, read the signals during a memory-pressure event, monitor OOM avoidance with CloudWatch, and decide when to take manual control.
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
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
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
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.









