What is the best setting for Metabase Server?

Hi guys, good morning!

  • How do I configure Metabase to make the most of the amount of RAM available on the server?
  • For a scenario where I will have 600 concurrent users, what would be the recommended server configuration for Metabase without these users having performance issues?

Hug,

Hi @Lourival

With that amount of concurrent users, I would recommend that you run multiple instances of Metabase connected to the same metadata, so you’ll take advantage of the horizontal scaling feature.

As for usage of RAM, you should tweak the Java options, so it makes most use of the RAM available on the instance.
Have a look at https://metabase.com/docs/latest/troubleshooting-guide/running.html
Tweaking memory usage is not specific to Metabase, so you can find a lot of information on the internet:
https://stackoverflow.com/questions/1493913/how-to-set-the-maximum-memory-usage-for-jvm

@flamber, good afternoon and thanks for replying.

I tried to run more than one instance of Metabase on the same server, but when starting the second instance, Metabase did not initialize and presented this error “Caused by: java.net.BindException: Address already in use: bind”, among other errors. Question: How to enable other instances of Metabase on the same server?

@Lourival
There’s not much point in running multiple instances on the same server. It’s the same hardware.
If you really want to run multiple instances on the same hardware, even though I can not recommend it in any way, then just define different ports for each instance:
https://metabase.com/docs/latest/operations-guide/customizing-jetty-webserver.html

Ok @flamber, thank you very much!