Which database is suitable for Jira Data center (MySQL or Postgres)

Question

Hi All,

Is there any recommendation for which database we should use for the Jira data center (MySQL or Postgres)?

Advantages or Disadvantages is any?

Currently we are using MySQL 5.7 which is installed in-house and we are planing to migrate the Jira to AWS infra and want to use the RDS Aurora.

Any suggestions if anyone using the Aurora DB for there Jira.

Akhtaruzzaman SM · Answer

For Aurora only Postgres is supported by Atlassian is true; on the other hand it is Open Source and less costly. AKTAR

Sagar Mahajan_d8sqh7 · Answer

Hi @Glen2021 Yes, as mentioned by Ismael, for Aurora only Postgres is supported by Atlassian and for even on the self hosted Postgres is recommended by the community please find the below community post for more information :

https://community.atlassian.com/t5/Jira-Core-questions/Which-database-is-best-option-for-Jira/qaq-p/34484

Ismael Jimoh · Answer

Hi @Glen2021

I believe only Postgres as you are going to AWS Aurora.

You can find a list of supported database and their versions in the supported platforms page: https://confluence.atlassian.com/adminjiraserver/supported-platforms-938846830.html

Regards