Re: MySQL MASTER->SLAVE agent?

[Date Prev][Date Next][Thread Prev][Thread Next][Date Index][Thread Index]

 



On 19.02.2011 03:05, Cleber Rosa wrote:
On 02/18/2011 10:36 PM, Jakov Sosic 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? 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,

Actually MySQL allows for MASTER<->MASTER replication. I've successfully deployed that on some 10 sites or so top of RHCS using nothing but a floating IP address for MySQL (plus other resources for other services).

Of course, you'd better keep an eye on MySQL's replication health when doing that.

CR.

--
Linux-cluster mailing list
Linux-cluster@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/linux-cluster
you could try with ndb tables,  it's the mysql cluster engine

--
Dan Cândea
Does God Play Dice?

--
Linux-cluster mailing list
Linux-cluster@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/linux-cluster



[Index of Archives]     [Corosync Cluster Engine]     [GFS]     [Linux Virtualization]     [Centos Virtualization]     [Centos]     [Linux RAID]     [Fedora Users]     [Fedora SELinux]     [Big List of Linux Books]     [Yosemite Camping]

  Powered by Linux