MySQL 8.4.x Upgrade Experience

[Auto Junkie]

Hello,

Our ResourceSpace instance is currently backed by MySQL 8.0.42. All 8.0.x versions will be going EOL in April 2026. Has anyone done an in-place upgrade of MySQL 8.0.x to 8.4.x and can share their experience? There isn't much, if any information on the official RS website or KB pertaining to MySQL upgrades.

Thanks in advance!

[Dan Huby]

Hi,

We've an internal job to test against MySQL 8.4 and will patch as appropriate before the EOL date.

I would be interested to know if you've had any issues with 8.4 or if it just worked for you.

Dan

[Auto Junkie]

Hi Dan,

We have not upgraded to MySQL 8.4 yet. Are there any general things to look out for or do when upgrading the backend DB engine?

Thanks,

Auto

[Simon Annetts]

Hi,

I am currently running RS10.7 on MySQL 8.4.x from Oracle's MySQL repository on Ubuntu 24.04 without any noticable issues, but I did not try upgrading MySQL on an existing instance that was previously running 8.0.x. I expect there will be no issues with upgrading - MySQL is usually pretty good at upgrading any internal innodb data structures after an upgrade. I have also restored a Resourcespace database backup taken from MySQL 8.0.x into 8.4.x with no issues found - so this might a good backup option if just upgrading the backend MySQL breaks your data for some reason!

Simon

[Auto Junkie]

Thanks for sharing your experience, Simon! It helps to know that someone has 8.4.x in production already, even if it wasn't an in-place. We have a vanilla instance of RS so we'll try the in-place first and if that fail we'll try the restore.