Jira Server using H2 for Production use

[Henry Lepsi]

Hi There.

I am working on a plan to implement Jira Server into our organisation. I have been looking thru Atlassian Documentation and checking any topics in Community. I have noticed that the use of H2 for production use is not recommended. Could anyone please advice and confirm:

1. Will Atlassian support Jira using H2 in Production?

2. What are the reasons why we should not use H2 for our Jira Server Production deployment?

Any assistance would be most appreciated.

Thank you.

[Nic Brough -Adaptavist- · Accepted solution]

1.  Not officially.  They will only support you on one of the four supported databases

2. Because it fails, usually catastrophically (although I've seen a couple of cases where it corrupts data without totally failing) and without warning.  The risk of that happening increases as you put more data into it.

[Henry Lepsi]

Thanks for your answer Nic, much appreciated.

A follow-up question please ... If we choose MySQL what kind/level of support should I expect from Atlassian to resolve any issues we may have between Jira and MySQL?

I'm keen to understand if I should be costing in additional MySQL support over and beyond the support provided by Atlassian for Jira Server licence.

Thank you.

[Nic Brough -Adaptavist-]

They won't do deep-dive support on problems that are in the database server, they'd expect the vendor to do that.  But they absolutely support Jira while it's using one of the supported database systems.