It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

Having trouble with mysql 8.1 and jira

After I add the following parameters 

innodb_large_prefix=ON
innodb_file_format=Barracuda

 

in the my.cnf file I'm not able to restart mysqld on centos 7

 

Any suggestions?

2 answers

Hi Deep,

If you're unable to start MySQL after these changes, it means the MySQL does not support the parameters you've entered. The best way to see why this is happening by looking at the mysql logs. You can also post your questions in mysql forums for getting better solution.

 

-Thanks

Shankar

0 votes
Andy Heinzer Atlassian Team Oct 07, 2019

Hi Deep,

I understand you are trying to use MySQL 8.1 with Jira.  Unfortunately, Jira Server does not yet support this version of that database.  Please see our Supported platforms documentation for Jira 8.4.  While MySQL is listed on that page, it does indicate that only the 5.6.x and 5.7.x version are actually supported for current Jira 8.4 installations.   Please also note that you do need to use the MySQL Connector/J 5.1 driver.  Trying to use other more recent versions are known to cause problems here.

Once you have a supported database version, I would recommend trying to follow our guide on Connecting Jira applications to MySQL 5.7. This way you can make sure that you setup this database in a manner that Jira is expecting to be avoid a number of known configuration problems.

I hope this helps.

Andy

Suggest an answer

Log in or Sign up to answer
Community showcase
Published in Jira

The add-in you’ve been waiting for: Jira Cloud for Excel 🙌

Introducing Jira Cloud for Excel Here at the product integrations team at Atlassian, we are thrilled to announce the new Jira Cloud for Excel add-in! This add-in lets you export Jira data directly ...

865 views 6 24
Read article

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you