How to choose the Metabase database?


#1

Hello everyone,

I’m evaluating Metabase for a few weeks. The Metabase data is stored in the default H2 database. How to start a new Metabase installation in another database, for example in MYSQL or ORACLE?


#2

Hi @LOURIVAL
Currently only Postgres and MariaDB/MySQL is supported as the internal database.
You can follow this guide to migrate:
https://www.metabase.com/docs/latest/operations-guide/start.html#migrating-from-using-the-h2-database-to-mysql-or-postgres


#3

Hi @flamber,

so from what I understand, it is only possible to start the first installation of Metabase in H2 and then to be able to migrate to another database, is that correct?


#4

@LOURIVAL
No, you should be able to start using Metabase the first time with non-H2 database:
https://www.metabase.com/docs/latest/operations-guide/start.html#configuring-the-metabase-application-database


#5

Hi @flamber

That’s what I needed. Congratulations on your contribution.

Thank you!