27.10.2014 17:19, Ken Gaillot пишет:
On 10/25/2014 03:32 PM, Andrew wrote:
2) How to resolve split brain state? Is it enough just to wait for
failure, then - restart mysql by hand and clean row with dup index in
slave db, and then run resource again? Or there is some automation for
such cases?
Regarding mysql cleanup, it is usually NOT sufficient to fix the one
row with the duplicate key. The duplicate key is a symptom of prior
data inconsistency, and if that isn't cleaned up, at best you'll have
inconsistent data in a few rows, and at worst, replication will keep
breaking at seemingly random times.
You can manually compare the rows immediately prior to the duplicate
ID value to figure out where it started, or use a special-purpose tool
for checking consistency, such as pt-table-checksum from the Percona
toolkit.
Thanks, I'll try it next time. Currently I solved it via copying
consistent data to inconsistent node; but this caused near 30min
downtime (db size is about 100GB).
_______________________________________________
Pacemaker mailing list: Pacemaker@oss.clusterlabs.org
http://oss.clusterlabs.org/mailman/listinfo/pacemaker
Project Home: http://www.clusterlabs.org
Getting started: http://www.clusterlabs.org/doc/Cluster_from_Scratch.pdf
Bugs: http://bugs.clusterlabs.org