Hello, I am new to Metabase and have been using the default h2 datbase for development. i now need to migrate to a mysql database. I have an instance of metabase running on AWS Ubuntu, must I host the new mysql database on this server, or can i connect to another database hosted on my domain?
Firewall and name resolution permitting, you can host it anywhere.
Postgres is recommended over MySQL for performance. Much easier to go PG first than to try and migrate from MySQL to PG later.
Thanks for the feeback Andrew, is there any benefit of hosting the DB on a different site to where Metabase is hosted? Currently Metabase is connecting to my data on a different server so i was planning to setup the Metabase DB on the same server, but now i am thinking it is easier to setup on the same AWS server i am running metabase from.
application database should be very close to where the application that's invoking the DB is... otherwise you'll feel the lag on the app
1 Like