Upgrade to Pro
— share decks privately, control downloads, hide ads and more …
Speaker Deck
Features
Speaker Deck
PRO
Sign in
Sign up for free
Search
Search
Metabase, three good practises for a hosted setup
Search
Lukas Rieder
May 08, 2018
Business
0
97
Metabase, three good practises for a hosted setup
This talk was held at Metabase UG, Berlin, May 8
Lukas Rieder
May 08, 2018
Tweet
Share
More Decks by Lukas Rieder
See All by Lukas Rieder
Modeling Document Databases
overbryd
1
130
Ahoi! Complex applications on Kubernetes
overbryd
0
77
Flow Based Programming in 2 minutes
overbryd
0
71
Metabase UG, November 2018
overbryd
0
130
Flow Based Programming in Elixir
overbryd
0
170
Configuration in Elixir
overbryd
0
180
Elixir Deployment
overbryd
1
57
NIFs and C-Nodes
overbryd
0
70
SQL Workshop Part 1
overbryd
0
130
Other Decks in Business
See All in Business
AWS Summit Japan 2025 社内コミュニティによる企業文化創り ~MAWS-UGの挑戦とこれから~
yukiogawa
2
930
15 Effective Ways to Speak to a Live 24/7 QuickBooks Payroll Support Experts
herry0o4
0
130
イオングローバルSCM株式会社 会社概要
agscm
0
560
テオリア・テクノロジーズ:About Us
theoriatec2024
1
29k
大AI時代を長く活躍するための 「コンフォート・ゾーン」の新解釈
mkitahara01985
0
1.1k
Sapeet Recruiting
sapeet
0
3.6k
Top 07 Ways to connect QuickBooks Payroll Support Number
qbpayroll1
0
200
メドピアグループ紹介資料
medpeer_recruit
10
130k
株式会社PROOF_エンジニア向け採用資料
proof
0
200
株式会社ファンコミュニケーションズ|会社説明資料 / Company Deck
fancomi_career
0
1.7k
ラクスパートナーズ採用ピッチ資料_エンジニア部門.pdf
rakuspartners_recruit
0
25k
インキュデータ会社紹介資料
okitsu
3
42k
Featured
See All Featured
How To Stay Up To Date on Web Technology
chriscoyier
790
250k
Cheating the UX When There Is Nothing More to Optimize - PixelPioneers
stephaniewalter
282
13k
The MySQL Ecosystem @ GitHub 2015
samlambert
251
13k
Raft: Consensus for Rubyists
vanstee
140
7k
Responsive Adventures: Dirty Tricks From The Dark Corners of Front-End
smashingmag
251
21k
What's in a price? How to price your products and services
michaelherold
246
12k
Measuring & Analyzing Core Web Vitals
bluesmoon
7
530
The Myth of the Modular Monolith - Day 2 Keynote - Rails World 2024
eileencodes
26
2.9k
A designer walks into a library…
pauljervisheath
207
24k
Improving Core Web Vitals using Speculation Rules API
sergeychernyshev
18
1k
Statistics for Hackers
jakevdp
799
220k
No one is an island. Learnings from fostering a developers community.
thoeni
21
3.4k
Transcript
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: l.rieder@gmail.com Twitter: @Overbryd