On 02/09/2015 01:02 PM, Attila Fazekas wrote: > I do not see why not to use `FOR UPDATE` even with multi-writer or > Is the retry/swap way really solves anything here. <snip> > Am I missed something ? Yes. Galera does not replicate the (internal to InnnoDB) row-level locks that are needed to support SELECT FOR UPDATE statements across multiple cluster nodes. https://groups.google.com/forum/#!msg/codership-team/Au1jVFKQv8o/QYV_Z_t5YAEJ Best, -jay