what's the better way of storing attachments?

We are planning to migrate our applications to new servers. Just wondering what's the better way of storing attachments, file system or database? Is that OK to put all attachments to a different server?

1 answer

1 accepted

0 votes
Accepted answer

I'm afraid this kind of depends on your infrastructure, criticality of the data and how you use it, and your backup regime.

Taking Confluence as an example, my current client keeps it all in the database. They've got a really solid database backup (dual real-time replication, so there's an up-to-date copy in the failover datacentre and the offsite backup site), and a file system backup that looked ok but we've discovered problems with it. So the decision was to be safe and live with 100Gb databases...

Jira has the same database stability, but we don't keep operationally sensitive attachments in it. There are a LOT less attachments, and we can accept the risk of losing a couple of days worth if something goes "bang", so we live with the weak file-system backup.

So, I can't really answer the question without saying "it depends". You need to have a look at your systems to see what you've got, what's fastest, most stable, most reliable etc, and then run through what you need most - performance, rock solid backup, fast failover and so on!

thanks for your information. Can we put the file system for the attachments in a remote server?

Suggest an answer

Log in or Sign up to answer
Community showcase
Posted Feb 06, 2019 in Confluence

Try out the new editing experience

Hi team, I’m Avinoam, a product manager on Confluence Cloud, and today I’m really excited to let the Community know that all customers can now try out the new editing experience and see some of the ...

965 views 50 8
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