This question is in reference to Atlassian Documentation: Connecting JIRA applications to a database
Hi Everybody,
1. I'm confused about the different between database using PostgreSQL and using default database configuration when we start setup JIRA in the browser?
2. What is benefit using PostgreSQL and default database?may be please give me image or example to explain my question.
Regrads,
Ferdian Bagus
Your real question should be: Should i use MySQL, Postgre or MSSql?
Hi Jonas Andersson,
for question number 2...yeah I mean my real question is "Should I use PostgreSQL or MySQL?"
thank you for answer for my first question.
JIRA 7 doesn't use HSQL any more, they've moved on to H2 instead. However, it's still effectively file based and not suitable for production use.
Given a free choice of database back-end, PostGreSQL is first on the list (Atlassian develop against it and use it on Cloud) with MySQL in second place, Oracle third and MS-SQL in a very very distant fourth place. In the real world, you should use one of those four, but it should be whichever one you are most familiar with and are most willing to install and support.
@Nic Brough [Adaptavist]
For that statment :
"JIRA 7 doesn't use HSQL any more, they've moved on to H2 instead. However, it's still effectively file based and not suitable for production use.
Given a free choice of database back-end, PostGreSQL is first on the list (Atlassian develop against it and use it on Cloud) with MySQL in second place, Oracle third and MS-SQL in a very very distant fourth place. In the real world, you should use one of those four, but it should be whichever one you are most familiar with and are most willing to install and support."
Nic could you share link or information about that?
I need more information about that.
Thx Nic for your information
I haven't seen any major concerns or problems with any types of supported databases. For all intents and purposes they are all very supportable.
It looks like you're new here. Sign in or register to get started.
