Load Balancing/Fail Over
-
I would like to set up a second server and point both to the same MySQL server for data. While the reason be very clear, this needed fail over as well as load balancing.
Also, how does one access the MySQL database from outside the server as I assume this will be needed to set everything up.
-
Hi @ranunez,
at first I though you were talking about multiple database processes, but rereading now you are actually talking about multiple kopano-server processes, is that correct?
If so then you cannot have two processes connecting to the same database for load balancing purposes. kopano-server relies on caching and has no mechanisms to invalidate caches of data has changed on the database layer.
You can still do a failover with a (master/master) replicated database and e.g. with Pacemaker and a cluster ip, since kopano-server usually does not take long to start this will only be a short service interruption.
Edit: in case you want to learn more our prof. services team will be happy to help you out.