two confluence applications pointing at same DB

This is probably a dumb question but here goes?  I am Confluence Admin and am in the process of transitioning from Windows stand alone Confluence application working with Oracle DB to Linux based Confluence application with Apache.

While in the process of transition, am I going break something if I have two Confluence applications pointing at the same DB?

Eventually, the goal will be DB for TEST-DEV and DB for PROD but that is not highest priority.


3 answers

1 accepted

1 vote
Accepted answer

There's two answers here, depending on what you mean by "database".  Sadly, database vendors have tried to use the same words to mean different things in this field and not gone along with the natural use of English either, and that messes explanations up.

Answer 1.

If you mean you want to point at the same "Database" in the sense that most people use the word ("I keep stuff in my database, if someone else is using my database, then it's all one big pile of tables in one place"), then

Yes, you will break your Confluence.

Confluence needs full read/write access to its database.  Confluence cannot tolerate anything changing the database without its knowledge.  So if Confluence A is happily running, when Confluence B tries to write to the database (and it will try to write, even if you've got no users active), it will break Confluence A.

So, no, do NOT even think about doing this.

Note - this reasoning doesn't apply to Confluence Clustered (now defunct) or Data Centre versions, but they do different things from what you're trying.

Answer 2.

If you mean the same database service, then you're fine.  By service, I mean "a piece of software that is running and providing many "databases"."  So when you log into your MySQL box for example, it shows you one process running MySQL-demon, and then you connect to that and type "show databases", it lists out "database 1: system stuff, database 2: confluence-live, database 3: confluence-test, and so-on".  As long as Confluence A and Confluence B have separate databases within that service, you're fine.

0 votes
Davin Studer Community Champion Oct 03, 2014

Not a good idea. Especially when it comes to attachments. These are stored on the server, not the database. So, if you add an attachment on the test server and tried to access the page in the production server the attachment would be missing. I'm sure there are other things that could be bad, but that is the first, and in my opinion a big one, to come to mind.

Thank you for your help!

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Dec 10, 2018 in Confluence

Organizing your space just got easier - Page Tree Drag & Drop is here

Hi Community! I’m Elaine, Confluence Product Manager. You may have read my earlier post about page tree in space navigation sidebar. I'm excited to share another improvement that helps you organize ...

188 views 4 6
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