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@xxxxxxxxxx
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.
--
Linux-cluster mailing list
Linux-cluster@xxxxxxxxxx
https://www.redhat.com/mailman/listinfo/linux-cluster