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

科技回声

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

GitHubTwitter

首页

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

资源链接

HackerNews API原版 HackerNewsNext.js

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

MySQL Sharding at Quora

138 点作者 jinqueeny大约 5 年前

11 条评论

bcassedy大约 5 年前
Is Quora really big outside the US or something? I find it difficult to reconcile their scale challenges with the fact that I don't know a single person that uses Quora outside of when the come up in google search results.
评论 #22993481 未加载
troughway大约 5 年前
While this is a great read, I'm excited to find out more about the tech challenges behind their login wall.
JohnBooty大约 5 年前
<p><pre><code> A couple of years ago, our infrastructure team implemented the ability to move a table from one MySQL host to another. This allowed us to have multiple masters with different tables on different masters, which we refer to as “vertical sharding”. Each one of these masters, along with its slaves, is called as a “partition” at Quora. </code></pre> I nearly stopped reading here.<p>Naming things is hard, but why would they choose a term (&quot;partition&quot;) that has already existed for many decades in the same context?<p>That&#x27;s nonsensical.
评论 #22991691 未加载
评论 #22990834 未加载
评论 #22991361 未加载
gokaygurcan大约 5 年前
<a href="https:&#x2F;&#x2F;www.raphkoster.com&#x2F;2009&#x2F;01&#x2F;08&#x2F;database-sharding-came-from-uo&#x2F;" rel="nofollow">https:&#x2F;&#x2F;www.raphkoster.com&#x2F;2009&#x2F;01&#x2F;08&#x2F;database-sharding-came...</a><p>Nice article from Raph Koster. Especially if you played Ultima Online by any chance.
awinter-py大约 5 年前
&#x27;shard user scale data, centralize or mirror small scale data&#x27; (the A1 A2 B C D E diagram) is a useful point<p>&#x27;obvious in retrospect&#x27; I suspect to a lot of teams that add sharding to their system
RoboTeddy大约 5 年前
Would Google Cloud Spanner work well for a workload like this one? Why or why not?
评论 #22990732 未加载
评论 #22988672 未加载
roskilli大约 5 年前
Since it&#x27;s range based sharding, was Vitess ever considered (a popular CNCF MySQL range sharding cluster approach that came out of YouTube)?
评论 #22989231 未加载
fovc大约 5 年前
&gt; The result is that we do very few joins in MySQL<p>I realize depending on your data model some of this is unavoidable once you shard, but it sounds like they did this even before sharding.<p>What&#x27;s the reason to do that? Seems like you either end up with long transactions or doing MVCC in app code
评论 #22988684 未加载
评论 #22988381 未加载
评论 #22992371 未加载
zerr大约 5 年前
Comment from the representative (probably) of the &quot;Chinese Quora&quot; is interesting as well :)
评论 #22990599 未加载
TekMol大约 5 年前
Interesting that they still use MySql and did not switch to MariaDB.<p>What is HNs opinion on MySql vs MariaDB?
评论 #22988932 未加载
评论 #22988981 未加载
makz大约 5 年前
This is going to be very useful for one of the projects I’m working on, thanks for sharing