[Upgrade Ubuntu] uk_staging

[dacook]

• setup
• provision
• deploy
• ofn-security: provision
• db_transfer
• DNS switchover
  • ofn-install:provision with new url
  • systemctl restart puma
• connect metabase:
  • db_integrations
  • Trigger sync: https://data.openfoodnetwork.org.uk/admin/databases/88
    hmmm... permission still missing?
• Check:
  • New Relic
  • Downtime alerts (new relic and/or wormly?)
• Hook up GHA deploy
  • ofn-install:setup_remote_deployment (aka setup_semaphore_deployment)
  • authorise 'semaphore' deployment key for user ofn-deploy (see Update deployment playbook to help set up staging deployments #941 (comment) )
  • Add known_host entry for new server to GH secret DEPLOYMENT_HOSTS
  • check Deploy to staging works.
• Update documentation:
  • https://github.com/openfoodfoundation/ofn-install/wiki/Current-servers#uk-1 (inlude note about redis version pinned)
  • document about provisioning staging servers with remote deployment (refer Update deployment playbook to help set up staging deployments #941)
  • anything else

[dacook]

Dunno why, metabase wasn't showing all the tables at first: https://openfoodnetwork.slack.com/archives/CNB9M5SSD/p1727173826747399?thread_ts=1723090524.703699&cid=CNB9M5SSD

there's only one table (pg_stat_statements) in uk_staging on metabase/postgres n8n connections

✅ But now it is. Maybe it took a while before it could process it all. Or maybe I did something else that fixed it 🤷

[dacook]

Server looking good. In fact, it might have way more disk storage than it needs.

https://one.eu.newrelic.com/nr1-core/infra-summary/host/NDAyODY5OXxJTkZSQXxOQXw4OTk4NjA0MzQxOTU1MzE3NTky?account=4028699&begin=1727740680000&end=1728946680000&filters=%28domain%20%3D%20%27INFRA%27%20AND%20type%20%3D%20%27HOST%27%29&state=f2c948ba-9c19-873f-8548-a401a3dd41cb