Interesting reading: Spanner Whitepaper
https://cloud.google.com/spanner/docs/whitepapers/SpannerAnd...
Introducing Cloud Spanner, a Global Database Service
11–20 of 456 posts
Re: Introducing Cloud Spanner, a Global Database Service
#12> clients can do globally consistent reads across the entire database without locking
How is this possible across data centres? Does it send data everywhere at once?
Seems too good to be true of course but if it works and scales it might be worthwhile just not having to worry about your database scaling? Still I don't believe it ;-)
EDIT: further info...
> Spanner mitigates this by having each member be a Paxos group, thus ensuring each 2PC “member” is highly available even if some of its Paxos participants are down. Data is divided into groups that form the basic unit of placement and replication.
So it's SQL with Paxos that presumably never get's confused but during a partition will presumably not be consistent.
Re: Introducing Cloud Spanner, a Global Database Service
#13The white paper is available here: http://static.googleusercontent.com/media/research.google.co...
for anyone interested
Re: Introducing Cloud Spanner, a Global Database Service
#14> Today, we’re excited to announce the public beta for Cloud Spanner, a globally distributed relational database service that lets customers have their cake and eat it too: ACID transactions and SQL semantics, without giving up horizontal scaling and high availability. This is a bold claim. What do they know about the CAP theorem that I don't? Separately, (emphasis mine): > If you have a MySQL or PostgreSQL system th…
> What do they know about the CAP theorem that I don't?
Their statement, for what it's worth: https://cloudplatform.googleblog.com/2017/02/inside-Cloud-Sp...
Re: Introducing Cloud Spanner, a Global Database Service
#15> Today, we’re excited to announce the public beta for Cloud Spanner, a globally distributed relational database service that lets customers have their cake and eat it too: ACID transactions and SQL semantics, without giving up horizontal scaling and high availability. This is a bold claim. What do they know about the CAP theorem that I don't? Separately, (emphasis mine): > If you have a MySQL or PostgreSQL system th…
[deleted]
Re: Introducing Cloud Spanner, a Global Database Service
#16> Today, we’re excited to announce the public beta for Cloud Spanner, a globally distributed relational database service that lets customers have their cake and eat it too: ACID transactions and SQL semantics, without giving up horizontal scaling and high availability. This is a bold claim. What do they know about the CAP theorem that I don't? Separately, (emphasis mine): > If you have a MySQL or PostgreSQL system th…
They write that it's a CP system. So A is not guaranteed, but in practice they are able to provide A most of the time, with a private network and only 1 failure in all of 2016 (whatever that means).
Re: Introducing Cloud Spanner, a Global Database Service
#17> Today, we’re excited to announce the public beta for Cloud Spanner, a globally distributed relational database service that lets customers have their cake and eat it too: ACID transactions and SQL semantics, without giving up horizontal scaling and high availability. This is a bold claim. What do they know about the CAP theorem that I don't? Separately, (emphasis mine): > If you have a MySQL or PostgreSQL system th…
Eric Brewer who is the author of the CAP theorem works at Google now. He has a post here: https://cloudplatform.googleblog.com/2017/02/inside-Cloud-Sp....
Re: Introducing Cloud Spanner, a Global Database Service
#18> Today, we’re excited to announce the public beta for Cloud Spanner, a globally distributed relational database service that lets customers have their cake and eat it too: ACID transactions and SQL semantics, without giving up horizontal scaling and high availability. This is a bold claim. What do they know about the CAP theorem that I don't? Separately, (emphasis mine): > If you have a MySQL or PostgreSQL system th…
What do they know about the CAP theorem that I don't? I don't know your expertise on the subject, but they do have a post on this topic. Some highlights: "Does this mean that Spanner is a CA system as defined by CAP? The short answer is “no” technically, but “yes” in effect and its users can and do assume CA." "The purist answer is “no” because partitions can happen and in fact have happened at Google, and during som…
[deleted]
Re: Introducing Cloud Spanner, a Global Database Service
#19> Today, we’re excited to announce the public beta for Cloud Spanner, a globally distributed relational database service that lets customers have their cake and eat it too: ACID transactions and SQL semantics, without giving up horizontal scaling and high availability. This is a bold claim. What do they know about the CAP theorem that I don't? Separately, (emphasis mine): > If you have a MySQL or PostgreSQL system th…
Why? Strong consistency isn't mutually exclusive with scalability. Google has written about it at length[1][2][3].
Furthermore, there are already more than a few attempts underway to build scalable relational databases ("NewSQL") outside Google.[4]
1: https://research.google.com/pubs/pub36971.html
2: https://research.google.com/archive/spanner.html
3: http://datascienceassn.org/sites/default/files/F1%20A%20Dist...
4: http://db.cs.cmu.edu/papers/2016/pavlo-newsql-sigmodrec2016....
Re: Introducing Cloud Spanner, a Global Database Service
#20> Today, we’re excited to announce the public beta for Cloud Spanner, a globally distributed relational database service that lets customers have their cake and eat it too: ACID transactions and SQL semantics, without giving up horizontal scaling and high availability. This is a bold claim. What do they know about the CAP theorem that I don't? Separately, (emphasis mine): > If you have a MySQL or PostgreSQL system th…
> To understand how, read this post by the author of the CAP Theorem and Google Vice President of Infrastructure, Eric Brewer.
Seems like they might know a lot :)