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 vote

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
Atlassian Community Anniversary

Happy Anniversary, Atlassian Community!

This community is celebrating its one-year anniversary and Atlassian co-founder Mike Cannon-Brookes has all the feels.

Read more
Community showcase
Published yesterday in Confluence

Think you know shares vs. @mentions in Confluence? Take this collab quiz.

To anyone who doubts that Atlassians are a little too obsessed with collaboration, and tools related thereto, let me describe a recent discussion we had (which took place on our internal Confluence, ...

107 views 2 4
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