[Linux-cluster] MySQL MASTER->SLAVE agent?

[Jakov Sosic]

Hi.

Would it be possible to use the MySQL replication as a way of achieving HA?

When MASTER is down to take appropriate actions and declare SLAVE the
NEW master, and take on IP address? Has anyone tested this kind of
setup? Obviously, failback should be impossible and request manual action.

This would pose as a good solution for environments without shared
storage and without DRBD.


-- 
Jakov Sosic
www.srce.hr