single database to multiple jira instances

I tried to Connect two jira instances to single database i got an error like  "You have specified a database that is not empty, please specify an empty database".

is it possible to connect single database to multiple jira instances ? 

 

Thanks,

Indra.

2 answers

1 accepted

2 votes
Accepted answer
Alexey Matveev Community Champion Oct 30, 2017

Hello,

It is not possible to connect two insances of JIRA server to a single database. You have to use Jira Data Center for this purpose

i am using Jira DataCenter licence but got same issue.please suggest me how to connect.

When you are doing a fresh installation you cannot install JIRA on a non-empty database. 
For that purposes you need to give an empty database. 

However, Im not sure if it'll work but you can do the following to try this out:
You install JIRA 1 with empty DB1.
You install JIRA 2 with empty DB2.

Then you point the dbconfig.xml for JIRA 2 server to the DB1. 
You can try doing that. 
I haven't tested it out but I'll be interested to know the result. 

Hi tayyab,

                Thanks for your help its working .

Hi indra,
Did it work for you with single db with two Jira applications?

No, I can be absolutely certain that it did not.

You can not use one database with more than one Jira Server application. 

You can get Data Centre if you want many Jira nodes serving the same data, but a single database for many Jira installs Does.  Not.   Work.

This is a good solution and it seems to work. The issue is with the file based resources like attachments, logos ...etc. Keeping them in sync between the two servers will be challenging. will require some kind of NAS based solution.

No, it does not work.

You can not use one database with more than one Jira Server application.  You will find the second one shuts itself down when it spots the first is already running.  Even if you manage to prevent that, you will immediately start corrupting the database, ruining your data completely.

The docs for installing Data Centre covers the shared storage it needs.

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Oct 16, 2018 in Jira

Looking for anyone who made the switch to Data Center

The Jira Marketing team is putting together an ebook on migrating to Data Center. We're looking for pro tips on how you staffed your project team and organized your Proof of Concept. Share yo...

1,416 views 17 10
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