Upgrading from 5.5 to 5.7 - What is best practice?

[cfoskin]

When running a 5.5 pod on openshift, what is the procedure for performing an upgrade to version 5.7? Basically I am looking at upgrading but just replacing the image with the 5.7 version will not work due to changes that need to be made to tables etc.

[hhorak]

Upstream only supports upgrading from the previous version, so when going from 5.5, you need to upgrade to 5.6 first, and only then to 5.7.

[hhorak]

Some more upstream documentation is in https://dev.mysql.com/doc/refman/5.7/en/upgrading-strategies.html.

[hhorak]

E.g.:

• running mysql_ssl_rsa_setup if own SSL config is not provided is one thing.
• maybe, as a back-up, also support extensions using /docker-entrypoint-initdb.d
• an interesting feature is also MYSQL_ONETIME_PASSWORD, that makes the root password expired if set, although it's not clear to me what is the use case of this one, they just call it security features (https://github.com/docker-library/mysql/commit/141b713b8c973a7a2592b5f6bf9c44693fedea36).

Otherwise the containers are pretty much compatible in basic features

[phracek]

Closing this issue as upgrade from 5.5 -> 5.7 was deprecated a long time ago. Currently only 8.0 version is supported. We do not have capacity to fix this issue.

Feel free to re-open it, in case you want it. Closing it.