Checklist after upgrading to MySQL 8?

We’re testing database upgrade from MySQL 5.7 to 8 on staging server.

I’ve followed 2 database articles (links at the bottom) for the upgrade and have checked the known issues listed.
After upgrading to MySQL 8, we’re checking the logs and going through our workflow to make sure everything is in working order.

Just wondering if there is a must-do test after database switch/upgrade that isn’t mentiond in the articles?

https://confluence.atlassian.com/adminjiraserver0813/switching-databases-1027137473.html
https://confluence.atlassian.com/adminjiraserver0813/connecting-jira-applications-to-mysql-8-0-1027137457.html

Hi there…I’m currently running Jira 9.1 with MySQL 5.7 and looking to upgrade MySQL to 8.x and then Jira to the latest version.

Did your MySQL upgrade go smoothly? I assume you installed MySQL 8.x on your Jira server and then imported a backup of your database from 5.7 and reconnected Jira to the new database?

Thanks
Jon

1 Like