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

科技回声

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

GitHubTwitter

首页

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

资源链接

HackerNews API原版 HackerNewsNext.js

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

The Architecture of Schemaless, Uber Engineering’s Trip Datastore Using MySQL

29 点作者 danielbryantuk超过 9 年前

5 条评论

danbruc超过 9 年前
Color me skeptical, that looks like a pretty strange design to me, a database on top of a database [1].<p>[1] <a href="http:&#x2F;&#x2F;c2.com&#x2F;cgi&#x2F;wiki?GodTable" rel="nofollow">http:&#x2F;&#x2F;c2.com&#x2F;cgi&#x2F;wiki?GodTable</a>
评论 #10927540 未加载
ivan_ah超过 9 年前
I&#x27;ve been following these Uber engineering articles, and I think this is a very neat architecture. Append only + boring technology = solid stuff.<p>I&#x27;m curious to know how many shards per storage cluster they use and how this mapping is done. Is it fixed or can it change? I imagine a startup trying to use a similar setup could start with a few storage clusters, but then add more clusters as needs grow...<p>They say they use 4096 shards (presumably generated based on some part of `row_key` which is the trip id), but I&#x27;m not sure this is a generally-applicable strategy. e.g. if sharding in a social netowrk website is performed based on `user_id` then won&#x27;t be able to do joins across `user_id`s.
pbreit超过 9 年前
Anyone want to weigh in on whether or not Postgres is a viable option for this?
评论 #10927166 未加载
评论 #10927127 未加载
评论 #10926946 未加载
评论 #10927122 未加载
评论 #10926972 未加载
评论 #10927143 未加载
forgotmysn超过 9 年前
<a href="https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=10894047" rel="nofollow">https:&#x2F;&#x2F;news.ycombinator.com&#x2F;item?id=10894047</a>
评论 #10926812 未加载
bra2超过 9 年前
Read that as a drunk saying shemales...
评论 #10929941 未加载