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?
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!
Do you use templates with Confluence? Take part in a remote 1-hr workshop. You'll receive USD $100 for your time! We're looking for people to participate in a remote 1-hr workshop...
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!
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