nycmeshnet / meshdb

A convenient, stable, and sane database for tracking Members and Nodes for use with robots and humans
https://db.nycmesh.net
MIT License
12 stars 14 forks source link

Complete volume swap #616

Closed james-otten closed 1 month ago

james-otten commented 2 months ago

Complete the volume swap to an encrypted volume for postgres.

I will take care of this, approve but do not merge.

Resolves https://github.com/nycmeshnet/meshdb/issues/343

codecov[bot] commented 2 months ago

Codecov Report

All modified and coverable lines are covered by tests :white_check_mark:

Project coverage is 94.02%. Comparing base (665e105) to head (3346caa). Report is 1 commits behind head on main.

Additional details and impacted files ```diff @@ Coverage Diff @@ ## main #616 +/- ## ======================================= Coverage 94.02% 94.02% ======================================= Files 75 75 Lines 3081 3081 ======================================= Hits 2897 2897 Misses 184 184 ```

:umbrella: View full report in Codecov by Sentry.
:loudspeaker: Have feedback on the report? Share it here.

james-otten commented 2 months ago

What does the migration look like? Will we just need to restore from a backup?

That could be done with just this PR and it would be less complicated.

  1. Scale everything but postgres to zero
  2. Execute a manual backup
  3. Merge this
  4. Scale back to zero
  5. Restore backup
  6. Scale back up (or just re-deploy)