Migrations under Production Load: How to Switch Your Database without Disrupting Service

Wednesday, 29 August, 2018 - 12:0012:30

Vilde Opsal, SoundCloud


How do you handle live traffic and serve correct results while switching databases? In this talk, Vilde will share a general step-by-step approach to live database migrations from a backend application developer perspective. Using two recent migrations as examples she will walk through what went wrong, what went right, the patterns such projects follow, and how you can apply this to your own projects. You will hear about a database migration from MySQL to Cassandra in a high-traffic critical production system and a data migration that involved recreating the whole database in a complex legacy system.

Vilde Opsal, SoundCloud

Vilde Opsal is a feminist developer from Norway, currently living in Berlin by way of California.

SREcon18 Europe/Middle East/Africa Open Access Videos
Sponsored by Indeed

Open Access Media

USENIX is committed to Open Access to the research presented at our events. Papers and proceedings are freely available to everyone once the event begins. Any video, audio, and/or slides that are posted after the event are also free and open to everyone. Support USENIX and our commitment to Open Access.

@inproceedings {218943,
author = {Vilde Opsal},
title = {Migrations under Production Load: How to Switch Your Database without Disrupting Service},
booktitle = {SREcon18 Europe/Middle East/Africa (SREcon18 Europe)},
year = {2018},
address = {Dusseldorf},
url = {https://www.usenix.org/node/218944},
publisher = {USENIX Association},
month = aug

Presentation Video 

Presentation Audio