We currently have JIRA's application and its respective PostgreSQL DB on a single Windows VM. We are a team of 10 where we create hardly 5 tickets a week. We are planning to use it for a ticketing sytem also which may increases the number of issues created per day to 25-30 issues.
Is it alright to continue with the current setup or should I setup JIRA differently (different servers for app and DB)? Or change the DBto another like MySQL or MS SQL?
Thanks in advance
With hardly 5 tickets a week.. this setup will not be any problem. When the environment grows however.. I would recommend you moving away from a Windows VM and to Linux. The Atlassian products are proven to be working faster on that OS.
Should the environment grow... I have a sizing guide for you here;
What about as I mentioned when I create a project for ticketing purposes and start receiving 25-30 tickets in that project in a day(All in all, it will be still 10 users who will be using and creating issues)?
Since it is a VM, as from what I read in the sizing guide it should not be a problem to increase the memory to 32GB, CPU (already 2CPU/2Core) and storage.
The sizing does not mention that DB matters or the app and DB should be seperate so I guess it should be alright to stick to PostgreSQL and let the app and DB be on the same server.
Please do correct me if I am wrong.
We've been running our JIRA+JIRA MySQL+Confluence+Confluence MySQL+Crowd on a single server for a couple of years for about 500 users and many issues.
By now we've expanded to about 2000 users and over 2500 issues a day so we split our JIRA + Crowd / JIRA MySQL / Confluence + Confluence MySQL into 3 servers :-)
The amount of issues being created on one day does not really matter to much. It's the amount of concurrent users/issues created that is more important for the performance of JIRA.
Oh and Linux Server +1
I'm with Jeremy and Josh - your VM is more than adequate for your current usage.
If you do decide to move, then the best option is "what your teams know". There's no point jumping to Linux if your expertise is purely Windows. Or changing DB if you're happy with PostGres. Given a completely free choice with no preferred systems, I would always recommend installing on Linux with a PostGres back-end.
Application and database on the same server or separate doesn't really matter until you get to a large system. I run my personal ones separately, but that's because I tend to try to run them like most of my clients so I've got stuff to tinker with, not because it's "better"
...PermissionsStartOnly=true User=www-data Group=www-data ExecStart=/opt/jira/bin/startup.sh ExecStop=/opt/jira/bin/shutdown.sh TimeoutStartSec=120 TimeoutStopSec=600 PrivateTmp=true [Install] WantedBy...
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!
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