←back to thread

Upgrading Uber's MySQL Fleet

(www.uber.com)
234 points benocodes | 1 comments | 14 Oct 24 12:08 UTC | HN request time: 0s | source
Show context
remon ◴[14 Oct 24 14:48 UTC] No.41838059[source]▶
Impressive numbers at a glance but that boils down to ~140qps which is between one and two orders of magnitude below what you'd expect a normal MySQL node typically would serve. Obviously average execution time is mostly a function of the complexity of the query but based on Uber's business I can't really see what sort of non-normative queries they'd run at volume (e.g. for their customer facing apps). Uber's infra runs on Amazon AWS afaik and even taking some level of volume discount into account they're burning many millions of USD on some combination of overcapacity or suboptimal querying/caching strategies.
replies(5): >>41838139 #>>41838199 #>>41838202 #>>41839045 #>>41839409 #
Jgrubb ◴[14 Oct 24 14:57 UTC] No.41838139[source]▶
See, the problem is that the people who care about cost performance and the people who care about UX performance are rarely the same people, and often neither side is empowered with the data or experience they need to bridge the gap.
replies(1): >>41839066 #
bushbaba ◴[14 Oct 24 16:28 UTC] No.41839066[source]▶
Hardware is cheap relative to salaries. It might take 1 engineer 1 quarter to optimize. Compare that to a few thousand per server.
replies(3): >>41839204 #>>41840085 #>>41840375 #
1. Jgrubb ◴[14 Oct 24 18:01 UTC] No.41840085{3}[source]▶
Ok but we're in a thread about Ubers cloud bills, which are probably well into the 9 figures annually. It definitely gets talked about in board meetings.

Global public cloud spend is hundreds of billions of dollars a year. I wouldn't be surprised if it's AWS's marketing team that came up with the talking point about how much more expensive developer time is.

Edit: put this another way- wherever you work, you might know what parts of the architecture need some performance work but do you know what parts of the architecture cost the most money?