News for hackers. Stuff that matters.
Re:Why we lost Uber as a user by DiabloD3 on Monday August 01, 2016 @08:21AM (#12201791)
Uber relies entirely on their database. If the database is slow, or cannot be considered reliable under extreme load, or can lose data in ways that are hard to recover, then Uber can potentially lose a lot of money especially during peak hours.

Yes, I'm aware there are systems for MySQL to handle failure, but I'm also aware of the systems for Postgre, and Postgre's failure handling seem to be far saner and easier to recover from. Defense in depth against failure is easier in Postgre from my experience.

This would be like Elon Musk blogging about how "oh yeah, sometimes the brand new Tesla factory shuts down completely because sometimes the power goes out; but we're using really popular well known power distribution systems, so we're industry compliant, so everything is okay."

If Elon Musk blogged that, HN would go apeshit, and rightfully so.

Re:Why we lost Uber as a user by VLM on Monday August 01, 2016 @10:17AM (#12202523)
A better standard HN car analogy:

Postgreql is trustworth and predictable and engineered and engineerable. Its like a German union automobile plant press operator sitting down on the job and crossing his arms until the broken safety switch is fixed, which will take precisely 3.25 hours and cost $X while the resulting assembly line shutdown costs 1000 x $X. But it'll be safe and nobody gonna lose an arm. Your downtime and related costs are more or less predictable. Maybe not the highest productivity plant in the division, but nice safety record.

Mysql is best effort. The safety switch on the press breaks, redlining that machine and shutting down the entire plant. Hmm if I stick my arm in that 50 ton press while its operating, that'll hurt a bit, so lets just not do that. Dude's a real tryhard, which always ends like you'd expect. Of course safety regulations were literally written in blood so at some unpredictable time in the future you'll get a $1M personal injury lawsuit for loss of an arm and a $10M OSHA fine, and the plant will be shut down for the criminal investigation for a random indeterminate amount of time plus the interval required to remove arm from press. Your downtime and costs are completely unpredictable, but probably mostly over a very long term for many people on average lower than postgresql. The plant will have a higher productivity metric result, and also a worse safety record.

Re:Why we lost Uber as a user by DiabloD3 on Monday August 01, 2016 @05:57PM (#12206375)
I applaud you. That is exactly MySQL vs Postgresql in a nutshell.
Re:Why we lost Uber as a user by ec109685 on Tuesday August 02, 2016 @12:40AM (#12207859)
Can you site any of this? Facebook, Twitter, Google (for a long while), Uber, Yahoo all run critical systems on MySQL.
Re:Why we lost Uber as a user by VLM on Tuesday August 02, 2016 @10:51AM (#12210356)
No I won't.

However there is an important point that philosophy doesn't matter when times are good. Its only when the tool is misused or there's a malfunction that the underlying philosophy even shows up.

It doesn't matter which system you use when you try to store Aug 1 2016 into a date column, but (at least in the old days) it was very interesting trying to store February 30th into the databases. Insert anyway with a warning? Round up, down, or stick in a null? Normalize it to being March 2nd ish? Insert fails completely with an error? This has varies with time and configuration but in a "general sweep of history" manner you can guess correctly most of the time what each DB does.

Also there's nothing wrong in any way with a critical system that drops into philosophical best effort mode during a crisis rather than paralytic halt mode. Well, there's nothing wrong with it as long as the system was engineered with that in mind and neither the dev nor ops people are surprised by that behavior. Sometimes that is the right thing to do.

Re:Why we lost Uber as a user by sciurus on Monday August 01, 2016 @09:58AM (#12202390)
Here is an Uber engineer's talk about their worst outage ever. 16 hours of downtime for their API as they repeatedly try and fail to promote a new postgresql master and reparent slaves to it.

https://www.youtube.com/watch?v=bNeZYVIfskc&t=26m54s

https://surge.omniti.com/2015/images/presentations/MattRanne... (Slides 39-63)

Re:Why we lost Uber as a user by merb on Monday August 01, 2016 @01:27PM (#12204243)
the problem mostly happened cause ppl just ignored the "running out of disk space" message. Would happen on mysql, too. And I really wouldn't want that to happen on galera, I guess that would be a way bigger desaster.
Re:Why we lost Uber as a user by matwood on Monday August 01, 2016 @02:03PM (#12204531)
Running out of disk space on any RDBMS is a bad day.
Re:Why we lost Uber as a user by GrinningFool on Monday August 01, 2016 @10:10AM (#12202472)
On the other hand, it's an internal thing. If it is a poor choice in the end, they'll change it -- that's what investors have confidence in.
Re:Why we lost Uber as a user by cdelsolar on Monday August 01, 2016 @02:15PM (#12204626)
Please don't call it Postgre...