nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

Scaling for JIRA - Seperate DB and App

Hossayn Ratlami

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

Accepted answers

Jeremy M

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,

All comments

Jeremy M

Dear George,

Should the environment grow... I have a sizing guide for you here;

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

Friendly Regards,

Hossayn Ratlami

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

+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

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

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

jira-software