Database Schema Migrations with Zero Downtime

This talk explores ways to migrate database schemas safely while an application remains in production. It covers non-destructive changes, rollbacks, large data sets, migration tools, and strategies for minimizing disruption.

Syllabus

Introduction
Database schema migrations
Why rollbacks are bad
Zero downtime deployments
Backwards compatibility
Rename
Challenges
Columns
Feature Toggle
Test Migrations
Fake Data
No Schema Land
Migration during reads
Migration housekeeping
Large data sets
Failover
Kafka
CQRS
Migration tools
Recap