News for hackers. Stuff that matters.

A comment on Ask HN: Has distributed SQL come of age?. Parent comment

Re:Ask HN: Has distributed SQL come of age? by nitsuaeekcm on Wednesday August 18, 2021 @06:36PM (#28228020)
Vitess and Citus seem to be half-way between manual sharding and distributed SQL. They really discourage cross-shard updates, for instance, whereas they're a really natural part of distributed SQL: > The authors of Vitess recommend that you design your VSchema so that cross-shard updates (and 2PC) are not required. https://vitess.io/docs/reference/features/two-phase-commit/

Maybe though it's just a fundamental coordination problem one can't work around.

[ Parent | on HN ]
Re:Ask HN: Has distributed SQL come of age? by simonw on Thursday August 19, 2021 @02:32AM (#28231012)
I'm very OK with that limitation - when I'm designing a sharded system I'm happy to take shards into account and arrange my entities such that I can apply updates to them grouped on a single shard.

The value I want is help directing those write queries to the correct shards, and some assistant with cross-shard read queries.

[ Parent | on HN ]