Jira Databases - Which one to chose?

Hello All;


We are currently evaluating Jira and thinking of moving to the enterprise edition and still deliberating between Server & Data Center editions.

Ir-respectively, I am interested in understanding what most people choose as the back-end database technology.

  • SQL Server would be the obvious
  • MySQL / PostgreSQL seem interesting
  • Oracle is way to expensive

So just curious, who runs what and how did you decide which vendor to go with ... was it cost or just preferred in your company.

And what is performance like on your selected DB technology

 

2 answers

This widget could not be displayed.
Gaston Valente Community Champion Jan 16, 2018

Robert,

Generally, you are not in the liberty of choose what db technology to use, you just go with the db that is being use in production for the company you work with.

I have experience working with large jira instances with sql server and oracle without any problem.

Atlassian usually recommends Postgresql if you can choose, but from my point of view, you need to choose the one of the list of supported dbs that your company uses.

This widget could not be displayed.

Postgres is probably the most widely used, because of the combination of cost and that Atlassian develop for it first, and use it for Cloud.
I tend to recommend Postgres second, for those reasons, then often MySQL third, Oracle fourth, and MS-SQL last.  I've had poor experiences with all four of them, but MS-SQL has by far given me the most pain over the years.But.  That's for an empty-site recommendation when someone is building a new stack and has not got a preference for some reason.  As Gaston points out, the first choice of database should always be "the one your organisation supports best".

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted 10 hours ago in New to Jira

Are you planning to trial, or are currently trialling Jira Software? - We want to talk to you!

Hello! I'm Rayen, a product manager at Atlassian. My team and I are working hard to improve the trial experience for Jira Software Cloud. We are interested in   talking to 20 people planning t...

32 views 1 0
Join discussion

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