Comment on Moving db data (MariaDB) to NFS NAS Hello self-hosters! :) I’d like to tap in

JasonDJ@lemmy.zip ⁨1⁩ ⁨week⁩ ago

It’s okay for small scale, dev, etc…on a fast and flat/local network.

But databases really don’t like NFS, SMB, or most file sharing protocols. There’s too much transaction overhead.

The effect gets exponentially worse as you add in latency. Database may as well be on the moon if you’ve got more than 10ms between it and the app (hyperbole but not really).

Use fast local storage, ideally. Or block if you have it. Async replicas if you are chasing 9s.

original
Sort:hotnewtop