Separating DB from Application Server

Question

Currently, our architecture for JIRA Server is database and application on the same server. We'd like to explore separating them onto their own servers, but aren't entirely sure on best practices. Does anyone have documentation supporting the JIRA Application on one server and the Database on another?

Thank you in advance.

Charlie Misonne · Answer

Hi Scott,

There is nothing to configure in the UI. The DB connection is configured in a single location: the dbconfig.xml :-)

Scott McDonald_qykakt · Answer

Hi Charlie,

Thank you.  Is there anything in the UI or elsewhere we'll have to remap so the issue links, etc point to the new database location or is this all handled inside the dbconfig?

Scott

Charlie Misonne · Answer

Hi Scott,

In my experience a separation of DB and application server is the most common one. Especially in companies using large Oracle or SQL Server clusters.
It's nothing out of the ordinary.

In your dbconfig.xml you will have to point the datbase connection to the IP address or hostname of the database server insteald of localhost. Of course this needs to be a static IP or permanent hostname.

For some database types you'll also have to allow connections from the Jira server the database.