Y
HN Search
Hacker News Search
new
|
comments
|
top
|
jobs
itcmcgrath
searching PlanetScale…
1.
▲
2.
▲
3.
▲
4.
▲
5.
▲
6.
▲
15 ms
·
91.
▲
by
itcmcgrath
10y ago
It's a lot more than a thin layer, but like most systems at Google is a specialized layer that utilizes built on top of more fundamental building blocks that are designed and proven to do a particular job really well. In this case Mega
92.
▲
by
itcmcgrath
10y ago
PM for Cloud Datastore here. We also have multi-document transactions, self-joins, active-active multi-region replication by default, secondary indexes, composite indexes, a SQL-like query language, PAYG model with no capacity planning, etc
93.
▲
by
itcmcgrath
10y ago
It doesn't explicitly call out the E-3 in the leaked document, however IANAL and couldn't tell if any of the clauses implicitly affect it. [I'm on an E-3]
94.
▲
by
itcmcgrath
10y ago
http://quakes.globalincidentmap.com/
95.
▲
by
itcmcgrath
10y ago
There is some, when users battle gyms they are battling with other users Pokemon which would be from anywhere in the world. When the Pokemon on the Gym loses it needs to be removed in a transaction with an update on the gym. This takes the
96.
▲
by
itcmcgrath
10y ago
How about this - Pokemon search trend for the last 5 years: https://www.google.com/trends/explore?q=pokemon If this doesn't clearly show how crazy this growth was compared to what anyone was expecting, I'm no
97.
▲
by
itcmcgrath
10y ago
No arguments there. There's a balance that needs to be struck between technical detail and marketing appeal. Not everyone is going to agree on where that balance is, less so when you're trying to share sensitive information withou
98.
▲
by
itcmcgrath
10y ago
"For instance on launch day in America and Asia I would have expected insane numbers (many hundreds of million)." Given no app had ever done this in history over the first few weeks, yet alone on launch day with no marketing, I do
99.
▲
by
itcmcgrath
10y ago
They ran a closed beta.
100.
▲
by
itcmcgrath
10y ago
I cannot dive into too much more detail than is in the graph since it's still sensitive information. Y-axis is essentially traffic to Cloud Datastore (think: after layers of caching, etc), x-axis is date. The 2 lines can be thought of
101.
▲
by
itcmcgrath
10y ago
Wired has some stats from a 3rd party: https://www.wired.com/2016/09/pokemon-go-just-fine-without/
102.
▲
by
itcmcgrath
10y ago
Yes, and I can tell you even though I spend every day working with extremely large scale systems I wouldn't have told them "you should expect 10x larger", yet alone 50x. Their initial estimates would still have been an very l
103.
▲
by
itcmcgrath
10y ago
When you write blog posts reflecting on something that happened you often use/think in past tenses. Don't try reading too much between the lines on things like that.
104.
▲
by
itcmcgrath
10y ago
I can guarantee you the chart is accurate as I created it. Yes they did expect change, but the only number that matters for this graph is "how big can we get" and then "if we get that big by the end, is there enough capacity&
105.
▲
by
itcmcgrath
10y ago
"the next day". Looking on the graph shows there wasn't a lot of time between initial launch, and exceeding the world-wide worst case estimates.
106.
▲
by
itcmcgrath
10y ago
If you encountered bugs that only occur because your the largest ever, I'm sure you'll have the political pull :)
107.
▲
by
itcmcgrath
10y ago
"Niantic phoned in to Google CRE for reinforcements" -> Note this was post-launch on the world's largest ever mobile launch.
108.
▲
by
itcmcgrath
10y ago
Who said it was a capacity issue? The very next paragraph: "Not everything was smooth sailing at launch! When issues emerged around..."
109.
▲
by
itcmcgrath
10y ago
15 trillion/month is almost 6 million queries/second average. We're also replicated across multiple regions (Data centers) in a multi-master configuration.
110.
▲
Google Cloud Datastore serves over 15 trillion queries per month
(cloudplatform.googleblog.com)
10 points
by
itcmcgrath
10y ago
|
1 comments
111.
▲
Google Cloud Bigtable is generally available for petabyte-scale NoSQL workloads
(cloudplatform.googleblog.com)
8 points
by
itcmcgrath
10y ago
|
0 comments
112.
▲
by
itcmcgrath
10y ago
The title, while interesting, isn't the posts title and hides that the post contains a lot more such as Cloud SQL 2nd Gen's GA, Cloud Bigtable's GA, Cloud Datastore's GA (and serving 15 trillion requests per month). It p
113.
▲
'Pokémon GO' Is About to Surpass Twitter in Daily Active Users on Android
(forbes.com)
2 points
by
itcmcgrath
10y ago
|
0 comments
114.
▲
by
itcmcgrath
10y ago
I remember playing a very old game called 'Shadow President' that I thought was particularly fun. I'm an Aussie and Australia in the game always frustrated the heck out of me. I often nuked it. :-/ https://en.
115.
▲
Google Cloud Datastore gets faster cross-platform API
(cloudplatform.googleblog.com)
4 points
by
itcmcgrath
11y ago
|
0 comments
116.
▲
by
itcmcgrath
11y ago
It's not a percentage change, it's a structural change so it depends on how you use Cloud Datastore (largely around indexes). There is an example on the pricing page near the bottom: https://cloud.google.com/datast
117.
▲
Google Cloud Datastore simplifies pricing, cuts cost for most use-cases
(cloudplatform.googleblog.com)
17 points
by
itcmcgrath
11y ago
|
3 comments
118.
▲
by
itcmcgrath
11y ago
I found this + the op's comments fascinating purely because I wouldn't have been able to tell if both were real, or just fake technical talk of the ilk my friends and I sometimes do with meaningless software/hardware jargon a
119.
▲
by
itcmcgrath
11y ago
Direct Deposit and/or BillPay is what I used in Australia before moving to the US. I also miss things like BPay where I can pay all my bills via my Internet Banking portal. Moving to the US felt like a 10+ year regression in money rela
120.
▲
by
itcmcgrath
11y ago
Having worked on the Drive team, I can assure you Google Apps (which includes GMail, the Docs editors, and Drive) has much more than 50 million. A quick search on public figures for these services will give better numbers. Edit: Those are A
More ›