One jira - two databases?

Hello everybody :)

I got interesting question, is that possible to have one jira connected to two databases? I mean one instance oj normal Jira and two databases, one base is in this case main and it's used constantly, secon one is to generate reports. Second one is needed to reduce traffic on the first one . Is that possible to perform somethink lke this on one instance of Jira?

Cheers

1 answer

1 accepted

3 votes

Not in Jira.

Jira needs a single database connection, it won't write to two databases. So forget that idea straight away.

However, you are on the right track. Most database servers allow you to replicate. The server listens for changes in database A and copies the changes over to database B. The Jira connected to database A doesn't know or care about replication, it's all done by the database software.

You can then report off database B. You can also use it in case of disasters, and a simple backup regime could be to break replication, backup B (instead of A), and re-enable replication. (There are better ways of doing backups depending on your database, but this one is easy to do and easy to explain). The only thing to remember is "never write to database B, except by replication"

This is quite a common configuration and one that's often recommended (without a lot of detail on your setup, servers and support, I can't guarantee it's right for you, but it's definitely worth a look).

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Julia Dillon
Posted Apr 17, 2018 in Jira

Tell us how your team runs on Jira!

Hey Atlassian Community! Today we are launching a bunch of customer stories about the amazing work teams, like Dropbox and Twilio, are doing with Jira. You can check out the stories here. The thi...

808 views 2 19
Join discussion

Atlassian User Groups

Connect with like-minded Atlassian users at free events near you!

Find a group

Connect with like-minded Atlassian users at free events near you!

Find my local user group

Unfortunately there are no AUG chapters near you at the moment.

Start an AUG

You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs

Groups near you