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.

Technical Challenges Developing a Distributed SQL Database

237 pointsby sickeythecatabout 6 years ago

9 comments

kthejoker2about 6 years ago
As a precursor to this (excellent, in depth) post I also recommend Martin Kleppmann&#x27;s Designing Data-Intensive Applications, which is (to date) the definitive 101 book on the topic.<p>He also did these awesome Tolkien-esque maps of the database engine ecosystem: <a href="https:&#x2F;&#x2F;martin.kleppmann.com&#x2F;2017&#x2F;03&#x2F;15&#x2F;map-distributed-data-systems.html" rel="nofollow">https:&#x2F;&#x2F;martin.kleppmann.com&#x2F;2017&#x2F;03&#x2F;15&#x2F;map-distributed-data...</a><p>Anyway, I inject this sort of stuff directly into my veins, so thanks very much for the post!
rekorosabout 6 years ago
Good post! May sound more credible if you have mentioned that YugaByte started as a fork of Apache Kudu and some of the design decisions and technical challenges that you mention were addressed by the code that was already there before your fork.
评论 #19761003 未加载
Nicanabout 6 years ago
I find Spanner an absolute beautiful database, and I recommend people to checkout CockroachDB as well, which is inspired by Spanner.
评论 #19760906 未加载
mikeceabout 6 years ago
The article makes mention of Aurora and Spanner as inspiration; did CosmosDB not exist yet? I realize Cosmos is really more of a document database but given its ability to be queried with SQL in addition to massive horizontal scale and global replication seems like it should be more or less in the discussion.<p>Reference to querying Cosmos with SQL: <a href="https:&#x2F;&#x2F;docs.microsoft.com&#x2F;en-us&#x2F;azure&#x2F;cosmos-db&#x2F;how-to-sql-query" rel="nofollow">https:&#x2F;&#x2F;docs.microsoft.com&#x2F;en-us&#x2F;azure&#x2F;cosmos-db&#x2F;how-to-sql-...</a>
评论 #19761871 未加载
评论 #19763152 未加载
chalianwarabout 6 years ago
Following research papers from academia also explored similar problem:<p>1) BESPOKV: Application Tailored Scale-Out Key-Value Stores <a href="http:&#x2F;&#x2F;people.cs.vt.edu&#x2F;~butta&#x2F;docs&#x2F;sc18-bespokv.pdf" rel="nofollow">http:&#x2F;&#x2F;people.cs.vt.edu&#x2F;~butta&#x2F;docs&#x2F;sc18-bespokv.pdf</a><p>2) ClusterOn: Building Highly Configurable and Reusable Clustered Data Services using Simple Data Nodes <a href="http:&#x2F;&#x2F;people.cs.vt.edu&#x2F;~butta&#x2F;docs&#x2F;hotstorage16-clusteron.pdf" rel="nofollow">http:&#x2F;&#x2F;people.cs.vt.edu&#x2F;~butta&#x2F;docs&#x2F;hotstorage16-clusteron.p...</a><p>DynomiteDB from Netflix allowed to scale singe server NoSQL stores. <a href="https:&#x2F;&#x2F;github.com&#x2F;Netflix&#x2F;dynomite" rel="nofollow">https:&#x2F;&#x2F;github.com&#x2F;Netflix&#x2F;dynomite</a>.
评论 #19775444 未加载
protomythabout 6 years ago
I wonder where the lessons of NonStop SQL fit into the picture? It seems like there is some knowledge to mine there.
评论 #19762689 未加载
jayd16about 6 years ago
Interesting that spanner doesn&#x27;t support foreign keys. Is this a fundamental limitation or just a missing feature?
评论 #19761029 未加载
评论 #19760859 未加载
评论 #19760784 未加载
tyopiuyabout 6 years ago
Not really developing a distributed dB but using one. Inaccurate and misleading title
评论 #19761603 未加载
tripleeabout 6 years ago
That wasn&#x27;t immediately relevant to me, but is definitely a good read since I imagine I&#x27;ll be dealing with these problems within a year.<p>Thanks!
评论 #19778081 未加载