Comment on Moving db data (MariaDB) to NFS NAS Hello self-hosters! :) I’d like to tap in
skankhunt42@lemmy.ca 2 weeks ago I know it has been 3 days since you posted buy why not set up replication in the database it self? Sounds like you’re over complicating replication.
I run in k8s but I have a database with local disk, and I have another cronjob that takes a backup into the first database docker init folder. Older backups end with -date so they won’t get picked up by the init script. You can do similar with just docker.
I’ll echo everyone else. Database need local disk. I speak from experience of doing it over NFS. Even containers that have a hidden sqlite3 database should get local disk.
AFAIK db replication would require running another db on NAS. Which I tried to avoid
Yeah, that’s why I’m thinking to do. Have a container that watches changes to db data and rsyncs those into the NAS for safekeeping. My main goal in all of this is so db data won’t die with laptop’s SSD
I think the inode rsync is a bad idea. The 2nd DB would be on the NAS but its not being used by the app, so as long as it’s asynchronous writes, you should be okay.
In either case, I hope you have backups, not just the copy
But then I have to maintain it too. And it will be using RAM that was supposed to only be for servicing RAID. On a platform where RAM can’t grow
For sure my setup will be growing and changing with time. But ATM this “prod” db lives only on laptop’s SSD
Personally, it sounds like you’re overengineering your setup. If it’s to learn then have fun! However, if its ‘prod’ and you care about the data then you should stick to prod tested architecture. You won’t find many people (if any at all) using inode notify to rsync a database on change.