I have two servers, both Debian Linux. Currently I'm using them as a poor man's load balancer for high availability. However, currently I have only 1 MySQL server on the "master", so if the master goes down then the slave is useless.
To solve this I want to setup MySQL cluster with two servers to host the Redmine database. Is this possible? How can I do it?