Which database is best option for Jira?

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

 

6 answers

1 accepted

6 votes

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.

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

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.

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.

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

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.

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

MySQL then.

 

1 votes
Mohamed Riza Atlassian Team Jun 02, 2016

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

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.

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.


Hi,

We use PostgreSQL, good performance.

 

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.

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.

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

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.

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)

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

247 views 0 11
Read article

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot