Upgrading MySQL

Hello,

We are (still) using XWiki 12.2.1 and 14.7 (two installations) with MySQL 5.7 on the same server (so both XWiki installations are using the same MySQL service).
We are to upgrade XWiki to the latest 16.3.1 for both installations (but we have to upgrade 14.7 installation first) and we are forced to update MySQL to 8.0.
What order of upgrades do you advise or is there any incompatibility among these versions? I mean if we upgrade MySQL first, will it be compatible (after migrating JDBC driver either) with both XWiki versions?
Or the other way to upgrade XWiki first, will 16.3.1 compatible with the current MySQL 5.7?

Thanks in advance.

In theory, the version of the MySQL server should not be much of a problem (provided it’s at least 5.7, which is your case) whatever version of XWiki you are using and the MySQL connector 8.x officially support 5.7 servers.

Just be careful that recent versions of the MySQL connector made quite a mess of the timezone handling (but might mainly impact Linux systems and not Windows, for example) and added some new protections, leading to having to add a few things to the hibernate configuration. It generally involves the following parameters in the connection URL:

  • useSSL (useSSL=false when you don’t use SSL to connect to the MySQL server)
  • connectionTimeZone: sometimes the connector does not recognize the timezone of the MySQL server, so you have to be more explicit
  • allowPublicKeyRetrieval (the Debian package uses allowPublicKeyRetrieval=true by default)
1 Like

Thanks for the reply.
We like theories, but I trust you.
I have already been noticed about connectionTimeZone issue, but will check all three you mentioned regarding the connector.
Thanks again.