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
How to earn badges on the Atlassian Community

How to earn badges on the Atlassian Community

Badges are a great way to show off community activity, whether you’re a newbie or a Champion.

Learn more
Community showcase
Posted Wednesday in Jira

Join our webinar: How 1B+ feature flag events helped us build the new Jira

Every time you release software, there's a bit of risk – that there's a bug, that something breaks, or that the feature doesn't resonate with customers. Feature flagging helps make high stakes s...

133 views 0 3
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