TE
TechEcho
Home24h TopNewestBestAskShowJobs
GitHubTwitter
Home

TechEcho

A tech news platform built with Next.js, providing global tech news and discussions.

GitHubTwitter

Home

HomeNewestBestAskShowJobs

Resources

HackerNews APIOriginal HackerNewsNext.js

© 2025 TechEcho. All rights reserved.

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

29 pointsby danielbryantukover 9 years ago

5 comments

danbrucover 9 years ago
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_ahover 9 years ago
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.
pbreitover 9 years ago
Anyone want to weigh in on whether or not Postgres is a viable option for this?
评论 #10927166 未加载
评论 #10927127 未加载
评论 #10926946 未加载
评论 #10927122 未加载
评论 #10926972 未加载
评论 #10927143 未加载
forgotmysnover 9 years ago
<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 未加载
bra2over 9 years ago
Read that as a drunk saying shemales...
评论 #10929941 未加载