Forums

Articles
Create
cancel
Showing results for 
Search instead for 
Did you mean: 

Which DB is better for Jira?

Ivan Savvateev
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 16, 2020

I want to migrate my Jira local server (version 8.11.0, working on Windows 10) from the H2 embedded database to a "real" DB. Which is better and simpler: MySQL or PostgreSQL?

1 answer

1 accepted

0 votes
Answer accepted
Robert Dzido _Almarise_
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 16, 2020

Most of Jira instances (including Cloud instances) running PostgreSQL and it's best DB for Jira.

Setting it up is as simple as a few SQL Commands and one file edit (pg_hba.conf) and shall take no longer than 20 minutes.

Consider using version 11 as it's newest supported.

Nic Brough -Adaptavist-
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
July 16, 2020

There's not a lot in it, but the order I recommend if given a free hand is Postgres, MySQL, Oracle and MS-SQL last. 

This is mostly because Atlassian run Postgres and build and test for it first.  MS-SQL last because I've had so... many... problems with it, and a long time ago, it was so bad, we ended up with Atlassian despairing and advising us to simply move to any of the other three.  It has improved a lot since then though.

But.  My real life recommendation is "Use the database you have the most expertise with".  If you've got loads of MS-SQL and a DBA team who look after it a lot - use that.  Your expertise and experience with your chosen database is by far the most important factor.

Like # people like this
Ivan Savvateev
I'm New Here
I'm New Here
Those new to the Atlassian Community have posted less than three times. Give them a warm welcome!
July 16, 2020

Thank you, I will try to use PostgreSQL 11.

Suggest an answer

Log in or Sign up to answer
DEPLOYMENT TYPE
SERVER
VERSION
8.11.0
TAGS
AUG Leaders

Atlassian Community Events