Best Database for Jira

Question

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.

BHUSHAN PATIL_fap6cn · Answer

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)

Sanjen Bariki_rtm841 · Answer

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

Matt Doar_tzgiej · Answer

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