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.
replies(8):
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.
MySQL 8.4 was released in April 30, 2024.
Their criteria for a "battle tested" MySQL version is probably much more rigorous than the average CRUD shop.
There are sometimes temporary views to keep the old and new code working during gradual transitions.
It certainly has a drop-swap approach which does a table rename, even though the resulting table ends up with the same name as before.
That's how I encountered the MySQL table-rename-crash bug.