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 Sign up to answer
Community showcase
Published Friday in Jira Service Desk

Are you a Jira Service Desk agent? We want to talk to you!

Are you a whiz at handling tickets and looking at how you can further optimize your workflow with automation? Do you tackle detailed customer support questions while simultaneously getting flooded wi...

166 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