TE
科技回声
首页24小时热榜最新最佳问答展示工作
GitHubTwitter
首页

科技回声

基于 Next.js 构建的科技新闻平台,提供全球科技新闻和讨论内容。

GitHubTwitter

首页

首页最新最佳问答展示工作

资源链接

HackerNews API原版 HackerNewsNext.js

© 2025 科技回声. 版权所有。

Sharding data models

136 点作者 pedrobelo超过 7 年前

6 条评论

contingencies超过 7 年前
For financial transaction services I can recommend sharding first by customer, then by ledger. As a result, instead of enforcing double-entry book-keeping standards within a single database, do it at an application-specific middleware server layer to enforce only the guarantees you need.<p>As with all decisions, there are tradeoffs. For a little more up-front complexity and a tiny nominal performance hit, this allows maintenance, encryption, non-uniform storage paradigms to suit individual ledgers, rolling upgrades, storage location migration, and other cool stuff which is typically painful with traditional all-or-nothing RDBMS architectures.
评论 #15122470 未加载
njay超过 7 年前
Citus is a pretty powerful tool. We recently used Citus to help scale one of our databases and wrote a blog post about it: <a href="https:&#x2F;&#x2F;hipmunk.github.io&#x2F;posts&#x2F;2017&#x2F;Aug&#x2F;16&#x2F;a-fare-cache-in-a-sharded-data-cluster&#x2F;" rel="nofollow">https:&#x2F;&#x2F;hipmunk.github.io&#x2F;posts&#x2F;2017&#x2F;Aug&#x2F;16&#x2F;a-fare-cache-in-...</a>
评论 #15121523 未加载
xchaotic超过 7 年前
Then there&#x27;s the 0 model for sharding - don&#x27;t shard, just replicate everything, everywhere, with eventual consistency and MVCC
评论 #15121790 未加载
评论 #15123529 未加载
评论 #15123159 未加载
sdrothrock超过 7 年前
What ORMs out there natively support sharding well? I use Django the most and whenever I look into Django sharding, I don&#x27;t see very many options being kept up to date...
评论 #15122170 未加载
评论 #15122073 未加载
评论 #15122910 未加载
Beanis超过 7 年前
What distinction is being made between sharding by entity and sharding a graph? The approach seems to be the same, just with different naming.
评论 #15122488 未加载
edem超过 7 年前
I would have liked to read more about graph sharding. The article was rather sparse about it.