…. It does NOT mean you can’t modify data on multiple cluster nodes simultaneously.  You can. It does NOT set an… a player makes an achievement, your application updates this table with a statement like this: UPDATE achievements SET count = count + 1 where… (100, 1); UPDATE groups SET last_joined=NOW(), last_user_id=100 WHERE id=1; COMMIT; How often might multiple users join…

… think of a scenario where you update a row multiple times before committing: Your apps send frequent updates into a message queue. Then a consumer thread reads from the MQ and applies updates to the database, many MQ events per commit. If a…

…. I’m not sure how useful it is to update the same row multiple times in a single transaction, READ-UNCOMMITTED isn… not if your HA allowed writes (however briefly) to hit multiple nodes during a writer node failover. However, glad to learn…

…. E.g. ActiveMQ, RabbitMQ, Resque, etc. All applications would send updates to the MQ in lieu of writing directly to the… comment, “I’m not sure how useful it is to update the same row multiple times in a single transaction.”

… some other job (that had an open trx and had updated some meta field, but had not committed) and so could… yet. This type of system simply won’t work across multiple nodes in Galera, however. @Bill — is this the kind of…

…. Some other solutions might actually cause RTT penalty for each update. Second I think as the technology evolves we should see… the hot spots also can often be used by using multiple rows (say 10) where you modify different rows to reduce…