Scaling for JIRA - Seperate DB and App

Hi,

 

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

George

1 answer

1 accepted

5 votes

Dear George,

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;

https://confluence.atlassian.com/enterprise/jira-sizing-guide-461504623.html

Friendly Regards,

Hi Jeremy,

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.

 

Regards,

George

Josh Steckler Community Champion Aug 04, 2017

+1 on linux over windows.

For an instance your size, I think it should be fine for the application and database to be on the same server.

Maarten Cautreels Community Champion Aug 04, 2017

Hi Prajosh,

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

Best,

Maarten

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"

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

499 views 1 15
Read article

Atlassian User Groups

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!

Find my local user group

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

Groups near you
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot