I've got two MySQL clusters that have Master-Master replication setup between them.
Most tables are log based, with only inserts and selects, so they don't have any problems with the replication.
However, I have a few tables that hold current 'state' information for a real time system. Entries in these tables are updated, and have a timestamp field showing their last update.
When replication breaks, the two clusters could be writing to the same rows.
Is it possible to have the replication keep the records that have the most recent updated column?
If not (and my research shows its not possible), what solutions could I use instead?