one database config used by two jira Edited

perhaps opposite to one jira - two databases I read, which commented by @Nic Brough [Adaptavist] 

my question :

one database serving two jira instances would cause disaster ? dbconfig.xml will be same on the database connection, I think, so wonder is it possible I run jira 1 on one machine to access database 1,  then I install jira 2, still point out to database 1 ?  what would be happening ?

kind of reminding one servant two masters, but not at the same time :-D

any thoughts?  

Due to limited source, I only get one database for testing, so I wonder 'recycling' , however, should I contact DBA to wrap out whole database before I config it in another jira ? 

2 answers

For older versions of Jira, yes, it was a disaster.  Both of them would be unable to write issues correctly and their indexes fail rapidly.  If you left them long enough, with active users, you'd get a completely corrupt database.

Newer versions of Jira try to prevent the corruption - the first one to connect writes a record into a table which tells other installations that the database is in use, so they just shut down with an error saying the database is already in use by a previous Jira.

Thank you so much, @Nic Brough [Adaptavist].

my situation is to use SQL2014 for testing, but many times if possible, therefore, each new jira application launch, I just give same database config, that should be okay for jira software v7.6.0 without any extra work from DBA ? 

0 vote

No, you'll need to drop all the tables on each new run.  But you can use the same database over and over.

Thank you, @Nic Brough [Adaptavist],  our DBA gave me a database for testing, if I want to drop all the tables , what should I tell him?  can I run the query to get rid of tables on my given jiradbuser at all ?

no worries, I did something to let all tables 'gone', then recycle the database , so no bothering our DBA. 

not sure that's the final solution, but only for testing, on production, we would not change that much. :-)

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 Tuesday 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...

191 views 1 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