Installing Metabase on new server

A two-server architecture is used in this setup:

• Metabase server: 2GB RAM, 20GB disk, Ubuntu 22.04 x64
• MySQL server: 1GB RAM, 20GB disk, Ubuntu 16.04 x64

To setup the Metabase server:

1. Create user account and installation directory

As a user with sudo privilege:

sudo adduser metabase
sudo apt-get update
sudo apt-get install openjdk-17-jre-headless
sudo mkdir -p /opt/metabase
sudo chown metabase /opt/metabase

2. Install Metabase

Login as metabase, then:

cd /opt/metabase
VER=0.44.6 # whatever the latest version is
mkdir -p $VER/lib $VER/var $VER/bin
wget -P /opt/metabase/current/bin https://github.com/TheRestartProject/DataAnalytics/blob/master/warehouse/scripts/metabase
wget -P /opt/metabase/current/bin https://github.com/TheRestartProject/DataAnalytics/blob/master/warehouse/scripts/start
wget -P /opt/metabase/current/lib http://downloads.metabase.com/v$VER/metabase.jar
ln -s /opt/metabase/$VER /opt/metabase/current

3. Create service start/stop script

As a user with sudo privilege:

sudo ln -s /opt/metabase/current/bin/metabase /etc/init.d/metabase
sudo systemctl daemon-reload

4. Create Metabase configuration file

cd /opt/metabase/current/etc
wget https://github.com/TheRestartProject/DataAnalytics/blob/master/config/metabase
sudo ln -s /opt/metabase/current/etc/metabase /etc/default/metabase
chmod 600 /opt/metabase/current/etc/metabase

5. Setup for TLS/SSL access

Use Nginx and Let's Encrypt.

6. Bring up Metabase service

sudo service metabase start

Logs will be in /var/log/metabase.log

7. Create admin users and configure data sources

See Metabase documentation for a general description of how to do this.