I have been introduced to this from my local MySQL team. Just want to confirm, how is the conflict resolution solved? e.g., two different updates on two different server at about the same time.
If two people have modified the same data, then one of them will get a similar error to a deadlock. The other is free to proceed.