this process of failure detection with slave promotion is now automated
in MySQL 5.6 (release candidate) with the use of Global Transaction IDs
and the HA utilities
This recent blog and video tutorial are good places to learn more:
On 11/10/2012 15:17, Oriol Martí wrote:
> 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?
MySQL Cluster & HA Programs
+44 (0)7765 898-605