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

Dan Candea dan.candea at quah.ro
Sat Feb 19 10:22:05 UTC 2011

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 at redhat.com
> 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?

More information about the Linux-cluster mailing list