Posts
All the articles I've posted.
-
Why Is My PostgreSQL Major Version Upgrade So Slow?
A deep dive into why PostgreSQL major version upgrades take longer than expected — what actually happens under the hood, why parallelism won't save you, and how to diagnose the bottleneck. Applies to Aurora PostgreSQL, RDS PostgreSQL, and self-hosted.
-
Troubleshooting Data Dictionary Issues in MySQL and Aurora
A practical guide to understanding, diagnosing, and resolving MySQL Data Dictionary inconsistencies on RDS MySQL and Aurora MySQL — before they become emergencies.
-
Zero-Downtime Multi-TB Migrations: Cutover, Validation and Rollback (Part 2)
Planning the second half of a zero-downtime multi-terabyte migration and version upgrade: how to prove the data matches, rehearse, run the cutover for each wave, and keep a real rollback path.
-
Zero-Downtime Multi-TB Migrations: Strategy and Grouping (Part 1)
How to plan a zero-downtime migration and major version upgrade of a multi-terabyte database. Why physical replication does not fit, why logical replication does, and how to split databases and tables into groups you can migrate one at a time.