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.

1. MySql
2. MSSQL
3. Oracle

[Nic Brough _Adaptavist_ · Accepted solution]

The best answer I can give to this is:

1. Use one of the four Atlassian support
2. 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:

1.  PostGreSQL - it's at the top of the list because it's the one Atlassian work with the most
2. 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
3. Oracle
4. 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.
   
   

[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.

[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.

[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.

[Nic Brough _Adaptavist_]

If you run into a bug that affects a write cycle, with strict mode off, it's more likely to allow broken data to go into the database.  This is a very rare occurrence though, and does require that a bug is hit at a low level.  I think the strict mode checking is a strong recommendation rather than an absolute requirement

[Thanny Lopez]

Hi, I will read the types of strict modes but I don't know how choose: STRICT_ALL_TABLES or STRICT_TRANS_TABLES,. I'll use MySQL enterprise 5.7.23.

Thanks for your comments.

[Mohamed Riza]

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.

[Tejas_Naik]

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.

[Ganesh_Gembali]

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

[Nic Brough _Adaptavist_]

MySQL then.

[Yogesh Mude[Jira]]

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.

[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 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....

[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.

[Nic Brough _Adaptavist_]

I'd strongly recommend MySQL first (as PostGres isn't a good choice due to your DBA's willingbess to support it)

MS-SQL is a poor performer when it comes to Atlassian applications - usually in fourth place (crept into third for Confluence)