Create
cancel
Showing results for 
Search instead for 
Did you mean: 
Sign up Log in

Next challenges

Recent achievements

  • Global
  • Personal

Recognition

  • Give kudos
  • Received
  • Given

Leaderboard

  • Global

Trophy case

Kudos (beta program)

Kudos logo

You've been invited into the Kudos (beta program) private group. Chat with others in the program, or give feedback to Atlassian.

View group

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

Would my data be safer in a managed database?

This question is an extension of best practices for database setup, which discusses whether to install Confluence and its database on the same or separate servers. I use Confluence with PostgreSQL (on the same server), while relying on my own 'enthusiast' level of server admin skill to keep things running smoothly. I get by, but there is always a risk of error, so my question is this:

With Linux server and Confluence maintenance in the hands of a relative amateur, would putting the data in a separate managed server have merit, or just add complexity?

Regular backups are a given, of course, and I understand that no place is 'safe' from potential data loss. I am merely asking if a managed database might provide a modicum of additional protection or convenience, for instance, when upgrading Confluence or the server operating system.

1 answer

1 accepted

0 votes
Answer accepted
DPK J Community Leader Dec 17, 2019

This is just a personal preference, and policies that are imposed by your organization.

  • My thumb rule is, "How often service updates database?"
    • So, if I see database updates are very often like once per 20 minutes (during peak) I will go with separate machine.
    • I do this so that I can update database server and application server separately. (things can go sideways during this)
  • Maintaining separate machine just for the DB is always an overhead though, so
    • I also see if I can merge DB's of two-three services on one DB machine.
    • If I can get high performance machine (because with network overhead, your service will definitely slower)

 

And finally, I maintain both kind Confluence instance, and I have not face issue with them (especially, after switching to Postgres). But for new instances (now a days when you can have multi-core machine for very cheap), I don't want maintain overhead of DB machine, its security, its update regime, etc.

Thanks @DPK J, this is helpful. We are talking about a 10-user Confluence license on Digital Ocean servers with only a couple of users logged in at once, so a single machine can definitely do the job. I am the primary user, the admin, and the organization.

The main point was meant to be about what you said—that is, separating the database from Confluence server updates that might go sideways. To clarify, the comparison is between:

(a) Self-managed Confluence + fully managed Postgres
(b) Self-managed Confluence with self-managed Postgres on one machine.

I was not considering:

(c) Self-managed Confluence + self-managed Postgres on separate machines.

Is this how you understood my question? If so, it sounds like I should keep the arrangement simple and put Confluence and Postgres on the same server (Option B). If I take a snapshot before doing any upgrades, test any major changes on a non-production copy, and keep this fantastic community at the top of my bookmarks I may stand a reasonable chance of avoiding catastrophe!

DPK J Community Leader Dec 18, 2019

Oh! I was talking about both self-managed Confluence and Postgres (i.e. option C).

But I think for 10 user instance option B is the best. It will keep your cost down, and with scheduled backup of DB and Confluence Home, you can avoid almost all unforeseen situations.

You can learn about recommended backup practices here - https://confluence.atlassian.com/doc/production-backup-strategy-38797389.html

In the end, thanks for the kind words about the community. We try to keep it simple here, so please don't hesitate to ask or share your knowledge with us.

Suggest an answer

Log in or Sign up to answer
TAGS
Community showcase
Posted in Confluence

What do you think is the most *delightful* Confluence feature? Comment for a prize!

- Create your own custom emoji 🔥 - "Shake for Feedback" on mobile 📱 - An endless supply of GIFs via GIPHY 🤩 Is there anything quite as nice as a pleasant surprise? Comment below with what...

408 views 23 8
Join discussion

Community Events

Connect with like-minded Atlassian users at free events near you!

Find an event

Connect with like-minded Atlassian users at free events near you!

Unfortunately there are no Community Events near you at the moment.

Host an event

You're one step closer to meeting fellow Atlassian users at your local event. Learn more about Community Events

Events near you