on-premise Jira and Confluence server - same database or separate?

[Jeff Brooker]

Hi, I am setting up my first Jira and Confluence "server" setups and am halfway through the setup - I have Jira setup with the DB residing on one of my SQL servers. 

My question is, do I need to setup a new, separate DB for my installation of Confluence or can it use the same DB as the Jira software uses?

Our setup is going to be very small, single server that runs both pieces of software (Jira and Confluence) for under 10 users of both software.

Thanks in advance!

[Pavel Potcheptsov · Accepted solution]

The best is to have separate databases for Jira and Confluence since there could be same name for tables and each instance can interfere the other one.

[Jeff Brooker]

After looking it more, it appeared to require this and so that is what I did however thanks for following up.

[Alexis Robert]

Hi @Jeff Brooker , 

the recommandation is to have separate servers or VM to run Jira and Confluence, as it's better performance wise.

For the database, it's fine to use the same shared MySQL instance, it's pretty much the norm for database servers anyway.

Let me know if this helps, 

--Alexis

[Jeff Brooker]

Thanks, we are not sure how widely this will be used and we were planning using an existing MS SQL server and so I went ahead and installed both products on the same Windows 19 vm with separate DB's and so we'll see how it goes however thanks for your response.