Database Schema Migrations with Zero Downtime

Learn strategies for implementing database schema migrations with zero downtime in this PHP UK Conference talk. Explore non-destructive changes, rollbacks, and techniques for handling large data sets while maintaining continuous deployment. Discover useful tools and approaches to safely migrate data with minimal disruption to production environments. Gain insights into backwards compatibility, feature toggles, test migrations, and housekeeping practices. Delve into advanced topics such as failover, Kafka, and CQRS to enhance your database migration skills and ensure seamless updates for your applications.

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