Server Fault is a question and answer site for system and network administrators. Join them; it only takes a minute:

Sign up
Here's how it works:
  1. Anybody can ask a question
  2. Anybody can answer
  3. The best answers are voted up and rise to the top

i have setup my clusting for 3 mysql servers, 1 master and 2 nodes what i need to do right now its setup a failover system and loadbalace setup.

Can sombardy link to a good article about that? i use newst Ubuntu 10.10 i mean, i can't remeber current, its soon here :P

i hobe to get help, i use mysql-cluster-server-5.1 if its help.

share|improve this question

Well you can't have a big failover with just 1 master.. All your writes go to the master so if that fails your system is readonly.

What I do is run HAProxy and have a master/master setup but all writes go to 1 machine and if that machine fails the other master is setup as a "sorry server" and all writes now go there.

share|improve this answer

I hope this helps. Or this book looks interesting. If you get the book, let me know if it is any good.

share|improve this answer

I would recommend a combination of HAProxy and MMM

HAProxy can load balance the reads between the two masters (with weighting) and then MMM will handle the management of failing over the primary in the case of it going down to provide the maximum uptime.

share|improve this answer

Your Answer


By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.