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

[Andrew Beekhof]

On Sat, Feb 19, 2011 at 1:36 AM, Jakov Sosic <jakov.sosic at srce.hr> wrote:
> 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?

That would be tricky for rgmanager since it doesn't understand the
concept of multi-state resources.
I know people have done it with Pacemaker (also available in RHEL6) though.

> 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
>
> --
> Linux-cluster mailing list
> Linux-cluster at redhat.com
> https://www.redhat.com/mailman/listinfo/linux-cluster
>