How to use a remote Mariadb

Yvan

I would like use a remote Mariadb server so that it can be on a dedicated machine with appropriate hardware. By default, all services seem to connect through the “mysql socket” Docker volume. Is there a way to specify a remote MySQL, better than manually changing the database path in every configuration file of all other containers?

Also, can someone tell me why the Mariadb container listens by default on port 13306 on the host, while other containers use the Unix socket?

Regards,
Yvan

esackbauer

Maybe iRedmail works better for you. mailcow is a docker compose stack solution, any component running outside is not supported, and you are on your own.

Yvan

Thanks @esackbauer. But I really like mailcow :-)
And do you have a clue why Mariadb container is also exposed on localhost:13306?

esackbauer

Yvan do you have a clue why Mariadb container is also exposed on localhost:13306?

No. I am not the developer 😉
To be honest, I would put mailcow on that “dedicated machine”. Not only the database. What do you have in mind? Thousands of users? With an unsupported deployment of mailcow?

Yvan

esackbauer
A powerful machine is indeed a good first step.
We plan something like thousands of users yes, so we would like to be able to scale. Unfortunately I can not tell for the support right now, but I really hope we can.

esackbauer

Yvan What I can say after working 20 years in infrastructure design:
Do not run so many users on an unsupported solution, without a proper support contract. Otherwise you are calling for troubles.

Yvan

esackbauer
OK, I really appreciate the advice. I have not been working on infrastructure design for 20 years yet :-)