Hacker News new | ask | show | jobs
by tehbeard 1356 days ago
Is there a write up somewhere on how you handled cross database transactions? E.g. Bob on db#12 gifts Alice on db#23 a "MegaPlushie(tm)"item?

Interested to know how you'd avoid duplicates and lost transactions while maintaining a comfortable level of performance/latency for an online game.

1 comments

With mysql this can be handled via XA transactions https://dev.mysql.com/doc/refman/8.0/en/xa.html