AWS Database Blog
Category: Advanced (300)
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.
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.
Build an organization-wide Amazon RDS posture dashboard with Kiro
Deletion protection on an Amazon RDS database is a single setting that anyone can switch off, and across hundreds of accounts there is no single place to see which databases still run without it. This post shows how to track Amazon RDS posture organization-wide with one Amazon CloudWatch dashboard, built and verified with Kiro.
AWS contributes a large-transaction binary log optimization to MySQL
When MySQL commits a large transaction, writing it to the binary log can freeze every other commit on the server for minutes. This post introduces Binary Log Optimization for Large Transactions (BOLT), an AWS contribution to community MySQL that makes commit latency independent of transaction size, speeds crash recovery, and improves throughput.
Troubleshooting Data Mismatches with tablediff on Amazon RDS for SQL Server
Learn how to use the SQL Server tablediff utility to validate an Amazon RDS for SQL Server read replica against its primary after a replication lag event, detect and classify row-level data mismatches, and apply auditable T-SQL fix scripts on a promoted replica instance.









