Which DB is better for Jira?

[Ivan Savvateev]

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?

[Robert Dzido _Almarise_ · Accepted solution]

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-]

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.

[Ivan Savvateev]

Thank you, I will try to use PostgreSQL 11.