Re: Replication
Posted by:
Rick James
Date: September 16, 2014 11:11PM
> Now replication breaks.
That is the risk of being able to write to both Masters.
It is better to write to only one Master, and have the other one in read_only mode. Also, you could set my.cnf to bring up the Master in read_only mode. This is a nuisance, because you may have neither Master writable until you manually step in, but it is better than having replication broken and, furthermore, risk the data being terribly corrupt by duplicate keys going to both Masters.
Galera, Tungsten, Clustrix, and several others provide hands-free HA.
Subject
Views
Written By
Posted
1707
September 15, 2014 10:43PM
Re: Replication
920
September 16, 2014 11:11PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.