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
110

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
81
Flow Based Programming in 2 minutes
Avatar for Lukas Rieder overbryd
0
81
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
63
NIFs and C-Nodes
Avatar for Lukas Rieder overbryd
0
80
SQL Workshop Part 1
Avatar for Lukas Rieder overbryd
0
140

Other Decks in Business

See All in Business
BizDocVQA: 実世界ビジネス帳票に対する根拠付きVQAデータセットの提案
Avatar for Takahiro Kubo icoxfog417
PRO
0
230
Rakus Career Introduction
Avatar for rakus_career rakus_career
0
490k
enechain company deck_english
Avatar for enechain Recruitment Team enechain
PRO
1
340
本当に「時間がなかった」のか？
Avatar for Ryuya Nakamura nrryuya
0
190
会社案内資料
Avatar for スキルアップラボ sukirabo
0
270
メドピアのValues2025 －もう一度スタートアップへ－
Avatar for MedPeer Inc. Recruit medpeer_recruit
0
840
その仕事、 ブルシット・ジョブじゃない？
Avatar for すずくま szkm555
0
820
2025年度ICT職専門研修（海外派遣研修）報告書 No.2
Avatar for 東京都デジタル人材確保・育成 tokyo_metropolitan_gov_digital_hr
0
340
今いい感じのチーム構成と営み2025冬 〜Scrumっぽいけどチョット違う形〜
Avatar for sasakendayo sasakendayo
0
380
FABRIC TOKYO会社紹介資料 / We are hiring（2026年04月02日更新）
Avatar for FABRIC TOKYO yuichirom
36
380k
GMOリザーブプラス｜カルチャーデック "Way Book"
Avatar for GMO RESERVE PLUS gmo_rp
0
640
内定者100人の就活対策術
Avatar for ABABA ababa_company
0
3.6k

Featured

See All Featured
What does AI have to do with Human Rights?
Avatar for Per Axbom axbom
PRO
1
2.1k
Sam Torres - BigQuery for SEOs
Avatar for Tech SEO Connect techseoconnect
PRO
0
230
HU Berlin: Industrial-Strength Natural Language Processing with spaCy and Prodigy
Avatar for Ines Montani inesmontani
PRO
0
300
The Straight Up "How To Draw Better" Workshop
Avatar for Dennis Kardys denniskardys
239
140k
Leading Effective Engineering Teams in the AI Era
Avatar for Addy Osmani addyosmani
9
1.8k
A designer walks into a library…
Avatar for Paul Jervis Heath pauljervisheath
210
24k
Fight the Zombie Pattern Library - RWD Summit 2016
Avatar for Marcelo Somers marcelosomers
234
17k
The browser strikes back
Avatar for Jono Alderson jonoalderson
0
850
Utilizing Notion as your number one productivity tool
Avatar for Mfonobong Umondia mfonobong
4
270
The Cult of Friendly URLs
Avatar for Andy Hume andyhume
79
6.8k
RailsConf 2023
Avatar for Aaron Patterson tenderlove
30
1.4k
Why Our Code Smells
Avatar for Brandon Keepers bkeepers
PRO
340
58k

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