Skip to content

MySQL to PostGres migration process

Carl Crowder edited this page Jan 8, 2015 · 4 revisions

Release preparation:

  • Set up StatusPage.io notification (Adrian?)
  • Release notes (Adrian?)
  • Create pull request to merge release/candidate into master (but don't merge yet) (Daniel/Adrian)

Release process:

  1. Shut down Live RSR (Carl)
  2. Create MySQL dump, and copy it into /home/daniel on live1.live.akvo-ops.org (Carl)
  3. Two things:
    • Download MySQL dump and run migration scripts (Daniel)
    • Update provisioning on live systems to ensure PostGres is present and configured correctly (Carl)
  4. Upload PostGres dump to live1.live.akvo-ops.org /home/daniel (Daniel)
  5. Load PostGres dump into PostGres DB (Carl)
  6. Merge release/candidate PR into master (Daniel/Adrian)
  7. Ensure TeamCity has correctly deployed RSR and that RSR is running (Carl)

After release:

  • Complete StatusPage.io incident (Adrian?)
  • Smoke test live system? (Ruarcc/Daniel?)