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
