I managed to deploy, and run Metabase (backed by Fly Postgres) on Fly.io in a production setting using ClickHouse as the data warehouse. There are tut

Running Metabase in production on Fly.io

submited by

Style Pass

2024-04-17 13:30:07

I managed to deploy, and run Metabase (backed by Fly Postgres) on Fly.io in a production setting using ClickHouse as the data warehouse. There are tutorials online, but they only deploy Metabase in its default configuration (with H2 as the internal database), don’t provide (cost/price) estimates, nor metrics, nor do they specify how to add external dependencies or plugins into Metabase. All 3 things I needed answered for my use-case. Here’s what I have found (so far).

This solution is currently being tested by 2 people for internal reporting at a company, and later will be used by ~20 people. They didn’t want to spend too much on running this setup, so some decisions here are backed by cost-effective measures. If you can suggest further cost savings, I’d be extremely grateful!

This post may serve as a guide, but that’s not what it is intended for. This is reference material that I plan on updating over time. If you continue reading, my assumption is that you already know about ClickHouse, Fly and Metabase, and you are just curious how I’ve set things up