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; } } }

Preferable database for JIRA/Confluence

Gigaset Communications Sp_ z o_o_

Please propose the best database engine for running a JIRA/Confluence instance.

I found an issue here: https://jira.atlassian.com/browse/CONF-12465

At the bottom, Charles Miller wrote that the best solution is the one for which we have experience.

It's quite old post so do you still stand by this opinion?

Maybe from your experience with different customers, you recommend specific engine?

We are considering MSSQL and PostgreSQL. Do you know any advantages/disadvantages between them?

Thank you

Michal

Accepted answers

Nic Brough -Adaptavist-

Atlassian recommend PostGreSQL first and MySQL second.

I'd never recommend MSSQL over those two, or even Oracle to be frank, especially for java based tools. I've never had database problems with Post or My with Atlassian products, but MSSQL has turned out to be an absolutely monumental pain in the neck, repeatedly.

However, Charles' advice is good. My experience is based on not really having DBA expertise on hand. You may need it if you use MSSQL. You almost certainly won't need it for day-to-day usage if you use Post or My (barring doing the standard backups/failover stuff). If you have expert MSSQL people on hand, and you are comfortable with MSSQL, and not with the others, then use it.

All comments

RianA

Hi Michal,

There are some advantages and disadvantages for both engine. However just give you some idea, we use PostgreSQL for our OnDemand platform.

Hope it helps.

Nic Brough -Adaptavist-

Atlassian recommend PostGreSQL first and MySQL second.

MatthewC

I'd agree with Nic and take PostgreSQL & Oracle over MS-SQL. If MS-SQL is what you know then it can work but don't ever be tempted to use the MS JDBC drivers. Atlassian warn you off them for a reason. Unfortunately, it means you loose the ability to do any kind of failover but that 0.1% of uptime wasn't worth the 99.9% of degraded performance.

Go with your strengths and if you know PostgreSQL then your question has been answered!

LuizA

Hello Michael,

Just in addition to the previous answers, we also use PostgreSQL and MySQL in the most of the times in our test instances without any problem, both DBs are recommended.

Regards,

LJ.

stuartu

We've used Jira and Confluence on Oracle for years without any problem.

The other question is whether you want to run on Linux or Windows. It also depends on what skills you have in your business to run the infrastructure.

Nabil Sayegh

We've used SQL Server and it's a pain in the A***, actually it's unusable with JIRA.

steffensd

We are using MS SQL Server for both Jira and Confluence without any problems.

Fabián Escalant

What's the problem with SQL server?

Nic Brough -Adaptavist-

It's poorly supported by MS as well - when I first ran into problems with it, MS support told us to try their drivers instead of the jtds ones. The MS drivers do not work - they feel like they haven't been tested, just thrown out there to pretend that MS supports java.

That said, it can work fine. It does work fine in a lot of cases. But don't bet on it.

Nabil Sayegh

SQL Server frequently DEADLOCKs and SQL Server is poorly supported by Atlassian.

Pranjal Shukla_ajgmbg

Do we have a hierarchy? I know PostGre is the one recommended by Atlassian. Out of Oracle and SQL Server, which one would you recommend the most?

Nic Brough -Adaptavist-

Oracle. The answers here haven't changed in the last 3 years. The preferred order is very much Postgres first, MySQL a close second, Oracle third, and Microsoft in a very distant fourth place. The only time I'd recommend MS-SQL is when your organisation has no support expertise for the others.

Nabil Sayegh

True, MS SqlServer is the worst, deadlocks everywhere and badly supported. The only officially supported jtds driver is old as the hills.

Nic Brough -Adaptavist-

Yes, it's very poorly supported by Microsoft - they can't even get their own drivers to work, let alone support other drivers.