4 ms·
Relatational databases has their advantages compared with hierarchical filesystems of blobs, but that comment is really completely beside the point. File syste
by xorcist 12y ago
Relatational databases has their advantages compared with hierarchical filesystems of blobs, but that comment is really completely beside the point.
File systems are simpler and backups and replication are really much more straightforward. As anyone who did disaster recovery of Oracle databases can attest to, there are a lot of details to get wrong.
It boils down to what data you want to store and what your access patterns look like.
- regularfry 12y agoYou don't get to avoid backing up the database just because your file contents happen not to be in it. Now you have two different backup jobs not just to run, but to run atomically.
- Spooky23 12y agoGreat point -- Oracle has a solid capability that is easy to operationally screw up. Database recovery is usually a real shitshow. When you go to other platforms, you need solid process AND deep exterior in whether the database can do what you want. Can MySQL handle the same recovery scenarios that Oracle can? With which storage engines?