nav[aria-label="Primary Navigation"] { padding: 0; & ul { list-style: none; width: 100%; display: flex; flex-direction: row; justify-content: start; align-items: start; gap: 30px; padding: 0; & li { margin: 0; } & ul li { list-style: none; } } }

backup to offline instance

reversed-hitech

Hey,

Due to security demands, I want to implement a unique confluence setup:

2 air-gapped servers, where the content of one is being updated from the other. Once in a month I plan to import the data from one confluence to the other. I started to get familiar with this setup, but I don't know any good way to update the other offline instance.

I tried to query the diff of the important DBs - content, bodycontent, users, group, etc...
but I can't manage to get it right.

Is there any good way to implement this?

Thanks in advance,
Yossi

Accepted answers

All comments

Nic Brough -Adaptavist-

Welcome to the Atlassian Community!

There's no incremental change functionality for Confluence, unless you were to un-air-gap them and implement something that pushed changes from one to the other as they happen. Even then, you would end up with different data sets.

The only way you're going to get a complete solution is to tear down the target system - take a database dump of the source, and restore it into the target database (you'll then need to re-index, and sync any changed/added/deleted attachments from the file system, but that's not too hard)

This will of course, destroy anything you've done on the target system.

reversed-hitech

Thank you Nic.

I realize I didn't mention it before - the second instance is readonly, and is not meant to accept changes.

Sadly I cannot un-air-gap the instances due to the sensitivity of the information stored.
However, you mentioned that pushing the changes as they happen may do the job - is there any builtin way to do this? is it a DB trigger? I'm thinking that maybe I could log all those queries, transfer to the air-gapped network and update the other instance.

I looked at confluence's DB a bit, and wonder if a query like this might work: query all from confluence.CONTENT with a time filter from the last time I synced the instances.
Then I'll dump confluence.BODYCONTENT and the rest of the relevant tables with the values of contentid in the first query, and import the results to the other air-gapped instance.

Do you think that something like this might work? I'm trying to collect all relevant tables - do you have a list of such tables?

Best regards,
Yossi

Nic Brough -Adaptavist-

That's a massive amount of work that won't capture everything, and leave your target Confluence in a different state. It will be close, as you say it's "read only", but still not quite right.

Forget databases, with Atlassian stuff, it's all-or-nothing (or a massive amount of coding).

As your target is read-only though, there is a simple solution - dump and restore the database from the source. Sync the attachments and re-index after you've restarted the target.

reversed-hitech

I do not have the ability to do a full dump of the instance due to the size of the database (a few hundred gigabytes), it would also be a pretty big hassle to do it overtime.

Are there no scripts on your end that can do that? or at least any documentation that explains how the database stores everything to make sure our development team can code this the right way without losing the important data. I mostly care about the content of the pages and the spaces, I don't really care about the comments/inline comments, attachments, etc.

Thank you for the fast reply!
Yossi

Welcome!

It looks like you're new here. Sign in or register to get started.

Quick Links

Find more posts tagged with

confluence

server

confluence-server