HNHacker News
TopNewBestAskShowJobs

itcmcgrath

1,102 karma · joined November 15, 2010

All opinions expressed or implied are mine and not the opinions of my employer.

I do database stuff. Cloud@Neo4j. Ex-Google databases (Datastore, Firestore, Bigtable, App Engine Search)

https://twitter.com/daniswrong https://stackoverflow.com/users/153407/dan-mcgrath

submissionscomments
itcmcgrath··on Bringing Pokémon GO to life on Google Cloud
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 as ceilings or upper bounds, hence why they are static - this are the numbers that traffic was expected to eventually reach at peak.So you can think of it as, "we thought we'd be looking at graphs that had this line as the top and traffic would be some curve underneath.

Obviously from the graph shown here, we/they needed a tall graph.

itcmcgrath··on Bringing Pokémon GO to life on Google Cloud
Wired has some stats from a 3rd party: https://www.wired.com/2016/09/pokemon-go-just-fine-without/
itcmcgrath··on Bringing Pokémon GO to life on Google Cloud
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 large launch.

The Niantic team did incredible things given the instant historic success that became Pokemon Go.

itcmcgrath··on Bringing Pokémon GO to life on Google Cloud
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.
itcmcgrath··on Bringing Pokémon GO to life on Google Cloud
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". The answer to to the first one turned out to history making ; no-one in their right mind would bet on happening beforehand, and the second turned out to be "Yes".
itcmcgrath··on Bringing Pokémon GO to life on Google Cloud
"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.
itcmcgrath··on Bringing Pokémon GO to life on Google Cloud
If you encountered bugs that only occur because your the largest ever, I'm sure you'll have the political pull :)
itcmcgrath··on Bringing Pokémon GO to life on Google Cloud
"Niantic phoned in to Google CRE for reinforcements" -> Note this was post-launch on the world's largest ever mobile launch.
itcmcgrath··on Bringing Pokémon GO to life on Google Cloud
Who said it was a capacity issue? The very next paragraph: "Not everything was smooth sailing at launch! When issues emerged around..."
itcmcgrath··on Google Cloud Datastore serves over 15 trillion queries per month
15 trillion/month is almost 6 million queries/second average. We're also replicated across multiple regions (Data centers) in a multi-master configuration.
itcmcgrath··on Microsoft SQL Server Images Available on Google Compute Engine
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 probably be changed to the blogs title "Advancing enterprise database workloads on Google Cloud Platform".

itcmcgrath··on Civilization 6 is coming in October, with big changes
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.wikipedia.org/wiki/Shadow_President

itcmcgrath··on Google Cloud Datastore simplifies pricing, cuts cost for most use-cases
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/datastore/docs/pricing

"For example, in the current pricing, writing a new entity with 1 indexed property would cost 4 write operations. In the new pricing, it would cost only 1 entity write. Similarly, deleting this entity in the current pricing would cost 4 write operations, but in the new pricing it would cost only 1 entity delete."

itcmcgrath··on Elimination of HIV-1 Genomes by CRISPR/Cas9 Gene Editing
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 as a joke, without Googling.
itcmcgrath··on The Sign Up with Google Mistake You Can't Fix
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 related systems.

itcmcgrath··on Alphabet Becomes the Most Valuable Public Company in the World
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 Apps for Work numbers, excluding consumers - obviously you can't compare just a subset with a total.
itcmcgrath··on Camera Zapping: Using Lasers to Temporarily Neutralize Cameras
That concept is used in Daniel Suarez's book 'Influx' to avoid AI systems doing facial recognition.
itcmcgrath··on Amazon Goes After Dropbox, Google, Microsoft with Unlimited Cloud Drive Storage
Agreed, but the point still stands. 'Unlimited' does not change definition based on price point. Especially if competitors offer paid-for limits above your 'unlimited', wouldn't that literally be false advertising? (Note: I'm not saying Amazon is, just addressing the above interpretation of 'Power user'
itcmcgrath··on Amazon Goes After Dropbox, Google, Microsoft with Unlimited Cloud Drive Storage
Drive has plans up to 30TB, so it would be disappointing if 10-20TB counted as unusual w.r.t 'unlimited' plan.
itcmcgrath··on Apple Acquires FoundationDB
All sorts of ways around that, so it's unlikely you would get a contract that precludes you not being out of support before the term is up.

As a thought experiment, if the company just went bankrupt and had no one working for it any more, you contract won't help right? Second part, what happens if someone just buys the assets (IP) and closes the company, then hires the old team? There are many possible variants here.

itcmcgrath··on Microsoft is giving away 100GB of OneDrive space to Dropbox users
I wonder how Dropbox feels about this considering their partnership announcement[1].

*Disclosure: I work on Google Drive

[1]: https://blogs.dropbox.com/dropbox/2014/11/dropbox-microsoft-...

itcmcgrath··on Alan Turing's notes found being used as roof insulation at Bletchley Park
Protip: Paste URL into Google Search, click result.

No paywall.

Same works with a lot of news sites that don't show paywalls on search traffic, but do on other referrals.

itcmcgrath··on Box Moves Ahead With IPO
That was their original headline I copy-pasted, they updated it to the new, better headline since.
itcmcgrath··on Database of all H1B petitions by company
s/H1B/LCA

I'm in that data, yet I have an E-3, not an H-1B.

One unintended consequence of moving to the US that I wasn't expecting is that now my friends back home roughly know what my salary is. I understood when moving here that the LCA (which has salary details) would be posted in public spaces, but I didn't notice it was also a matter of public record which in this day and age, means global public record.

I work in a smaller city, so while I may have been relatively anonymous in somewhere like Silicon Valley, my location, company and role and year of employment is more that enough to uniquely identify me. Such is life.

itcmcgrath··on Stealth Tank Unveiled by Poland
Thanks, that brings back memories. Looks like Poland decided to do a prequel :)

http://fc02.deviantart.net/fs27/f/2008/144/9/8/BattleZone___...

itcmcgrath··on Orkut shutting down September 30
You are correct, it's even named after the engineer that started it.
itcmcgrath··on Massive 'ocean' discovered towards Earth's core
Volume of oceans = 1,335,000,000 km^3 [1] Volume of earth = 1.08321e+12 km^3 [2]

So oceans only occupy 0.00123% of the Earth's volume. There's a lot of room below us.

[1]: http://ngdc.noaa.gov/mgg/global/etopo1_ocean_volumes.html

[2]: http://nssdc.gsfc.nasa.gov/planetary/factsheet/earthfact.htm...

itcmcgrath··on What if you didn't need money or attention?
Perhaps looking at it in a less black and white manner would show where it could help.

For instance, I work with Enterprise Software but not with cars. Perhaps being Stoic towards my material possessions( such as liking my Honda and stop looking at the Maserati I don't need) while still driving towards improvements in the areas that matter, such as my relationships (family, friends, strangers) and career (software, etc)?

itcmcgrath··on New Oculus Rift dev kit goes on sale for $350 today, likely ships in July
Indeed that would be assume. Solves the how many monitor's do you need debate, no longer restricts you by either available space or location. Would save money on power, etc. Seems like it could be a win for both the developer and budget.
itcmcgrath··on New Oculus Rift dev kit goes on sale for $350 today, likely ships in July
That would be an interesting research project. Track eye movement and focus. I could see how it would greatly enhancement the experience as well as introduce some fun & new rendering performance problems needing to solve.
← PreviousPage 4 of 8Next →