This repository was archived by the owner on Nov 14, 2022. It is now read-only.

Safe production migration deployment

Jump to bottom

Dimitar Tasev edited this page Jul 23, 2021 · 1 revision

Migration of the production DB is one of the operations we want to be extra careful with, as we want to minimise mistakes that could cost us downtime.

Suggested approach on how to prepare for migration of the production database:

Use the latest daily backup as a test environment. This is close to production, without actually being on production, and allows running the migrations.

It is not a 100% copy of production as the test environment will be using SQLite3 and not MySQL

Run a autoreduce-webapp-manage shomigrations to see a list of the migrations that will be applied.
Run the migration with autoreduce-webapp-manage migrate to apply the migrations.