Is it better to have JIRA and mysql on the same server, or to have the database on a separate server?

[Nic Brough -Adaptavist-]

Depends on your needs.  Using the same box reduces network traffic and dependencies and keeps things very simple - "that box runs all of Jira".  But a separate server means you know that the database server processes won't consume resources that JIRA could be using and vice-versa.  So there's no simple answer to this one really!

[Paresh Gandhi]

As Nic said, it depends. We have jira with 2000+ user and we have both database, jira and confluence on same server.

[Rich Quillen]

That also raises the question: What amount of resources does the database consume?

[Nic Brough -Adaptavist-]

Not a lot, unless you start trying to do "clever" things like ignore the API and talk directly to it, or run reports of it etc. Jira databases tend to be small - most users will find the database chews up a few Gb at most. On a well-tuned/monitored Jira, you'll mostly find the CPU ticks over at a couple of % usage most of the time. However, that said, it's really not easy to just say "well you can just use a small weak machine". It depends on your usage. Whatever you do, monitor the database service.

[Ramiro Pointis]

Hi Rich, if your enviroment is big enough I would recommend you to have in different servers. Plus, if your JIRA server goes down you can have a second enviroment and point it to the database. Remember is not recommended to have two working enviroments pointing to the same database.

[tousifs]

Different server for good performance is suggested.

[Chag]

rule of thumb its to always have them separate but, they are small environments were they keep it together. I have a small environment with 20 users and i keep both of them together because i dont want to manage another server.

[A]

what is a threshold for switching to multiple servers? 200 users? 500? with proper backups having a simpler setup and reduced chance of a network botlleneck outweighs a generic rule of thumb for me