Best Database for Jira

Farhad November 13, 2023

Dear all 

I installed jira and confluence as docker container and i have 2 question about that ! 

1. which database have best performance for jira ? 

2. which solution is better : install database as docker container on jira server OR install database on other server ? 

Thanks. 

3 answers

1 vote
Matt Doar
Community Leader
Community Leader
Community Leaders are connectors, ambassadors, and mentors. On the online community, they serve as thought leaders, product experts, and moderators.
November 13, 2023

1. Postgres is the most tested database with Jira. But use the DB that you have the most local experience with and local assistance

2. Using a remote database is generally better for large Jira instances. For small instances it likely doesn't matter

0 votes
BHUSHAN PATIL
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 23, 2023

Hi Farhad,

Jira is compatible with various databases. it has been commonly used with the following databases:

PostgreSQL: Known for its open-source nature, reliability, and performance. Many Jira instances use PostgreSQL due to its robustness and scalability.

MySQL/MariaDB: Another popular choice for Jira installations, especially for smaller to medium-sized setups. but historically, PostgreSQL has been the more favored option due to performance reasons.

Microsoft SQL Server: Offers robust performance and is often preferred in environments where other Microsoft products are prevalent. but might require additional configurations.

Oracle: Known for its enterprise-level capabilities and scalability, but it might be more costly compared to other options.

Ultimately, the best database for Jira depends on your specific requirements, scale, budget, and the expertise available within your organization to manage and maintain the database system effectively.

Same Server vs. Separate Server:

  • Same Server (Docker container): This might be suitable for smaller setups or testing environments, but it could lead to resource contention and performance issues as the load increases.
  • Separate Server: Typically recommended for production environments. It offers better scalability, performance, and isolation. It ensures that database operations do not directly impact the Jira and confluence server's resources.

Before making a decision, it's advisable to review Atlassian's official documentation for recommended database versions and configurations for your specific Jira and confluence versions.

Regards,
Bhushan
(don't forget to hit accept button)

0 votes
Sanjen Bariki
Rising Star
Rising Star
Rising Stars are recognized for providing high-quality answers to other users. Rising Stars receive a certificate of achievement and are on the path to becoming Community Leaders.
November 13, 2023

Hi @Farhad ,

Welcome to atlassian community!

I would like to suggest you to go with the Postgres sql DATABASE with Jira.

Install database on the server and it will help you to store and separatly and resolve the db level issue. POSTGRES sql database is friendly and easy to operate.

 

Regards,
Sanjen

Suggest an answer

Log in or Sign up to answer