Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Earn badges and make progress

You're on your way to the next level! Join the Kudos program to earn points and save your progress.

Deleted user Avatar
Deleted user

Level 1: Seed

25 / 150 points

Next: Root


1 badge earned


Participate in fun challenges

Challenges come and go, but your rewards stay with you. Do more to earn more!


Gift kudos to your peers

What goes around comes around! Share the love by gifting kudos to your peers.


Rise up in the ranks

Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!


Best Database for Jira

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 ? 


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.
Nov 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

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.

(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.
Nov 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.



Suggest an answer

Log in or Sign up to answer