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

2 votes

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.

0 votes

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

Thanks Nic Brough and Rodrigo Girardi Adami for your reply.

you're welcome Kumar :)

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Tuesday in Featured Groups

Tuesday tips & tricks: What is the Atlassian Community?

It's officially Tuesday, which means it's officially time for another tip to help you better navigate this space we call the Atlassian Community. 😄 I got a great question from community member, Sa...

141 views 6 8
View post

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