Hacker News Board Hacker News, browsed like a classic message board
Live data from Hacker News

Upgrading Uber's MySQL Fleet

uber.com

Post reply on HN
Print view View original

71–80 of 215 posts

Re: Upgrading Uber's MySQL Fleet

#71

Post by greenie_beans »

Kennnan wrote: post #66
greenie_beans wrote: post #55

Earlier quoted context omitted.

beep boop i'm a capitalist robot pretty sure safe travels is critical to maximum value to their shareholders (aka stfu or tell me how this blog post has anything to do with maximize shareholder value https://www.uber.com/en-JO/blog/upgrading-ubers-mysql-fleet/... ... shareholder value is a dumb ass thing to prioritize over human life)

Honest question, how do you (or amyone) propose to vet drivers? They require drivers license and car insurance registration, anything like a CDL would make being a driver prohibitively expensive. Their rating system already works as a good signal the few times Ive used uber.

i don't know, i don't work there. i'm just somebody who almost died because one of their drivers was a terrible driver. that sounds like a problem they should figure out. dude didn't even know how to change a tire, so start with "basic knowledge of car maintenance." and a basic ability to speak english would be a good bar to meet, too. they'll let anybody with a driver's license, car, and a heart beat drive on that app. there should be a higher barrier of entry. but idk, i don't work there. this is just my experience as consumer.

also, the US should be wayyyyy stricter on who we issue drivers license to. so many terrible drivers on the road driving these death machines.

Re: Upgrading Uber's MySQL Fleet

#72

Post by hodgesrm »

excitive wrote: post #59
traceroute66 wrote: post #37

Earlier quoted context omitted.

> I can tell from a mile away that this is written by ChatGPT / Claude, at least partially. Whilst it may smell of ChatGPT/Claude, I think the answer is actually simpler. Look at the authors of the blog, search LinkedIn. They are all based in India, mostly Bangalore. It is therefore more likely to be Indian English. To be absolutely clear, for absolute avoidance of doubt: This is NOT intended a racist comment. Indian…

Can you elaborate on the last part? What are some stylistic patterns that are different when something is written by a US author v/s Indian?

Not exactly a stylistic difference but there are real differences in the dialects. Here's example from many moons ago: "Even I think that's a bad idea." That was an Indian colleague. It took me weeks to figure out that he was using "even" in place of "also."

In a like vein when Australians say "goodeye" they usually aren't talking about your vision.

Re: Upgrading Uber's MySQL Fleet

#73

Post by aster0id »

paradite wrote: post #24

I can tell from a mile away that this is written by ChatGPT / Claude, at least partially. "This distinction played a crucial role in our upgrade planning and execution strategy." "Navigating Challenges in the MySQL Upgrade Journey" "Finally, minimizing manual intervention during the upgrade process was crucial."

Because the authors are likely non native English speakers. I'm one myself and it is hard to write for a primarily native English speaking audience without linguistic artifacts that give you away, or worse, are ridiculed for.

Re: Upgrading Uber's MySQL Fleet

#74

Post by gomoboo »

djbusby wrote: post #39
InsideOutSanta wrote: post #31

Earlier quoted context omitted.

As somebody who has always used MySQL, but always been told that I should be using Postgres, I'd love to understand what the issues with VACUUM are, and what I should be aware of when potentially switching databases?

VACUUM and VACUUM FULL (and/or with ANALYZE) can lock tables for a very long time, especially when the table is large. Incantation may also require 2x the space for the table being operated on. In short: it's slow.

pg_repack gets rid of the need to lock tables for the duration of the vacuum: https://docs.aws.amazon.com/AmazonRDS/latest/UserGuide/Appen...

It is an extension though so downside there is it not being included in most Postgres installs. I’ve used it at work and it felt like a superpower getting the benefits of a vacuum full without all the usual drama.

Re: Upgrading Uber's MySQL Fleet

#75

Post by yeswecatan »

anonzzzies wrote: post #56
RedShift1 wrote: post #32

Earlier quoted context omitted.

Maybe just vacuum much more aggressively? Also there have been a lot of changes to the vacuuming and auto vacuuming process these last few years, you can pretty much forget about it.

Not in our experience; for our cases it is still a resource hog. We discussed it even less than a year ago with core devs and with a large postgres consultancy place; they said postgres doesn't fit our use case which was already our conclusion, no matter how much we want it to be. Mysql is smooth as butter. I have nothing to win from picking mysql just that it works; I rather use postgres as features / not oracle but…

What is your use case?

Re: Upgrading Uber's MySQL Fleet

#76

Post by dweekly »

Am I the only one who saw "delve" at the top of the article and immediately thought "ah, an AI generated piece"? Well, that and the over-structured components of the analysis with nearly uniform word count per point and high-complexity but low signal-to-noise vocabulary using phraseology not common to the domain being discussed. (The article doesn't scan as written by an SRE/DBA.)

Re: Upgrading Uber's MySQL Fleet

#77

Post by devbas »

dweekly wrote: post #76

Am I the only one who saw "delve" at the top of the article and immediately thought "ah, an AI generated piece"? Well, that and the over-structured components of the analysis with nearly uniform word count per point and high-complexity but low signal-to-noise vocabulary using phraseology not common to the domain being discussed. (The article doesn't scan as written by an SRE/DBA.)

The introduction seems to have AI sprinkled all over it: ..we embarked on a significant journey, ..in this monumental upgrade.

Re: Upgrading Uber's MySQL Fleet

#78

Post by bob1029 »

sandGorgon wrote: post #65

so how does an architecture like "2100 clusters" work. so the write apis will go to a database that contains their data ? how is this done - like a user would have history, payments, etc. are all of them colocated in one cluster ? (which means the sharding is based on userid) ? is there then a database router service that routes the db query to the correct database ?

I imagine it works just like any multi-tenant SaaS product wherein you have a database per customer (region/city) with a unified web portal. The primary difference being that this is B2C and the ratio of customers per database is much greater than 1.

Re: Upgrading Uber's MySQL Fleet

#79

Post by V-eHGsd_ »

hodgesrm wrote: post #72
excitive wrote: post #59

Earlier quoted context omitted.

Can you elaborate on the last part? What are some stylistic patterns that are different when something is written by a US author v/s Indian?

Not exactly a stylistic difference but there are real differences in the dialects. Here's example from many moons ago: "Even I think that's a bad idea." That was an Indian colleague. It took me weeks to figure out that he was using "even" in place of "also." In a like vein when Australians say "goodeye" they usually aren't talking about your vision.

> In a like vein when Australians say "goodeye" they usually aren't talking about your vision.

They aren’t saying goodeye, they’re saying g’day (good day)

Re: Upgrading Uber's MySQL Fleet

#80

Post by [deleted] »

dweekly wrote: post #76

Am I the only one who saw "delve" at the top of the article and immediately thought "ah, an AI generated piece"? Well, that and the over-structured components of the analysis with nearly uniform word count per point and high-complexity but low signal-to-noise vocabulary using phraseology not common to the domain being discussed. (The article doesn't scan as written by an SRE/DBA.)

[deleted]
Post reply on HN