Database schema management for lazybones: from chaos to heaven

Talk by Julien Riou
www.socallinux...
Performing database schema changes on a live system is challenging because it often involves high level of locks leading to downtime. It becomes harder and harder when the number of databases to manage raise continuously. At OVHcloud, we used to manage such changes approximately. In this talk, you will discover our feedback on how we have reduced efforts, time and human errors by automating databases schema migrations using git, code reviews, CI/CD, migration tools and Ansible at the OVHcloud scale.