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?
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.
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.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
Thank you, I will try to use PostgreSQL 11.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.