Fundraising/techops/procedures/services-metabase upgrade
<
Fundraising
|
techops
Prep
Backup the database
On the metabase primary database host (currently frdb2003) back up the metabase db:
-
mariadb-dump metabase > /tmp/metabase_backup-$(date +%Y%m%d).sql
Upgrade
Update the metabase package using package_getter
On the frpm host: TBD
Install the software on the host
On the analytics host (currently fran2001):
-
apt update -
apt upgrade metabase -
systemctl restart metabase
Post upgrade
Downgrade / Recovery
On the puppetserver:
- Ensure the previous known good version is present in the repo
- Purge the package from the repo
On the analytics host (currently fran2001)
-
Stop metabase -
systemctl stop metabase - Migrate down (commands still to be verified
export MB_DB_TYPE=mariadb
export MB_DB_DBNAME=metabase
export MB_DB_PORT=3006
export MB_DB_USER=username
export MB_DB_PASS=password
export MB_DB_HOST=frdb2003.frack.codfw.wmnet
java --add-opens java.base/java.nio=ALL-UNNAMED -jar metabase.jar migrate down
-
Remove the package locally:
apt remove metabase -
Purge the package:
apt purge metabase -
Update the apt repo:
apt update -
Install the previous version:
apt install metabase