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 Join to answer
Community showcase
Sarah Schuster
Posted Jan 29, 2018 in Jira

What are common themes you've seen across successful & failed Jira Software implementations?

Hey everyone! My name is Sarah Schuster, and I'm a Customer Success Manager in Atlassian specializing in Jira Software Cloud. Over the next few weeks I will be posting discussion topics (8 total) to ...

2,775 views 11 18
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot