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

Reply via email to