Database schema migrations with zero downtime

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.

Required audience experience:

Experience with (relational) databases and SQL statements

Objective of the talk:

Demonstrate strategies and patterns to successfully migrate database schemas from one version to another, without incurring application downtime.

You can see Michiel’s slides below:

Please follow us:

Track 2
Location: Moore Date: May 14, 2019 Time: 4:40 pm - 5:25 pm Michiel Rook, Michiel Rook