Can I have a Redmine database on a MySQL cluster?

Added by Nick Bolton over 10 years ago

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?

Replies (2)

RE: Can I have a Redmine database on a MySQL cluster? - Added by Muntek Singh over 10 years ago

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?

RE: Can I have a Redmine database on a MySQL cluster? - Added by Nick Bolton over 10 years ago

High availability, simply put. For this, a poor man's load balancer seemed like the most practical option.

(1-2/2)