Automatic fail-over of two database with Mattermost

Hi everyone,

Has any of you configured the automatic failover for Mattermost server and it’s databases?
If yes, how did you setup and how is your configuration?

We have on-premise dockerised containers for Mattermost server, database (PostgreSQL) and proxy (Nginx), all containers hosted on Windows Hyper-V.

The Mattermost’s default option will allow a read replica database, which needs to be manually switched on as master if the main db instance breaks.

To have the automatic failover of database, what could be our options to have two databases that synchronise, detect the failure and switch to the second db instance that is still working?

Thanks and would appreciate your advice.

Regards,
Dipu