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: 21 May, 2026

  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

  16 May, 2026

  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?

  27 Sep, 2025

  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

  26 Mar, 2025

  A practical guide to understanding, diagnosing, and resolving MySQL Data Dictionary inconsistencies on RDS MySQL and Aurora MySQL — before they become emergencies.