nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Which database is best option for Jira?

Ganesh Gembali

Which of the following database is recommended for JIRA and if you can provide few points why it will be helpful.

MySql
MSSQL
Oracle

Accepted answers

Nic Brough -Adaptavist-

The best answer I can give to this is:

Use one of the four Atlassian support
Use the one that your organisation is most comfortable with. If you have a set of DBAs who support your databases, ask them which one they'd like you to use. The one they support the best

If I have complete free-range on which one to choose for JIRA, I would put the supported four in this order:

PostGreSQL - it's at the top of the list because it's the one Atlassian work with the most
MySQL - A close second, although slipping recently, as since JIRA 6, it seems to be getting more and more complex to configure correctly. The project I'm on currently (upgrading and merging 5 JIRA systems from MS-SQL and Oracle) has run into all sorts of issues, but a good chunk of them went away last week when we moved to PostGreSQL
Oracle
MS-SQL way down the list. I've had strings of problems with MS-SQL that go away when you move to one of the other three. The fact that Microsoft can't even be bothered to write a usable driver for their own database tells me how much they care. I'm told it's got better in more recent versions. I still avoid it.

All comments

Yogesh Mude[Jir

Hi @Ganesh Gembali,

The MySQL driver is no longer bundled with JIra.

Jira does not support 4 byte characters, regardless of MySQL version.

If you must use 4 byte characters we recommend you use PostgreSQL.

please look on this page.

Nic Brough -Adaptavist-

The best answer I can give to this is:

Use one of the four Atlassian support
Use the one that your organisation is most comfortable with. If you have a set of DBAs who support your databases, ask them which one they'd like you to use. The one they support the best

If I have complete free-range on which one to choose for JIRA, I would put the supported four in this order:

PostGreSQL - it's at the top of the list because it's the one Atlassian work with the most
MySQL - A close second, although slipping recently, as since JIRA 6, it seems to be getting more and more complex to configure correctly. The project I'm on currently (upgrading and merging 5 JIRA systems from MS-SQL and Oracle) has run into all sorts of issues, but a good chunk of them went away last week when we moved to PostGreSQL
Oracle
MS-SQL way down the list. I've had strings of problems with MS-SQL that go away when you move to one of the other three. The fact that Microsoft can't even be bothered to write a usable driver for their own database tells me how much they care. I'm told it's got better in more recent versions. I still avoid it.

Teja

Hi,

There is no such best option. But whichever the DBA team supports, we can use that

Normally people will use MySQL which is a open source.

Nic Brough -Adaptavist-

p.s. the list is slightly different for Confluence - MS-SQL arguably works better than Oracle, and almost as well as MySQL for Confluence.

Ganesh Gembali

@Teju Naik Thanks for reply. Our DBA supports all above 3.

Nic Brough -Adaptavist-

MySQL then.

Nic Brough -Adaptavist-

Ok, given your comment above, MySQL is probably the best for you, so the specifics on that are:

Be careful to get the collation and locale right before you do anything with JIRA (follow the recommendations in the setup document to the letter. But take the advice of your DBAs on anything that is not covered in that doc)

Watch out for users trying to be "clever" with emojis and graphics - importing emojis and other stuff into MySQL does not work. You'll be fine with most data though.

Mohand TALBI

Hi,

We use PostgreSQL, good performance.

Pablo Rizzi

hello, is depend if you have db or not.

for example, i use in 3 different companies the 3 db.

mysql is cheap, but have some limitations. is open Source Database. take care with the support if you have any issue.

MSSQL is expensive but not expensive than Oracle and you pay attention with the cost of the DBA. Its not so simple to find good and cheap Oracle DBA and MSSQL DBA.

The best are MSSQL and ORACLE, both are the same level for our usability. and both have a good performance and scalebility, redundance, etc.

The more important is the people support you have to admin the db. and pay attention with the cost of the licence (MSSql and Oracle).

if you are a begginer i recommend to start with MSSQL then if you grow, you can migrate.

Ganesh Gembali

Hi Nic,

Couldn't thank you yesterday because "limit on no of comments" as I just registered. Thanks for explanation and suggestions. In our infrastructure we have mysql clusters but with strict mode off. But I see Atlassian recommending to use with strict mode. What kind of issues I might face with out strict mode using mysql.

Ganesh Gembali

Hi Pablo,

Thanks for the suggestion. From DB cost and DBA perspective, all 3 are equal for us. And all 3 are existing in our infra already.

Pablo Rizzi

hi Ganesh, ok. then i recommend MSSQL in first place and second place Oracle, just becouse of there are more technnical people of MS than ORacle. But both are very good database if you hace DBA.

Keep in touch.

Please, feel free in ask more questions....

Mohamed Riza_s7j38y

Hi Ganesh,

Which database is best option for Jira?

Without a doubt, although this is not an option in your list, the recommended database would be PostgreSQL. This is the database that we at Atlassian also use for JIRA Cloud instances. This recommendation is only included in the latest supported platforms page with a complete explanation as to why we recommend this: https://confluence.atlassian.com/display/adminjiraserver071/Supported+Platforms#Supportedplatforms-postgresnote

Ganesh Gembali

I wish I can use postgres. But its not supported in our infra. So I have listed 3 dbs supported . So we are going with msyql as community suggesting it is next best. Thanks for taking time to provide your inputs.

Pablo Rizzi

in my case, the configuration in MSSQL was easy and suppose to you will be the same. may in Oracle is a little more difficult it, just a little bit.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira

jira-administration

jira-core