what's the better way of storing attachments?

[SherryX]

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?

[Nic Brough -Adaptavist- · Accepted solution]

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!

[SherryX]

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