This talk looks at the common problems faced with making database changes through continuous delivery. It covers the major tools used to address database changes, and the advantages and disadvantages to each. Then it discusses how database migrations can effectively address schema changes over time, for both SQL and NoSQL databases. Finally, it explores solutions for some real-world scenarios when you apply database migrations at scale.
Continuous integration (CI) and continuous delivery (CD) all seemed so simple at first – hook up automatic deployments to our source control repository and every push goes straight to production. That worked fantastic until we introduced complications into the mix – the database! How can we safely and effectively make changes to databases – without taking the whole system down!
Video producer: http://ndc-london.com/