diff options
| -rw-r--r-- | notes/migrations/2021-11-22_v0.5.txt | 85 |
1 files changed, 85 insertions, 0 deletions
diff --git a/notes/migrations/2021-11-22_v0.5.txt b/notes/migrations/2021-11-22_v0.5.txt new file mode 100644 index 00000000..b68ac6d2 --- /dev/null +++ b/notes/migrations/2021-11-22_v0.5.txt @@ -0,0 +1,85 @@ + +First ran in QA, then prod run below. + +Note that no SQL snapshot was taken just before this upgrade. + + +## QA + +Date: 2021-11-22 (Pacific) + +Testing database migration to v0.5.0 in QA. + +Commands and timing: + + git checkout bnewbold-content-scope + + git log | head -n1 + # commit dd00cec4164c1a1c31c8d9cffb92deb2e30b2211 + + # as fatcat, in rust directory + time diesel migration run + + # Running migration 2021-11-17-222046_content_scope + # real 1m45.095s + # user 0m0.023s + # sys 0m0.008s + +Hrm, seems like the `ALTER TABLE` resulted in full table scans, which is +unexpected but not too bad. + + time cargo build --release + + # Finished release [optimized] target(s) in 4m 44s + # real 4m45.105s + # user 35m35.911s + # sys 0m57.502s + + time pipenv install --dev --deploy + + # real 0m31.618s + # user 0m26.830s + # sys 0m3.873s + +Did a test edit to add `content_scope` on a file entity, using web TOML form, +and it worked. Ready for prod! + + +## Prod + +Prep steps: +- merge branch to master +- tag (signed) + +Primary Deployment Steps: +- halt all workers on prod1 +- git pull +- run diesel SQL migration: time diesel migration run +- cargo build: time cargo build --release +- restart fatcat-api +- pipenv update: time pipenv install --dev --deploy +- restart fatcat-web +- restart all workers on prod1 +- deploy to misc-vm, fatcat-prod2-vm, scholar2-vm + +Commands: + + git log | head -n1 + # commit a1f8783c7774be7523f7a0207050e09bf5cdb12b + + time diesel migration run + # real 1m52.029s + # user 0m0.041s + # sys 0m0.020s + + time cargo build --release + # real 3m19.235s + # user 8m49.656s + # sys 0m10.654s + + time pipenv install --dev --deploy + # real 0m13.378s + # user 1m44.558s + # sys 0m16.582s + +Done, re-deployed elsewhere, and checked status. |