Which database is better in the production either MSSQL server or MySQL?

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

S.Indirakumar

3 answers

This widget could not be displayed.

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.

This widget could not be displayed.

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.

Know issues for MYSQL

Know issues for MSSQL

Regards,

Rodrigo

These links are for Confluence and the original question was for JIRA. Are there similar links for JIRA?

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

This widget could not be displayed.

Thanks Nic Brough and Rodrigo Girardi Adami for your reply.

you're welcome Kumar :)

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Published 8 hours ago in Marketplace Apps

The 7 hacks of highly successful automation

...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...

43 views 0 8
Read article

Atlassian User Groups

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!

Find my local user group

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

Groups near you