2012/10/11 Oriol Martí <omarti@stripped>
> I've to make a HA mysql, for me the scalability it's not important because
> it's not an environment with a lot of queries.
> I've thinked about, and I think that the best solution is to mount an
> master-slave arquitecture, and if the master goes down, promote the slave
> to master. Monitoring this case, after manually we can put the master with
> slave status and recover the environment.
> What do you think that's the best tool to do this? Pacemaker or Red Hat
> Cluster Suite? Does anybody knows some example of configurations?
There are several ways to it automatically moving just a VIP:
Whatever solution you finally go for...make sure you handle correctly the
read_only option - as typically the slaves are recommended to have it ON.
So when promoting a slave automatically (or manually) make sure you or your
tool set it to OFF before moving the VIP to the new master.
Hope this helps,