Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Sign up for free
Menu
Search
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Features
All features
Private URLs
Password Protection
Custom URLS
Scheduled publishing
Remove Branding
Restrict embedding
Deck Collections
Notes
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Explore
Featured decks
Featured speakers
Programming
Technology
Storyboards
Pricing
Search
Sign in
Sign up for free
Metabase, three good practises for a hosted setup
Search
Sponsored
·
Ship Features Fearlessly
Turn features on and off without deploys. Used by thousands of Ruby developers.
→
Lukas Rieder
May 08, 2018
Business
150
0
Share
Embed
Copy iframe code
Copy JS code
Copy link
Start on current slide
Metabase, three good practises for a hosted setup
This talk was held at Metabase UG, Berlin, May 8
Lukas Rieder
May 08, 2018
Transcript
43 slides
Metabase UG Berlin, May 8 @Betterplace
Metabase UG Berlin, May 8 @Betterplace Welcome! Willkommen! SELECT *
FROM berlin
Metabase UG Berlin, May 8 @Betterplace Thank you for coming!
Metabase UG Berlin, May 8 @Betterplace
Metabase UG Berlin, May 8 @Betterplace Hi, my name is
Lukas Rieder
Metabase UG Berlin, May 8 @Betterplace Hi, my name is
Lukas Rieder I give talks.
Metabase UG Berlin, May 8 @Betterplace Hi, my name is
Lukas Rieder I consult companies.
Metabase UG Berlin, May 8 @Betterplace Hi, my name is
Lukas Rieder I develop software.
Metabase UG Berlin, May 8 @Betterplace Hi, my name is
Lukas Rieder I really like Metabase.
Metabase UG Berlin, May 8 @Betterplace Metabase accesses, analyses and
visualises your datasets.
Metabase UG Berlin, May 8 @Betterplace Metabase accesses, analyses and
visualises your datasets.
Metabase UG Berlin, May 8 @Betterplace Metabase is Open Source
Metabase UG Berlin, May 8 @Betterplace Metabase is a Web
Service
Metabase UG Berlin, May 8 @Betterplace
Metabase UG Berlin, May 8 @Betterplace Single -User
Metabase UG Berlin, May 8 @Betterplace Multi -User
Metabase UG Berlin, May 8 @Betterplace Three Good practises
Metabase UG Berlin, May 8 @Betterplace Metadata Storage
Metabase UG Berlin, May 8 @Betterplace Metabase stores its Metadata
separately.
Metabase UG Berlin, May 8 @Betterplace Users, Database Connections, Questions,
Collections, Dashboards, Cached Queries, ...
Metabase UG Berlin, May 8 @Betterplace By default its a
H2 database on the filesystem. This works only for a single instance.
Metabase UG Berlin, May 8 @Betterplace Multiple instances must use
a separate database. PostgreSQL or MySQL.
Metabase UG Berlin, May 8 @Betterplace Backup metadata storage.
Metabase UG Berlin, May 8 @Betterplace Backup metadata storage. Backup
the metadata storage.
Metabase UG Berlin, May 8 @Betterplace Backup metadata storage. Really.
Do it. Backup the metadata storage.
Metabase UG Berlin, May 8 @Betterplace Separate Staging for safe
upgrades
Metabase UG Berlin, May 8 @Betterplace metabase.company.com metabase.staging.company.com
Metabase UG Berlin, May 8 @Betterplace metabase.company.com v0.27 metabase.staging.company.com v0.29
Metabase UG Berlin, May 8 @Betterplace v0.27 v0.29
Metabase UG Berlin, May 8 @Betterplace v0.27 v0.29 Metadata storage
might be migrated.
Metabase UG Berlin, May 8 @Betterplace v0.27 v0.29 Safer to
do on a staging copy.
Metabase UG Berlin, May 8 @Betterplace v0.27 v0.29 Backup before
upgrade.
Metabase UG Berlin, May 8 @Betterplace v0.27 v0.29 Bugs might
occur.
Metabase UG Berlin, May 8 @Betterplace v0.27 v0.29 Better test
on staging before upgrade.
Metabase UG Berlin, May 8 @Betterplace Read-only Database users
Metabase UG Berlin, May 8 @Betterplace Metabase connects to many
external databases.
Metabase UG Berlin, May 8 @Betterplace
Metabase UG Berlin, May 8 @Betterplace Your Metabase is most
probably exposed on the internet.
Metabase UG Berlin, May 8 @Betterplace DELETE * FROM berlin
Metabase UG Berlin, May 8 @Betterplace DELETE * FROM berlin
Bad. Very. Connections with write-level access can simply do that.
Metabase UG Berlin, May 8 @Betterplace Restrict your database connections
to read-only users.
Metabase UG Berlin, May 8 @Betterplace There is more.
Metabase UG Berlin, May 8 @Betterplace Contact me Lukas Rieder
Mail:
[email protected]
Twitter: @Overbryd
More Decks by Lukas Rieder
See All by Lukas Rieder
Modeling Document Databases
overbryd
1
190
Ahoi! Complex applications on Kubernetes
overbryd
0
120
Flow Based Programming in 2 minutes
overbryd
0
120
Metabase UG, November 2018
overbryd
0
180
Flow Based Programming in Elixir
overbryd
0
220
Configuration in Elixir
overbryd
0
220
Elixir Deployment
overbryd
1
120
NIFs and C-Nodes
overbryd
0
120
SQL Workshop Part 1
overbryd
0
210
Other Decks in Business
See All in Business
akippa株式会社|Company Deck
akippa
1
27k
アジアクエスト会社紹介資料 / We invite you!
asiaquest
9
140k
株式会社アドバンテッジリスクマネジメント会社紹介資料
arm0020
0
72k
OGG - Investor Presentation - November 26
prabenok
0
290
Kiro Crew で re:Invent 2026の準備をした話
maijun
0
350
CIRCULATION's First Grade Guide-“小1の壁” ガイド-
circulation
0
250
セキサーマル株式会社 会社紹介資料
sekithermal
0
410
株式会社BFT 採用ピッチ資料|エンジニア&営業職向け
bft_recruit
3
45k
会社説明資料 | 株式会社Swish
takumi4327
0
210
20261024_スクラム祭り三島
kgnkhkr
1
630
スマートキャンプ株式会社 会社紹介資料 / companydeck
smartcamp
1
6.1k
株式会社なぞる 会社概要
nazoru
0
230
Featured
See All Featured
Abbi's Birthday
coloredviolet
5
11k
Claude Code どこまでも/ Claude Code Everywhere
nwiizo
68
61k
Rails Girls Zürich Keynote
gr2m
96
14k
Building Better People: How to give real-time feedback that sticks.
wjessup
371
20k
Navigating the moral maze — ethical principles for Al-driven product design
skipperchong
2
700
Ruling the World: When Life Gets Gamed
codingconduct
0
450
Fantastic passwords and where to find them - at NoRuKo
philnash
53
4k
How to Align SEO within the Product Triangle To Get Buy-In & Support - #RIMC
aleyda
2
1.9k
Site-Speed That Sticks
csswizardry
13
1.6k
Java REST API Framework Comparison - PWX 2021
mraible
34
9.8k
Building Adaptive Systems
keathley
44
3.3k
The MySQL Ecosystem @ GitHub 2015
samlambert
251
13k