Can we use one DB to Install Multiple Atlassian Applications ?

Gang

We have JIRA / Confluence / Bamboo / Fisheye installed on same Oracle 11g DB (SID) with different schema names for different applications. Now i am planning to migrate these applications from 2003 server to 2008 server , while i am doing this a question came to my mind.

Is it a good practice to have all the app's under one DB or we need to have different DB's for different app's ?

Cheers


Sandeep

1 answer

1 accepted

This widget could not be displayed.
Yes, it's perfectly safe and has only one minor downside - if you need to take the database offline for maintenance, all the applications suffer downtime.

Thanks Nic

Will there be any implications on performance.?

Also will we have issues upgrading the different apps at different times in the future ?

Are there any other advantages for keeping the databases separate (except for independence..so if db is down the app is not down) ?

Performance - not really. Obviously, any database service can become overloaded, but there's nothing unusal about running several Atlassian apps in databases scattered across services or in one place.

Upgrading - not an issue - the sets of data are separate, so the upgrades are independent.

Other advantages - that's where I have to back away and defer to a real DBA. In terms of Atlassian stuff, there's nothing really other than the independence, but that applies to any application backed with a database.

Suggest an answer

Log in or Sign up to answer
Atlassian Summit 2018

Meet the community IRL

Atlassian Summit is an excellent opportunity for in-person support, training, and networking.

Learn more
Community showcase
Posted Aug 06, 2018 in Jira Service Desk

A is for Activate: Share your top Jira Service Desk onboarding tips for new users!

Hi, everyone! Molly here from the Jira Service Desk Product Marketing Team :).  In the spirit of this month's  august-challenge, we're sourcing stories of Jira Service Desk activation fro...

593 views 25 15
Join discussion

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