Upgrading GitHub.com to MySQL 8.0(github.blog) |
Upgrading GitHub.com to MySQL 8.0(github.blog) |
It’s interesting that the current LTS for MySQL is already 5-years old (2018).
I’m surprised there isn’t a more current LTS.
https://en.m.wikipedia.org/wiki/MySQL
Especially when you see this quoted by MySQL team:
‘About every 2 years a new Long Term Support version will be released
If I recall correctly, this was one of the major reasons why people were deferring this upgrade.
---
> Most notably, we encountered a problem where queries with large WHERE IN clauses would crash MySQL. We had large WHERE IN queries containing over tens of thousands of values.
The need to rewrite queries is mildly concerning. If this was part of their Rails codebase, I'm curious if these patches will make it into the ORM.
Was there a reason this wasn’t done? The article seems rather explicit of running on top of Azure VMs.
I was thinking they could have been a planetscale customer.
I also assume they are sticking to MySQL LTS release. So their next upgrade to 8.4 will probably be next year.
Was it seamless? I recall GitHub being down a bunch lately, and even though the downtime is unrelated to the db upgrade, from the outside looking in, I don't know that I'd lean that hard on having done that seamlessly.
1. The entire premise of the blogpost is completely fabricated and they are lying through their teeth.
2. The downtime was unrelated, from a product that doesn't actually have the best track record here in general.
So ... what do you think?