Change Jira Database URL

Hello,

We are planning on changing some features to our lab and this will involve changing the IP on the MySQL server that JIRA uses.

I was wondering what we would need to do to adapt JIRA to this. The database url does not appear to be modifiable through straightforward means, and there does not appear to be any documentation on this.

I imagine this would be simpler than a migration of the database, but I am having trouble information on this particular use.

Our versions are:

JIRA Version: 7.3.0

Database Version: MySQL 5.6.35


Thank you for your time and any help you can provide.

 

1 answer

1 accepted

0 vote

Actually, not painful at all, once you know where to look (which is, of course, less than obvious)

Stop JIRA, clone your database to the new location, then go to <JIRA home> and find the text file dbconfig.xml.  Edit the location in there in a text editor, and restart JIRA.

Thank you, sir. Thought it had to be something like this.

 

Something I forgot to ask, if we are also changing the IP on the JIRA host, are there any concerns with that? Will JIRA automatically pick the change up for whatever purposes it needs to be, or is there something we need to do to ensure it?

It's possible that can have an effect.  Ideally, though, you're using some form of DNS, so that <myserver.ourdomain> always resolves to the current ip address of the server.  The use of DNS means that you can mostly ignore ip changes as long as the JIRA base url does not change.

 

Suggest an answer

Log in or Sign up to answer
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Fadoua M. Boualem
Published yesterday in Trello

Using Trello to manage events

As a Jira power user, I was at first doubtful that Trello could benefit my workflow. Jira already uses boards (ones you can customize!), so why would I even need to use Trello?! In this post you will...

429 views 5 6
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