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.
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.
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)
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
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
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.
You must be a registered user to add a comment. If you've already registered, sign in. Otherwise, register and sign in.