Is there a how-to somewhere describing a method to set up automatic
MySQL failover (master to slave) with heartbeat 2?
Do you need a replication slave?
Otherwise, I'd personally rather go with drbd instead of mysql
replication. It is synchronous in constrast to the asynchronous mysql
replication and drbd is supported by mysql. (see
http://www.mysql.com/products/enterprise/drbd.html )
To learn about drbd in heartbeat 2, read this howto:
http://www.linux-ha.org/DRBD/HowTov2
You could always set up a third machine as a slave if you need a slave.
With drbd, your master will be high available and you do not have to
care about setting the right "change master" values (which can be a hell
of a job in my experience).
Regards
Dominik
_______________________________________________
Linux-HA mailing list
[email protected]
http://lists.linux-ha.org/mailman/listinfo/linux-ha
See also: http://linux-ha.org/ReportingProblems