Does Jira Server supports mirrored SQL databases

[Étienne Borella]

Hi

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!

[Nic Brough -Adaptavist- · Accepted solution]

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.