Upgrading Uber's MySQL Fleet

#1

Post by benocodes » Mon, Oct 14, 2024, 12:08 PM UTC

Re: Upgrading Uber's MySQL Fleet

#2

Post by tiffanyh » Mon, Oct 14, 2024, 12:36 PM UTC

Why upgrade to v8.0 (old LTS) and not v8.4 (current LTS)?

Especially given that end-of-support is only 18-months from now (April 2026) … when end-of-support of v5.7 is what drive them to upgrade in the first place.

https://en.m.wikipedia.org/wiki/MySQL

Re: Upgrading Uber's MySQL Fleet

#3

Post by gostsamo » Mon, Oct 14, 2024, 12:38 PM UTC

tiffanyh wrote: post #2

Why upgrade to v8.0 (old LTS) and not v8.4 (current LTS)? Especially given that end-of-support is only 18-months from now (April 2026) … when end-of-support of v5.7 is what drive them to upgrade in the first place. https://en.m.wikipedia.org/wiki/MySQL

> Several compelling factors drove our decision to transition from MySQL v5.7 to v8.0:

Edit: for the downvoters, the parent comment was initially a question.

Re: Upgrading Uber's MySQL Fleet

#4

Post by whalesalad » Mon, Oct 14, 2024, 12:39 PM UTC

So satisfying to do a huge upgrade like this and then see the actual proof in the pudding with all the reduced latencies and query times.

Re: Upgrading Uber's MySQL Fleet

#5

Post by edf13 » Mon, Oct 14, 2024, 12:41 PM UTC

3 million queries/second across 16k nodes seems pretty heavy on redundancy?

Re: Upgrading Uber's MySQL Fleet

#6

Post by candiddevmike » Mon, Oct 14, 2024, 12:42 PM UTC

Does Uber still use Docstore? I'd imagine having built an effectively custom DB on top of MySQL made this upgrade somewhat inconsequential for most apps.

Re: Upgrading Uber's MySQL Fleet

#7

Post by gregoriol » Mon, Oct 14, 2024, 12:42 PM UTC

Wait until they find out they have to upgrade to 8.4 now

Re: Upgrading Uber's MySQL Fleet

#8

Post by withinboredom » Mon, Oct 14, 2024, 12:43 PM UTC

edf13 wrote: post #5

3 million queries/second across 16k nodes seems pretty heavy on redundancy?

That's 200 qps per node, assuming perfect load balancing.

Re: Upgrading Uber's MySQL Fleet

#9

Post by johannes1234321 » Mon, Oct 14, 2024, 12:47 PM UTC

tiffanyh wrote: post #2

Why upgrade to v8.0 (old LTS) and not v8.4 (current LTS)? Especially given that end-of-support is only 18-months from now (April 2026) … when end-of-support of v5.7 is what drive them to upgrade in the first place. https://en.m.wikipedia.org/wiki/MySQL

Since direct upgrade to 8.4 isn't supported. They got to go to 8.0 first.

Also: 8.0 is old and most issues have been found. 8.4 probably has more unknowns.

Re: Upgrading Uber's MySQL Fleet

#10

Post by gregoriol » Mon, Oct 14, 2024, 12:48 PM UTC

gregoriol wrote: post #7

Wait until they find out they have to upgrade to 8.4 now

And also all the passwords away from mysql_native_password