aboutsummaryrefslogtreecommitdiffstats
path: root/notes/migrations
diff options
context:
space:
mode:
authorBryan Newbold <bnewbold@robocracy.org>2019-05-23 11:44:38 -0700
committerBryan Newbold <bnewbold@robocracy.org>2019-05-23 15:24:33 -0700
commite27565c93e050e0d14daa556cb9b0f96b84ad28d (patch)
tree1c89f9497be1e975bb83b1b0de96b9977d3fb930 /notes/migrations
parentf5b955746f2fb62220c3b3dfc134d4d35193f776 (diff)
downloadfatcat-e27565c93e050e0d14daa556cb9b0f96b84ad28d.tar.gz
fatcat-e27565c93e050e0d14daa556cb9b0f96b84ad28d.zip
migration notes
Diffstat (limited to 'notes/migrations')
-rw-r--r--notes/migrations/20190521_qa_v0.3.txt31
-rw-r--r--notes/migrations/20190523_prod_v0.3.txt13
2 files changed, 44 insertions, 0 deletions
diff --git a/notes/migrations/20190521_qa_v0.3.txt b/notes/migrations/20190521_qa_v0.3.txt
new file mode 100644
index 00000000..881d192a
--- /dev/null
+++ b/notes/migrations/20190521_qa_v0.3.txt
@@ -0,0 +1,31 @@
+
+Upgrading QA to v0.3
+------------------------
+
+Size before: 288.81G
+
+Took API down at 2019-05-21 12:09
+
+ time diesel migration run
+ Running migration 2019-05-09-051834_v0.3
+
+ real 6m14.481s
+ user 0m0.028s
+ sys 0m0.028s
+
+Disk I/O is furious!
+
+
+fatcat@wbgrp-svc500:/srv/fatcat/src/rust$ time cargo build --release
+ Compiling fatcat-api-spec v0.3.0 (/srv/fatcat/src/rust/fatcat-api-spec)
+ Compiling fatcat v0.3.0 (/srv/fatcat/src/rust)
+ Finished release [optimized] target(s) in 4m 24s
+
+real 4m24.673s
+user 10m22.476s
+sys 0m10.320s
+
+Back up at 12:23. Could have gone a bit faster with parallelism and no
+distractions.
+
+Size after: 289.14G
diff --git a/notes/migrations/20190523_prod_v0.3.txt b/notes/migrations/20190523_prod_v0.3.txt
new file mode 100644
index 00000000..fb077d5c
--- /dev/null
+++ b/notes/migrations/20190523_prod_v0.3.txt
@@ -0,0 +1,13 @@
+
+Starting at 11:16 or so.
+
+Pulled v0.3.0 (f5b955746f2fb62220c3b3dfc134d4d35193f776)
+
+ $ time diesel migration run
+ Running migration 2019-05-09-051834_v0.3
+
+ real 6m17.209s
+ user 0m0.036s
+ sys 0m0.020s
+
+And then rebuilds, and start/restart API and web. Easy!