Upgrade to Pro — share decks privately, control downloads, hide ads and more …
Sign up for free

Metabase, three good practises for a hosted setup

Avatar for Lukas Rieder Lukas Rieder
May 08, 2018
Business
140
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
170
Ahoi! Complex applications on Kubernetes
Avatar for Lukas Rieder overbryd
0
110
Flow Based Programming in 2 minutes
Avatar for Lukas Rieder overbryd
0
100
Metabase UG, November 2018
Avatar for Lukas Rieder overbryd
0
160
Flow Based Programming in Elixir
Avatar for Lukas Rieder overbryd
0
200
Configuration in Elixir
Avatar for Lukas Rieder overbryd
0
210
Elixir Deployment
Avatar for Lukas Rieder overbryd
1
110
NIFs and C-Nodes
Avatar for Lukas Rieder overbryd
0
110
SQL Workshop Part 1
Avatar for Lukas Rieder overbryd
0
190

Other Decks in Business

See All in Business
Webinar 30.09.2026 NeuroFlex I: Participación en el SRAD
Avatar for Neuroenergía neuroenergia
PRO
0
130
営業が見てきた"AI導入ガバナンス"のリアル — あなたの会社は今どのステージ？
Avatar for kurata_ryuichi kuraryu0128
0
220
Crisp Code inc.｜わたしたちの事例 / 実績 - Works
Avatar for So Kotani / Crisp Code inc. CEO so_kotani
0
2.4k
20261022_【DCC】トークン化国債・オンチェーンレポWG_中間整理_本紙
Avatar for progmat progmat
0
350
トヨタの販売店 DX の最前線で、生成 AI と内製開発で挑む
Avatar for KintoTech_Dev kintotechdev
0
160
コミュニケーションは受け手が決める〜読まれる職務経歴書の作り方/Communication makes your career
Avatar for 小田中育生 ikuodanaka
8
1.3k
大規模フロントエンド開発におけるmonorepoという選択肢
Avatar for Recruit recruitengineers
PRO
2
100
㈱サンエー 会社 採用資料
Avatar for クリヤマホールディングス㈱採用担当 uemura2024
0
5.4k
変化の時代に自分のハンドルを握る ── イチから始めるセルフマネジメント/Self-Management in the Winds of Change
Avatar for 小田中育生 ikuodanaka
2
310
FY2026.6 Impact Report JP
Avatar for Mercari, Inc. mercari_inc
1
140k
オープンワーク会社紹介資料 / company profile
Avatar for OpenWork Inc. openwork
4
610k
KOWRO / IDOL CAST 会社・サービス紹介
Avatar for Kunimitsu Toshiki kuni29
0
480

Featured

See All Featured
Optimising Largest Contentful Paint
Avatar for Harry Roberts csswizardry
37
4k
Stewardship and Sustainability of Urban and Community Forests
Avatar for Eric Wiseman pwiseman
0
560
Leveraging LLMs for student feedback in introductory data science courses - posit::conf(2025)
Avatar for Mine Cetinkaya-Rundel minecr
1
450
Redefining SEO in the New Era of Traffic Generation
Avatar for Szymon Słowik szymonslowik
1
480
Agile Actions for Facilitating Distributed Teams - ADO2019
Avatar for Mark Kilby mkilby
0
310
From Legacy to Launchpad: Building Startup-Ready Communities
Avatar for Dug Song dugsong
0
360
Scaling GitHub
Avatar for Zach Holman holman
464
140k
How to Talk to Developers About Accessibility
Avatar for Jason CranfordTeague jct
2
590
ピンチをチャンスに：未来をつくるプロダクトロードマップ #pmconf2020
Avatar for Aki / @LoveIdahoBurger aki_iinuma
128
56k
My Coaching Mixtape
Avatar for mlcsv mlcsv
0
360
Google's AI Overviews - The New Search
Avatar for Barry Adams badams
0
1.6k
WENDY [Excerpt]
Avatar for Tessa Abrams tessaabrams
14
40k

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