Dear Atlassian Group,
We are currently using Jira in our comapnay where we use HSQL in the production which is not recommended in the production by you, So I want to move the HSQL database to MSSQL Server or MYSQL.I have couple of questions regarding this as follows;
1) Which database is better in the production either MSSQL server or MySQL?
2) We are running Jira in linux right now.Can i connect JirA with MSSQL Server or MYSQL from another server?
Thanks in advance
1. You should use whatever database is best supported and understood within your organisation.
Given a free choice, then MySQL definitely. But the most important thing is how well you can support the database internally.
2. Where you connect from is not really that important. You can run Jira on different servers and operating systems and connect it to any database you want. I've seen Jira running on Windows connected to a PostGreSQL server on Linux, and Jira running on CentOS connected to MS-SQL. (Heck, if you want to, run Jira on VMS hooked up to Oracle on another node in the cluster). Doesn't matter as long as the servers can talk to each other.
In addition to Nic very good answers, I would say to check the known issues for both databases and weigth the the good and bad point for each. This should also help. But the most important point, as Nic said, is that you need to use the one that you can administrate well and/or have a DBA to help.
Hi Daniel, Yes, there are links for JIRA specifically, although many of the issues in those database are shared among the Atlassian flagship apps. Known issues for MYSQL JIRA: https://confluence.atlassian.com/display/JIRAKB/Known+Issues+for+MySQL Known issues for MSSQL JIRA: https://confluence.atlassian.com/display/JIRAKB/Known+Issues+For+SQL+Server I hope these helps! Cheers, Rodrigo
Atlassian Summit is an excellent opportunity for in-person support, training, and networking.Learn more
...there's anything I've learnt from working, it's that people are lazy! No offense to anyone reading this, but it's true and we can all admit it. The easier you make something for someone, the more...
Connect with like-minded Atlassian users at free events near you!Find a group
Connect with like-minded Atlassian users at free events near you!
Unfortunately there are no AUG chapters near you at the moment.Start an AUG
You're one step closer to meeting fellow Atlassian users at your local meet up. Learn more about AUGs