I have built out two system one for prod and one for uat. I need to know how to install the Jira software for each environment. I will adding them to a load balancer and migrating the data from MySQL to MS SQL.

1 answer

0 votes

The process to install Jira can vary slightly depending on your environment.  For example we do have guides on Installing Jira on Windows as well as Installing Jira on Linux

Generally the main installation is pretty straightforward.   Since you will have one environment using the MySQL database, you should be aware that this database use requires you to manually download and install the mysql jdbc driver .jar file into the $JIRAINSTALL/lib/ folder.   Otherwise Jira won't be able to connect to a mysql database.

I would recommend following the Connecting Jira to MySQL guide (this guide includes the note about the jdbc driver download required as well) and for the other environment the Connecting Jira to MS SQL 2014 guide.

It is important to make sure that you create these databases per the steps in those guides.  One step that frequently trips up first time Jira installers is that they do not create the databases with the correct collations as stated in those guides and as a result Jira tends to throw warnings about data integrity as a result.   I would also recommend checking out the Supported Platforms documentation in order to make sure that your system is using supported versions of Java, database, browsers, etc that correspond to the version of Jira you plan to install.

Suggest an answer

Log in or Join to answer
Community showcase
Teodora [Botron]
Published Thursday in Marketplace Apps

Jira Inferno: The Nine Circles of Jira Administration Hell

If you spend enough time as a Jira admin - whether you are managing a single, mid-sized instance, a large enterprise one or juggling multiple instances at once - you will eventually find yourself in ...

459 views 1 15
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
Atlassian Team Tour

Join us on the Team Tour

We're bringing product updates and pro tips on teamwork to ten cities around the world.

Save your spot