Jira Mysql Master master replication

Question

I am looking to stand up an HA database behind Jira to allow for a 'warm' failover.  In mysql you have to change the autoincrement value when using a master/master replication.

Does Jira/Confluence do anything with autoincrement?

Has anyone used Jira/Confluence with Maser/Master replication in mysql?

It would be nice if the system supported NDB but I dont believe it does...

Ken · Answer

Yes I noticed.  I was thinking of doign MASTER-MASTER replication for an easy cold standby (I read its 'hard' to flip a slave to a master and back).

But I dontk now if Jira uses the autoincrement values...

lrobertson39 · Answer

Hi,

I have looked into doing this before, however it is not possible to set up Jira to point to multiple databases. The best that can be achieved is to have a cold-standby maser-slave replication that can then be relied upon should the master fail. This may require a reboot/re-index against the new database.

Unfortunately clustering of Jira doesn't seem to be high on Atlassian's plans (https://jira.atlassian.com/browse/JRA-7330)