Can we use mysql 5.5 for jira 8.2.3?

Question

Hi,

We are planning to upgrade our jira server from version 7.9 to 8.2.3. we have a MySQL database server where numbers of databases is running. Currently our jira 7.9 is running MySQL 5.5 and i need to know if we  upgrade Jira  to 8.2.3, Do we need to upgrade MySQL server from 5.5 to 5.7. Or shall we use MySQL 5.5 for jira 8.2.3. what will be the issues we can face if we are not going to upgrade the mysql 5.5.

Thanks

BR,

Adnan

Jimmy Seddon · Answer

Hi Adnan,

I honestly couldn't tell you what will happen if you upgrade to version 8.0 on MySQL 5.5.

Please remember that the support platforms document is Atlassian's way of communicating with you what they have tested and what they gaurentee will work, and if you have issues with what they support they will help you resolve issues on those supported platforms.

Now I know from first hand experience that the Atlassian support team is awesome and will go out of their way to try and help everyone they can, but using unsupported configurations can result in them being force to tell you to use a supposed platform when something isn't functioning the way you expect it to.

If you really want to try using MySQL 5.5 you should definately try it in a test environment first, but I would strongly advise against using unsupported platforms.

-Jimmy

Adnan_aa2oxg · Answer

Hello jimmy,

yes i know Jira 8.0 will no longer support the MySQL 5.5 database. That means MySQL 5.5 will continue working

But my question is this , can we use MySQL 5.5 with 8.x.  could it slow down jira or low performance? Or we will face in jira application errors ?. i need to know the detail answer why MySQL 5.7 is batter then 5.5 and what are the advantages and disadvantages with respect to jira applications performance and their usage.

BR,

Adnan

Jimmy Seddon · Answer

Hi @Adnan ,

Looks like MySQL 5.5 isn't supported for Jira 8.2.x in the supported platforms document:

https://confluence.atlassian.com/adminjiraserver082/supported-platforms-973503809.html

So you will need to look at upgrading that as a part of the upgrade to your Jira Server.

I hope that helps!

-James