It's not the same without you

Join the community to find out what other Atlassian users are discussing, debating and creating.

Atlassian Community Hero Image Collage

How does Confluence interact with database?

Hi All,

I have just used atlasian sdk to install a confluence environemnt. I have used the plugin tutorials to try out a few plugins actions like 'Adding Draft Labels' to the pages by customizing the menu bar etc. Now one thing which i did not need to follow or maintain till now is DATABASE. There was not even the mention of database during the installation details. It just needed "atlas-run" and we saw the site up!. I am sure for a production environment running confluence, there will be dealings with database.

It would be realy helpful if you could guide me to understand how the databases function in the Confluence ecosystem:

1. Is there a default database that is being used in my current scenario i.e. using SDK and the atlas-run command?

2. Can i connect Confluence to any database?

3. Is there any write up of example that can provide some details regarding the databases?

Thanks

V

1 answer

2 votes
  1. The sdk uses an embedded HSQL database (a file and memory based system - quick, cheap, easy and not stable or reliable enough for a production system). It should be warning you not to use it for real data in your admin screens.
  2. In theory, yes. In practice, Atlassian recommends PostGreSQL most highly, MySQL second, and they support Oracle and MS SQL Server. Personally, I've run into so many stupid problems with MS-SQL, I can only recommend the first three. There is nothing to stop you hooking it up to other databases though, just that they're not supported and you'll struggle to find documentation or help with others.
  3. Finally, as you should expect a gentle reminder to "RTM" before spending a lot of time writing questions with standard answers - see https://confluence.atlassian.com/display/DOC/Database+Configuration

Thanks Nic for the inputs! Will surely go through them and come up with more questions.

Suggest an answer

Log in or Sign up to answer
This widget could not be displayed.
This widget could not be displayed.
Community showcase
Published yesterday in Confluence

Confluence CVEs and common questions

Two vulnerabilities have been published for Confluence Server and Data Center recently: March 20, 2019 CVE-2019-3395 / CVE-2019-3396 April 17, 2019 CVE-2019-3398 The goal of this article is...

63 views 0 9
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