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

Does Jira Server supports mirrored SQL databases

Étienne Borella

We'd like to implement mirroring for Jira Server instance (7.6, soon to be migrated to 7.7).

This article specifies that databases use Microsoft JDBC 6.2.1 Driver for SQL Server, which should support mirroring. But we are surprised that we don't find any post anywhere about mirrored databases, which we find suspicious.

Can you confirm if Jira supports mirroring, and if it is safe, or if it may have impact on the behavior of some plugins that may not be compatible.

Thanks for your feedback!

Accepted answers

Nic Brough -Adaptavist-

Yes, it will work on a mirrored database.

But.

MS are retiring mirroring at some point in the future

You must configure it so that the principal database does not change automatically. Jira must be offline if you are going to swap them over.

All comments

Nic Brough -Adaptavist-

Yes, it will work on a mirrored database.

But.

MS are retiring mirroring at some point in the future

You must configure it so that the principal database does not change automatically. Jira must be offline if you are going to swap them over.

Étienne Borella

Great, thanks Nic.

Indeed we are planning in the future to move to AlwaysOn, but are using mirroring for the moment.

Will Sargent

As a heads up, AlwaysOn Availability groups does not support the READ_Committed_Snapshot directive, which Jira acts like is a major issue. (I'm not a developer, just a power user so I couldn't say).

However, Jira is perfectly happy with SQL Server failover clustering (not alwayson availability groups).

The biggest downside is that it's not an instant failover.. so users might have a quick blip (like a 10-20 second window on my setup).

I had to roll back my whole new database setup and do it again when I figured this out, so hope this helps.

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

sql

jira

jira-administration

database