Can I have a Redmine database on a MySQL cluster?
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?
Depends on what you are trying to accomplish really. Are you planning to set these up as Master->Slave with failover, or are you wanting to "load balance" between the two with mysql replication?
Really the better question is, what are you tryhing to accomplish truly - is High Availability your main goal, or disaster recovery, or what?
High availability, simply put. For this, a poor man's load balancer seemed like the most practical option.