Metabase, three good practises for a hosted setup

This talk was held at Metabase UG, Berlin, May 8

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: l.rieder@gmail.com Twitter: @Overbryd