010PHP: Database migrations with zero downtime
9 Mar 2017 at Zicht Online

We can all agree that having a unreachable database due to some weird error like "no space left on device" is pretty annoying. This is the result of some unforeseen error and caused your application some downtime. But what happens when you are upgrading or tweaking your database? What kind of approach do you pick?

Schedule

List Grid
All sessions Starred only
Title Title & Description

Thursday 9th March 2017

19:45
0
Database migrations with zero downtime
Talk by Michiel Rook (45 minutes)

Does your application or service use a database? When that application changes because of new business requirements, you may need to make changes to the database schema. These database migrations could lead to downtime and can be an obstacle to implementing continuous delivery/deployment. How can we deal with database migrations when we don’t want our end-users to experience downtime, and want to keep releasing? In this talk we’ll discuss non-destructive changes, rollbacks, large datasets, useful tools and a few strategies to migrate our data safely, with minimum disruption to production.