Jira DB on SQL

[Leonardo Vasquez]

I have a Jira instance set up on my SQL server and I am planning to set up a second Jira instance using the same SQL server. Can the 2 Jira's DB located on the same SQL instance.

[Nic Brough -Adaptavist-]

Yes.  They need to be in separate schemas/db areas so that they do not share tables or spaces, but you can run many Atlassian systems with a single instance of a database.

[Leonardo Vasquez]

Nic, You meant that If I have a SQL server called SQLServ, I can have 2 DBs Jira1 and Jira2 under that SQL instance.  I need to have the 2 Jira's instance separate since they belong to 2 different departments. 

[Nic Brough -Adaptavist-]

Sorry, I missed your reply.

Yes, having Jira1 and Jira2 under a single instance is absolutely fine.  The stuff I have at home all runs off one database server (single process) with several databases on it - Jira, Confluence, development Jira, dev Confluence, mail, large file store and so-on

[Leonardo Vasquez]

Nic, 

Thanks again for your reply. I have another question, I have a Bitbucket server already set up and I am planning to start setting up the Jira application. What is you recommendation regarding having Jira and BitBucket on the same VM? 

Thanks

[Nic Brough -Adaptavist-]

Should work fine, as long as the VM has enough resource to run both!

[Vickey Palzor Lepcha]

@Leonardo Vasquez  First of all one SQL  Server can have multiple DB or Schema , where you can run not just jira but any other applications , say confluence. They just should run separately.

One point though - why do you have two JIRA for two departments ? Multiple Departments can work in one JIRA instance based on how JIRA works.

[Vickey Palzor Lepcha]

I don't think you would want to waste on two jira instances ( production) which means two jira production licenses. 

[Leonardo Vasquez]

Vickey, 

Thanks for your input. I am supporting 2 different companies and one of them it is currently using Jira and the second one is going to start doing it. that is why I was asking if I can have 2 Jira's db on the same SQL instance.

Thanks