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
0
100

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
Tweet

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
80
Flow Based Programming in 2 minutes
Avatar for Lukas Rieder overbryd
0
78
Metabase UG, November 2018
Avatar for Lukas Rieder overbryd
0
130
Flow Based Programming in Elixir
Avatar for Lukas Rieder overbryd
0
170
Configuration in Elixir
Avatar for Lukas Rieder overbryd
0
180
Elixir Deployment
Avatar for Lukas Rieder overbryd
1
61
NIFs and C-Nodes
Avatar for Lukas Rieder overbryd
0
76
SQL Workshop Part 1
Avatar for Lukas Rieder overbryd
0
140

Other Decks in Business

See All in Business
キャンバスエッジ株式会社　会社説明資料
Avatar for キャンバスエッジ株式会社 canvasedge
0
9.4k
enechain company deck
Avatar for enechain Recruitment Team enechain
PRO
10
160k
【SBO勉強会】感謝されるAI活用＆ツール導入法
Avatar for Saki Yogoro sakiyogoro
1
220
アットウェア 会社説明資料
Avatar for atware atware
0
14k
giftee_Company introduction Febrary 2026
Avatar for giftee recruit_giftee
1
510
経営管理について / About Corporate Planning
Avatar for 株式会社ログラス loglass2019
0
6.8k
LW_brochure_engineer
Avatar for linc-well lincwellhr
0
40k
Akatsuki AI Technologies Company Deck
Avatar for Akatsuki AI Technologies akatsuki_ai_technologies
0
640
BlueWX_Introduction
Avatar for Yoshiaki Miyamoto amo0502
0
360
株式会社ネオキャリア＿採用ピッチ資料＿20260128
Avatar for neo_recruit neo_recruit
0
390
re:Invent2025 re:Cap 〜技術的負債解消と AWS Transform Customと わたし〜
Avatar for maijun maijun
0
130
会社紹介資料202601.pdf
Avatar for GMO Financial Holdings, Inc. gmofh_hr_team
0
1.7k

Featured

See All Featured
Easily Structure & Communicate Ideas using Wireframe
Avatar for Afnizar Nur Ghifari afnizarnur
194
17k
Tips & Tricks on How to Get Your First Job In Tech
Avatar for Honza Javorek honzajavorek
0
440
Breaking role norms: Why Content Design is so much more than writing copy - Taylor Woolridge
Avatar for UX Y'all uxyall
0
170
Creating an realtime collaboration tool: Agile Flush - .NET Oxford
Avatar for Marc Duiker marcduiker
35
2.4k
Introduction to Domain-Driven Design and Collaborative software design
Avatar for Kenny Baas-Schwegler baasie
1
590
A Modern Web Designer's Workflow
Avatar for Chris Coyier chriscoyier
698
190k
Joys of Absence: A Defence of Solitary Play
Avatar for Sebastian Deterding codingconduct
1
290
How to Talk to Developers About Accessibility
Avatar for Jason CranfordTeague jct
2
130
How to Ace a Technical Interview
Avatar for Jacob Kaplan-Moss jacobian
281
24k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
Avatar for Stéphanie Walter stephaniewalter
287
14k
実際に使うSQLの書き方 徹底解説 / pgcon21j-tutorial
Avatar for soudai sone soudai
PRO
196
71k
Embracing the Ebb and Flow
Avatar for Simon Collison colly
88
5k

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