i'm building software needs high availability, want use mysql master-master row-based replication.
my issue need handle concurrent inserts on table unique index. technique select , insert on duplicate key update if insert happens after select won't have duplicate key error.
the problem statement unsafe row-based , can break replication.
so what's high availability system mysql ?