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

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



On 02/19/2011 08:22 AM, Dan Candea wrote:
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 redhat com
https://www.redhat.com/mailman/listinfo/linux-cluster
you could try with ndb tables,  it's the mysql cluster engine


AFAIK this still requires a "data storage" node (which is centralized), but I may be totally outdated on the subject.


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