4 ms·
I’ve come around to the idea that checksumming isn’t some universal panacea. Once you have checksums, you need to start thinking about error *recovery* and not
by slaymaker1907 2y ago
I’ve come around to the idea that checksumming isn’t some universal panacea. Once you have checksums, you need to start thinking about error *recovery* and not just detection. What happens to linked data? Do you just declare the whole SQLite file corrupted and just throw up your hands?
If you have backups, that’s one obvious solution, but people might not have uncorrupted backups.
I still think you should do it and emit a warning about it at the very least, but it’s not trivial to handle.
- throw0101b 2y agoJust use ZFS. :)
- xyzzy123 2y agoRunning a database on zfs can work well but introduces a whole new world of whitepapers to read and tuning options to consider :/
- nubinetwork 2y agoLeave zfs at the defaults and in the case of mysql/mariadb, turn off the "double writes" setting. It's not hard.
- ErikBjare 2y agoYou don't have to read any whitepapers. Just copy the `zfs create` command from some guide, it'll work fine.