Home / server / Questions / 199642
In Process
ParisNakitaKejser
Asked: 2010-11-09 16:04:51 +0800 CST

looking for MySQL failover and loadbalace setup for clusting

  • 772

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.

mysql load-balancing cluster mysql-cluster failovercluster

3 Answers

  1. 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.

    • 1

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

    • 0

  3. I would recommend a combination of HAProxy and MMM

    http://mysql-mmm.org/

    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.

    • 0