Jira and MySQL vs. PostgreSQL

Rodolfo Romero
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.
August 18, 2011

We are setting up a new Jira instance and we would like to know if there is any advantage when using one or the other between MySQL and PostgreSQL databases.

3 answers

1 accepted

4 votes
Answer accepted
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.
August 18, 2011

No really large advantage to using either of them. I've used both quite happily, and would recommend them over MS-SQL instantly (and Oracle, but to a much lesser extent - Oracle works, but does need a bit more TLC than MySQL or PostgreSQL).

The right answer is "whichever one you prefer". If you don't have a strong preference and want someone else to make the decision for you, then go with PostgreSQL because that's what Atlassian recommend, use, and code for first. I personally have a slight preference for PostgreSQL because I found setting up PostgreSQL a lot easier than MySQL.

5 votes
Bob Swift (personal)
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.
August 18, 2011

PostgreSQL - we started with MySQL a long time ago and switched over many years ago. Very stable and has the best Atlassian support. They recommend it if you don't have some other preference.

0 votes
epicSpecialist
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!
October 27, 2013

PG it is then :-)

Suggest an answer

Log in or Sign up to answer