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

[Dan Candea]

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?