Sapphire Migration Checklist

Meta

• Migrate stagingsapphire to new hardware (following the procedure below)
• Migrate stagingsapphire with dump from sapphire
• Migrate sapphire to new hardware (following the procedure below)
• Drop databases on stagingsapphire and initialize with dummy data through rake task.

Webserver

• switch to nginx
• ssl certs (?)
• new.sapphire.isds.tugraz.at
• https://www.phusionpassenger.com/docs/advanced_guides/install_and_upgrade/nginx/install/oss/el8.html14:37

Questions (for Matthias and/or Helmut)

• CentOS 8 Stream is a rolling release? Are there and implications for sapphire because of some security critical OS updates we will have to do? (website reads: "Continuously delivered distro ...[https://www.centos.org/centos-stream/])
  • How are package updates going to be handled?

Prerequisites

• create production db dump
• copy assets to new hardware

Install

• Database: PostgreSQL 8.4.20 -> probs to 13.xx.xx
• Ruby (install via rbenv -> 2.6.5p114 (2019-10-01 revision 67812)) -> 2.7.xx
  • https://medium.com/@adrienjarthon/ruby-jemalloc-results-for-updown-io-d3fb2d32f67f
• Redis (Redis server v=3.2.12 sha=00000000:0 malloc=jemalloc-3.6.0 bits=64 build=b2d74fe5fff7657d) -> 6.2.5
• NodeJS (v0.10.35) -> ??
• Bundler
• Cap Deploy (check deploy target)

Setup

• setup config files:
  • database.yml
  • mail.yml
  • secrets.yml
  • sidekiq.yml
• gem install bundler
• import DB dump (lookup for appropriate GIST/snippet TODO)
• check if assets are correctly linked (i.e. in the correct folder, is this sufficient?)

Checks

• check certificate
• check auto https
• check mailing
• check upload (tests sidekiq)
• check entering of new ratings (tests redis)