Tag

#Migrations

Every article tagged Migrations, in one place.

2 articles
4 min of reading
11 Jun, 2026 last updated

Showing 2 articles

PostgreSQL 2 min read

Zero-Downtime Schema Migrations in PostgreSQL

Most schema changes are instant. A few take heavy locks or rewrite entire tables, which can freeze a busy app. Knowing which is which is the key to safe migrations. Always set a lock timeout SET lock_timeout = '5s'; ALTER TABLE orders ADD COLUMN notes TEXT; Ev...

11 Jun, 2026 Author 550 54

Read article

MySQL 2 min read

Online Schema Changes in MySQL Without Downtime

On a table with hundreds of millions of rows, the wrong ALTER TABLE can lock writes for hours. MySQL offers several ways to avoid that. 1. Ask for INSTANT ALTER TABLE orders ADD COLUMN gift_message VARCHAR(255) NULL, ALGORITHM=INSTANT; Instant changes only tou...

23 May, 2026 Author 1.25K 89

Read article