Re:Mistakes Beginners Make When Working with Databases
by naasking on Wednesday June 08, 2016 @01:59PM
(#11864162)
But if you replicate your DB, now you also have to replicate your filesystem. Easier to just segregate BLOBs in their own tables and let DB replication do all the work.
[ Parent
| on HN ]
Re:Mistakes Beginners Make When Working with Databases
by ryanbrunner on Thursday June 09, 2016 @07:11AM
(#11868624)
It depends on why you're replicating but I would say in most cases you don't need to.
If you're forking your DB (i.e. there will now be two copies that will diverge from each other) than sure, you would need to replicate your filesystem. But that's not complicated (copying directories is a solved problem).
If you're talking about replication for performance reasons, then DB replication and file replication aren't necessarily going to go hand-in-hand, and the solutions are going to look fairly different (for web apps, "file replication" probably looks like a CDN).