Looking for the perfect high availability with MySQL replication and concurrent inserts -


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 ?