You're on your way to the next level! Join the Kudos program to earn points and save your progress.
Level 1: Seed
25 / 150 points
1 badge earned
Challenges come and go, but your rewards stay with you. Do more to earn more!
What goes around comes around! Share the love by gifting kudos to your peers.
Keep earning points to reach the top of the leaderboard. It resets every quarter so you always have a chance!
Join now to unlock these features and more
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 ?
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
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.
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)
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.