[Linux-cluster] MySQL MASTER->SLAVE agent?
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:
>> 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
>> This would pose as a good solution for environments without shared
>> storage and without DRBD.
> 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.
> Linux-cluster mailing list
> Linux-cluster at redhat.com
you could try with ndb tables, it's the mysql cluster engine
Does God Play Dice?
More information about the Linux-cluster