Database migrations with zero downtime

Michiel Rook (01.Jul.2017 at 09:45, 45 min)
Talk at Dutch PHP Conference 2017 (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 datasets, useful tools and a few strategies to migrate our data safely, with minimum disruption to production.

Who are you?

Claim talk

Talk claims have been moved to the new Joind.in 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!
= two minus one

Comments

Rating: 5 of 5

01.Jul.2017 at 10:14 by Jeroen v.d. Gulik (78 comments) via Joind.in iPhone app

Excellent talk about all the issues that arise when changing the schema on a live database with several strategies to deal with them.

Rating: 4 of 5

01.Jul.2017 at 10:14 by Shopware AG (4 comments) via Web2 LIVE

Straight forward, informative. Great talk.

Rating: 5 of 5

01.Jul.2017 at 10:37 by Sven Stolk (5 comments) via Web2 LIVE

Your English is very good for a fellow Dutchie. Your talk is certainly on top of my list (so far). The info and tips you gave are definitely going to be put to use in the future. Good examples and the presentation itself was very clean and clear.

Rating: 5 of 5

01.Jul.2017 at 10:51 by Mairsil (36 comments)

Excellent talk, clear and insightful. Some things seem very obvious now and make me wonder why I'm not always doing this.
I would have loved some more details about the usage of queueing, but pretty happy with the talk anyway.

Rating: 5 of 5

01.Jul.2017 at 12:45 by Max Roeleveld (10 comments) via Web2 LIVE

A great high level look at pittfalls and strategies around them.

Rating: 5 of 5

01.Jul.2017 at 14:11 by Anton Nizhegorodov (2 comments) via Web2 LIVE

Great overview of approaches. Nice and simple visualizations. Thank you!

Rating: 4 of 5

01.Jul.2017 at 19:55 by Robert (13 comments) via Web2 LIVE

Fine talk again with decent slides but it felt a little short. He did have good answers on the QA later on which eventually made it a good session.

Rating: 5 of 5

01.Jul.2017 at 20:36 by Frits van Campen (30 comments) via Web2 LIVE

Solid talk. Very comfortable speaking style.

Rating: 5 of 5

02.Jul.2017 at 14:47 by Pim Widdershoven (29 comments)

Enjoyed this talk! Gave me a lot of new insights how to do database migrations.

© Joind.in 2017