logoalt Hacker News

zozbot234today at 2:10 AM1 replyview on HN

I know they said that, but in fact sharding is entirely a database-level concern. The application need not be aware of it at all.


Replies

EB66today at 2:40 AM

Sharding can be made mostly transparent, but it's not purely a DB-level concern in practice. Once data is split across nodes, join patterns, cross-shard transactions, global uniqueness, certain keys hit with a lot of traffic, etc matter a lot. Even if partitioning handles routing, the application's query patterns and its consistency/latency requirements can still force application-level changes.

show 2 replies