Metabase, three good practises for a hosted setup

Slide 1

Slide 1 text

Metabase UG Berlin, May 8 @Betterplace

Slide 2

Slide 2 text

Metabase UG Berlin, May 8 @Betterplace Welcome! Willkommen! SELECT * FROM berlin

Slide 3

Slide 3 text

Metabase UG Berlin, May 8 @Betterplace Thank you for coming!

Slide 4

Slide 4 text

Metabase UG Berlin, May 8 @Betterplace

Slide 5

Slide 5 text

Metabase UG Berlin, May 8 @Betterplace Hi, my name is Lukas Rieder

Slide 6

Slide 6 text

Metabase UG Berlin, May 8 @Betterplace Hi, my name is Lukas Rieder  I give talks.

Slide 7

Slide 7 text

Metabase UG Berlin, May 8 @Betterplace Hi, my name is Lukas Rieder  I consult companies.

Slide 8

Slide 8 text

Metabase UG Berlin, May 8 @Betterplace Hi, my name is Lukas Rieder  I develop software.

Slide 9

Slide 9 text

Metabase UG Berlin, May 8 @Betterplace Hi, my name is Lukas Rieder  I really like Metabase.

Slide 10

Slide 10 text

Metabase UG Berlin, May 8 @Betterplace Metabase accesses, analyses and visualises your datasets.

Slide 11

Slide 11 text

Metabase UG Berlin, May 8 @Betterplace Metabase accesses, analyses and visualises your datasets.

Slide 12

Slide 12 text

Metabase UG Berlin, May 8 @Betterplace Metabase is Open Source

Slide 13

Slide 13 text

Metabase UG Berlin, May 8 @Betterplace Metabase is a Web Service

Slide 14

Slide 14 text

Metabase UG Berlin, May 8 @Betterplace

Slide 15

Slide 15 text

Metabase UG Berlin, May 8 @Betterplace Single -User

Slide 16

Slide 16 text

Metabase UG Berlin, May 8 @Betterplace Multi -User

Slide 17

Slide 17 text

Metabase UG Berlin, May 8 @Betterplace Three  Good practises

Slide 18

Slide 18 text

Metabase UG Berlin, May 8 @Betterplace Metadata Storage

Slide 19

Slide 19 text

Metabase UG Berlin, May 8 @Betterplace Metabase stores its Metadata separately.

Slide 20

Slide 20 text

Metabase UG Berlin, May 8 @Betterplace Users, Database Connections,  Questions, Collections, Dashboards, Cached Queries, ...

Slide 21

Slide 21 text

Metabase UG Berlin, May 8 @Betterplace By default its a H2 database on the ﬁlesystem. This works only for a single instance.

Slide 22

Slide 22 text

Metabase UG Berlin, May 8 @Betterplace Multiple instances must use a separate database. PostgreSQL or MySQL.

Slide 23

Slide 23 text

Metabase UG Berlin, May 8 @Betterplace Backup metadata storage.

Slide 24

Slide 24 text

Metabase UG Berlin, May 8 @Betterplace Backup metadata storage. Backup the metadata storage.

Slide 25

Slide 25 text

Metabase UG Berlin, May 8 @Betterplace Backup metadata storage. Really. Do it. Backup the metadata storage.

Slide 26

Slide 26 text

Metabase UG Berlin, May 8 @Betterplace Separate Staging for safe upgrades

Slide 27

Slide 27 text

Metabase UG Berlin, May 8 @Betterplace metabase.company.com  metabase.staging.company.com 

Slide 28

Slide 28 text

Metabase UG Berlin, May 8 @Betterplace metabase.company.com  v0.27 metabase.staging.company.com  v0.29

Slide 29

Slide 29 text

Metabase UG Berlin, May 8 @Betterplace v0.27 v0.29

Slide 30

Slide 30 text

Metabase UG Berlin, May 8 @Betterplace v0.27 v0.29 Metadata storage might be migrated.

Slide 31

Slide 31 text

Metabase UG Berlin, May 8 @Betterplace v0.27 v0.29 Safer to do on a staging copy.

Slide 32

Slide 32 text

Metabase UG Berlin, May 8 @Betterplace v0.27 v0.29 Backup before upgrade.

Slide 33

Slide 33 text

Metabase UG Berlin, May 8 @Betterplace v0.27 v0.29 Bugs might occur.

Slide 34

Slide 34 text

Metabase UG Berlin, May 8 @Betterplace v0.27 v0.29 Better test on staging before upgrade.

Slide 35

Slide 35 text

Metabase UG Berlin, May 8 @Betterplace Read-only Database users

Slide 36

Slide 36 text

Metabase UG Berlin, May 8 @Betterplace Metabase connects to many external databases.

Slide 37

Slide 37 text

Metabase UG Berlin, May 8 @Betterplace

Slide 38

Slide 38 text

Metabase UG Berlin, May 8 @Betterplace Your Metabase is most probably exposed on the internet.

Slide 39

Slide 39 text

Metabase UG Berlin, May 8 @Betterplace DELETE * FROM berlin

Slide 40

Slide 40 text

Metabase UG Berlin, May 8 @Betterplace DELETE * FROM berlin Bad. Very.  Connections with write-level access can simply do that.

Slide 41

Slide 41 text

Metabase UG Berlin, May 8 @Betterplace Restrict your database connections to read-only users.

Slide 42

Slide 42 text

Metabase UG Berlin, May 8 @Betterplace There is more.

Slide 43

Slide 43 text

Metabase UG Berlin, May 8 @Betterplace Contact me Lukas Rieder Mail: [email protected] Twitter: @Overbryd