Database Schema Migrations with Zero Downtime

Michiel Rook (15.Feb.2018 at 13:30, 1 hr )
Talk at PHP UK Conference 2018 (English - US)

Rating: 5 of 5

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 data sets, useful tools and a few strategies to migrate our data safely, with minimum disruption to production.
Level: All

Who are you?

Claim talk

Talk claims have been moved to the new site.

Please login to the new site to claim your talk

Want to comment on this talk? Log in or create a new account or comment anonymously

Write a comment

Please note: you are not logged in and will be posting anonymously!
= eight minus six


Rating: 4 of 5

15.Feb.2018 at 16:48 by M1ke (22 comments) via Web2 LIVE

Well presented structure and a good set of tools to achieve the aim of migrations with no down time. I was able to ask a question at the end about how this would be managed with feature branches rather than trunk development, would be interesting to cover whether it's possible for those using feature branches, what would need to change to achieve it.

Rating: 5 of 5

15.Feb.2018 at 21:05 by Gavin Chapman (3 comments) via Web2 LIVE

Really helpful for a project we're working on at the moment, well structured and good examples.

© 2018