16 ms·
How transactions work when you end up querying different shards?
by Thaxll 3y ago
How transactions work when you end up querying different shards?
- blauditore 3y agoIIUC they never have db transactions across shards, because customers are basically data silos, which makes sharding quite straightforward.
- simonw 3y agoI imagine that's one of the reasons they have "colos" - you can aim to collocate tables that are likely to be part of the same transaction in the same shard by putting them in the same colo group.