Re: Mysql community edition upgrade from 8.0.36 to 8.4 (LTS)

[Roberto de Bem]

Hi Raja,


>> Whether a direct in-place upgrade from 8.0.36 → 8.4 is supported (or if an intermediate upgrade step/version is recommended).
>> Any required pre-upgrade steps or mandatory fixes that should be completed before the upgrade.

The in-place upgrade from 8.0.36 to 8.4 is supported as you can see on the following link:
https://dev.mysql.com/doc/refman/8.4/en/upgrade-paths.html

There's one recommended pre-upgrade step: running the upgrade checker utility in MySQL Shell. Just so you know, this checker will let you know if something you are currently using (for example, a variable) doesn't exist in 8.4 and could cause an issue during the upgrade procedure.
https://dev.mysql.com/doc/mysql-shell/8.4/en/mysql-shell-utilities-upgrade.html



>> Any deprecated or removed features in MySQL 8.4 that could impact existing workloads.
That depends on the application usage of the features from each MySQL version. It's recommended to check further removals or incompatible changes from version to version:
https://dev.mysql.com/doc/refman/8.4/en/upgrading-from-previous-series.html

Furthermore, it's highly recommended to follow the steps from the following link:
https://dev.mysql.com/doc/refman/8.4/en/upgrade-best-practices.html


Cheers,
Roberto de Bem