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

Metabase, three good practises for a hosted setup

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
79
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 Monocrea monocrea
0
970
Spice Factory Inc. Culture Deck
Avatar for スパイスファクトリー株式会社（Spice Factory Inc.） spicefactory
0
17k
エコプロステージ2026／スーパーペンギン竹村
Avatar for NAOHISA TAKEMURA superpenguin
PRO
0
160
イクシアス株式会社　会社紹介資料
Avatar for イクシアス株式会社 ixyas
0
3.3k
エニグモ_会社紹介資料
Avatar for 株式会社エニグモ enigmo_hr
0
2.5k
AI × アジャイルで、エンタープライズを動かす: 文化に寄り添い、ビジネス価値を拡大する実践知 / AI × Agile: Driving Enterprise Transformation
Avatar for Yosuke Matsuura yosuke_matsuura
PRO
0
230
TOKIUM - Company Deck - engineering
Avatar for TOKIUM tokium
0
290
未経験PdM40%のプロダクトマネージャー組織を作った過程でわかった再現性について
Avatar for numashi numashi
1
730
爆速入力が可能に！ つよ〜い味方 Aqua Voice
Avatar for ぱんちゃん（山崎真由子） panchaaan_2
0
200
組織でAIをQAに活用する仕組みづくり / Scaling AI-Powered QA Across Your Organization
Avatar for MEDLEY, INC. medley
0
980
会社紹介資料
Avatar for GA technologies gatechnologies
2
140k
夜を制する者が “AI Agent 大民主化時代” を制する
Avatar for Takahiro Kubo icoxfog417
PRO
10
7.9k

Featured

See All Featured
DevOps and Value Stream Thinking: Enabling flow, efficiency and business value
Avatar for Helen Beal helenjbeal
1
75
For a Future-Friendly Web
Avatar for Brad Frost brad_frost
180
10k
WENDY [Excerpt]
Avatar for Tessa Abrams tessaabrams
9
35k
Fantastic passwords and where to find them - at NoRuKo
Avatar for Phil Nash philnash
52
3.5k
Speed Design
Avatar for Sergey Chernyshev sergeychernyshev
33
1.5k
Building Better People: How to give real-time feedback that sticks.
Avatar for Will Jessup wjessup
370
20k
A brief & incomplete history of 
UX Design for the World Wide Web: 1989–2019
Avatar for Jason CranfordTeague jct
1
270
The browser strikes back
Avatar for Jono Alderson jonoalderson
0
280
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
Avatar for Vitaly Friedman smashingmag
254
22k
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
Avatar for Eileen M. Uchitelle eileencodes
26
3.3k
How GitHub (no longer) Works
Avatar for Zach Holman holman
316
140k
How to Get Subject Matter Experts Bought In and Actively Contributing to SEO & PR Initiatives.
Avatar for Liv Day livdayseo
0
37

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