Join the community to find out what other Atlassian users are discussing, debating and creating.
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.
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.
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.
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
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?
Should work fine, as long as the VM has enough resource to run both!
@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.
I don't think you would want to waste on two jira instances ( production) which means two jira production licenses.
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.
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no Community Events near you at the moment.
You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events