Hacker Newsnew | past | comments | ask | show | jobs | submitlogin

How do you manage the databases?


Container images that have access to an NFS mount from my NAS.

You need to be careful with your mount options here, since soft mounts can cause corruption in some cases and performance is not fantastic (although nfs v4.1 is better than nfs v3) - but overall it works and keeps backups strategies simple since everything is on the NAS.

Sadly - it's fairly slow (sqlite in particular is painfully slow when under lots of load and needs care to ensure only one machine is writing to it at a time) but right now I'm avoiding more complex setups since it's not normally a problem with just me+family using things.

Long term - I've been considering moving to iSCSI, or something more robust, but it just hasn't been worth the trouble yet.

Did make me like sqlite a whole lot less though - I opt for mariaDB/Postgres on any service that supports a remote db - they seems to do just fine. 3 years in on this setup and no corruption outside of sqlite on a soft mount (which was solved by reverting to my last backups).




Guidelines | FAQ | Lists | API | Security | Legal | Apply to YC | Contact

Search: