Production Runbook

Some notes on maintaining the website in production.

Asset cleanup

Rails and Dokku don't clean up old assets (css, js, images, etc) by itself. This means that on every deploy that an asset changes, both the new and old asset are kept on disk. Over time this can build up to a lot of excess, old assets.

Every once in a while, it's good to purge all assets and regenerate only the current ones.

Warning: this is a destructive, uptime-affecting action. Assets will throw a 404 error until the recompilation step is completed.

1. SSH into the Dokku VM, and dokku enter brickhack-stage web
2. From the shell, run rails assets:clobber. This will essentially rm -rf public/assets/
3. Immediately after, run rails assets:precompile. This will regenerate the current assets.
4. Exit the shell by entering exit. Dokku might not kill the temporary shell container otherwise.

Yearly website cycle

Back up old data

1. SSH into the Dokku VM
2. Run dokku mysql:export hm > hm-YYYY-MM-DD.sql, replacing YYYY-MM-DD with the current date
3. The SQL backup file is now saved onto the VM
4. To download it locally, you can copy it over SFTP with FileZilla or on the command line with SCP:

# On your local computer, which will save to your downloads folder
$ scp username@csh-cloud.oweb.co:/home/username/hm-YYYY-MM-DD.sql ~/Downloads/

Clean out old data

Every year before the next round of BrickHack applications are accepted, the old users and questionnaires have to be purged.

1. SSH into the Dokku VM, and dokku enter hm web
2. From the shell, run rails console. This will delete all users and questionnaires. Run the following code:

Questionnaire.delete_all
User.delete_all
School.where("questionnaire_count > 0").update_all(questionnaire_count: 0)

Once this command completes, you'll likely want to re-create an admin account and promote it to an admin.

1. Create an account without completing an application
2. From the same Dokku shell in Step 2, run rails console
3. Run User.last.update_attribute(:role, 'admin')

The alternative to this is just dropping & re-creating the database, but this benefits from keeping old bus lists & bulk emails in the database for reference and keeping school records & duplicate name resolution.

Update old content & configuration

Several pieces of content will need to be updated from previous years.

1. Visit https://apply.brickhack.io/manage/configs and review all values.
2. Review bus lists (https://apply.brickhack.io/manage/bus_lists)
3. Review automated messages (https://apply.brickhack.io/manage/messages)