Upgrade to Pro — share decks privately, control downloads, hide ads and more …

Metabase, three good practises for a hosted setup

Sponsored · Ship Features Fearlessly Turn features on and off without deploys. Used by thousands of Ruby developers. →
Avatar for Lukas Rieder Lukas Rieder
May 08, 2018
Business
110
0

Metabase, three good practises for a hosted setup

This talk was held at Metabase UG, Berlin, May 8

Avatar for Lukas Rieder

Lukas Rieder

May 08, 2018

More Decks by Lukas Rieder

See All by Lukas Rieder
Modeling Document Databases
Avatar for Lukas Rieder overbryd
1
140
Ahoi! Complex applications on Kubernetes
Avatar for Lukas Rieder overbryd
0
83
Flow Based Programming in 2 minutes
Avatar for Lukas Rieder overbryd
0
82
Metabase UG, November 2018
Avatar for Lukas Rieder overbryd
0
130
Flow Based Programming in Elixir
Avatar for Lukas Rieder overbryd
0
180
Configuration in Elixir
Avatar for Lukas Rieder overbryd
0
180
Elixir Deployment
Avatar for Lukas Rieder overbryd
1
65
NIFs and C-Nodes
Avatar for Lukas Rieder overbryd
0
81
SQL Workshop Part 1
Avatar for Lukas Rieder overbryd
0
140

Other Decks in Business

See All in Business
子育てとキャリアのビルディングブロック
Avatar for 荒木 ARK news_it_enj
2
190
ファブリカホールディングス_2026年3月期通期説明資料
Avatar for fabrica holdings fabrica_com
1
5.8k
【正社員型エンジニア派遣事業】採用資料
Avatar for キャリアデザインセンター採用 cdcsaiyo
0
1.1k
複雑なシステムから大学職員を救う自律型エージェント「だっこくん」
Avatar for Mick Etoh micknerd
0
150
ROOT Thesis Q1 2026
Avatar for Axis Care a1256382
0
110
哲学ドリブン開発の全体像 ── 同じプロンプトで出力が変わるとき、何が起きているのか~Philosophy as Code
Avatar for Marcy-t makitotashiro
0
140
限界を超えろ＿ブランド概要資料2026
Avatar for Tomoyuki Fukagawa tomoyuki1188
PRO
0
310
AIエージェントが最も活躍できる業務領域の見つけ方：「判断の余白」がある業務とは
Avatar for NCDC ncdc
0
250
株式会社デジタルフォルン_2027年度新卒向け_会社説明資料
Avatar for 株式会社デジタルフォルン 採用チーム ldrecruit
0
230
株式会社レボルト Company Deck
Avatar for Revolt inc. takemura_yuto
0
380
YassLab (株) サービス紹介 / Introduction of YassLab
Avatar for YassLab yasslab
PRO
3
42k
CX Lens 購入後体験（ポストパーチェス）分析レポート
Avatar for Content Metrics contentmetrics
0
160

Featured

See All Featured
世界の人気アプリ100個を分析して見えたペイウォール設計の心得
Avatar for Akihiro Kokubo akihiro_kokubo
PRO
70
39k
<Decoding/> the Language of Devs - We Love SEO 2024
Avatar for Nikki Halliwell nikkihalliwell
1
210
Taking LLMs out of the black box: A practical guide to human-in-the-loop distillation
Avatar for Ines Montani inesmontani
PRO
3
2.2k
[SF Ruby Conf 2025] Rails X
Avatar for Vladimir Dementyev palkan
2
1k
How to Create Impact in a Changing Tech Landscape [PerfNow 2023]
Avatar for Tammy Everts tammyeverts
55
3.3k
ピンチをチャンスに：未来をつくるプロダクトロードマップ #pmconf2020
Avatar for Aki / @LoveIdahoBurger aki_iinuma
128
55k
How to train your dragon (web standard)
Avatar for Monica Dinculescu notwaldorf
97
6.6k
Hiding What from Whom? A Critical Review of the History of Programming languages for Music
Avatar for Tomoya Matsuura tomoyanonymous
2
800
Documentation Writing (for coders)
Avatar for Carmen Chung carmenintech
77
5.3k
Neural Spatial Audio Processing for Sound Field Analysis and Control
Avatar for NII S. Koyama's Lab skoyamalab
0
290
Un-Boring Meetings
Avatar for Sebastian Deterding codingconduct
0
290
Collaborative Software Design: How to facilitate domain modelling decisions
Avatar for Kenny Baas-Schwegler baasie
1
210

Transcript

  1. Metabase UG Berlin, May 8 @Betterplace

  2. Metabase UG Berlin, May 8 @Betterplace Welcome! Willkommen! SELECT *

    FROM berlin

  3. Metabase UG Berlin, May 8 @Betterplace Thank you for coming!

  4. Metabase UG Berlin, May 8 @Betterplace

  5. Metabase UG Berlin, May 8 @Betterplace Hi, my name is

    Lukas Rieder

  6. Metabase UG Berlin, May 8 @Betterplace Hi, my name is

    Lukas Rieder
 I give talks.

  7. Metabase UG Berlin, May 8 @Betterplace Hi, my name is

    Lukas Rieder
 I consult companies.

  8. Metabase UG Berlin, May 8 @Betterplace Hi, my name is

    Lukas Rieder
 I develop software.

  9. Metabase UG Berlin, May 8 @Betterplace Hi, my name is

    Lukas Rieder
 I really like Metabase.

  10. Metabase UG Berlin, May 8 @Betterplace Metabase accesses, analyses and

    visualises your datasets.

  11. Metabase UG Berlin, May 8 @Betterplace Metabase accesses, analyses and

    visualises your datasets.

  12. Metabase UG Berlin, May 8 @Betterplace Metabase is Open Source

  13. Metabase UG Berlin, May 8 @Betterplace Metabase is a Web

    Service

  14. Metabase UG Berlin, May 8 @Betterplace

  15. Metabase UG Berlin, May 8 @Betterplace Single -User

  16. Metabase UG Berlin, May 8 @Betterplace Multi -User

  17. Metabase UG Berlin, May 8 @Betterplace Three
 Good practises

  18. Metabase UG Berlin, May 8 @Betterplace Metadata Storage

  19. Metabase UG Berlin, May 8 @Betterplace Metabase stores its Metadata

    separately.

  20. Metabase UG Berlin, May 8 @Betterplace Users, Database Connections,
 Questions,

    Collections, Dashboards, Cached Queries, ...

  21. Metabase UG Berlin, May 8 @Betterplace By default its a

    H2 database on the filesystem. This works only for a single instance.

  22. Metabase UG Berlin, May 8 @Betterplace Multiple instances must use

    a separate database. PostgreSQL or MySQL.

  23. Metabase UG Berlin, May 8 @Betterplace Backup metadata storage.

  24. Metabase UG Berlin, May 8 @Betterplace Backup metadata storage. Backup

    the metadata storage.

  25. Metabase UG Berlin, May 8 @Betterplace Backup metadata storage. Really.

    Do it. Backup the metadata storage.

  26. Metabase UG Berlin, May 8 @Betterplace Separate Staging for safe

    upgrades

  27. Metabase UG Berlin, May 8 @Betterplace metabase.company.com
 metabase.staging.company.com


  28. Metabase UG Berlin, May 8 @Betterplace metabase.company.com
 v0.27 metabase.staging.company.com
 v0.29

  29. Metabase UG Berlin, May 8 @Betterplace v0.27 v0.29

  30. Metabase UG Berlin, May 8 @Betterplace v0.27 v0.29 Metadata storage

    might be migrated.

  31. Metabase UG Berlin, May 8 @Betterplace v0.27 v0.29 Safer to

    do on a staging copy.

  32. Metabase UG Berlin, May 8 @Betterplace v0.27 v0.29 Backup before

    upgrade.

  33. Metabase UG Berlin, May 8 @Betterplace v0.27 v0.29 Bugs might

    occur.

  34. Metabase UG Berlin, May 8 @Betterplace v0.27 v0.29 Better test

    on staging before upgrade.

  35. Metabase UG Berlin, May 8 @Betterplace Read-only Database users

  36. Metabase UG Berlin, May 8 @Betterplace Metabase connects to many

    external databases.

  37. Metabase UG Berlin, May 8 @Betterplace

  38. Metabase UG Berlin, May 8 @Betterplace Your Metabase is most

    probably exposed on the internet.

  39. Metabase UG Berlin, May 8 @Betterplace DELETE * FROM berlin

  40. Metabase UG Berlin, May 8 @Betterplace DELETE * FROM berlin

    Bad. Very.
 Connections with write-level access can simply do that.

  41. Metabase UG Berlin, May 8 @Betterplace Restrict your database connections

    to read-only users.

  42. Metabase UG Berlin, May 8 @Betterplace There is more.

  43. Metabase UG Berlin, May 8 @Betterplace Contact me Lukas Rieder

    Mail: [email protected] Twitter: @Overbryd