Tag: databases
All the articles with the tag "databases".
-
Altering a big table online: ADD column with near-zero downtime on MySQL 8+ and Postgres 14+
Updated:A practical, cloud-agnostic look at adding columns to large tables without downtime — what MySQL 8+ and Postgres 14+ actually let you do, the expand-contract pattern that beats native DDL alone, the OSS tools, and the managed-service caveats.
-
Aurora to Redshift Zero-ETL: what actually replicates
A practical look at Aurora PostgreSQL Zero-ETL into Redshift — how NOT NULL really behaves, why your PostgreSQL indexes don't translate, and how retries stay idempotent without enforced uniqueness.
-
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.