Hacker News new | ask | show | jobs
by platosrepublic 3390 days ago
I'm not a database expert, but this seems like something I should worry about, at least a bit. Is this a problem if you store all your persistent data in a database like MySQL?
2 comments
Mister_Snuggles 3390 days ago
If your database does ZFS-like checksumming on all of its data, including the structures that it uses to find the data that you put in, and has the ability to correct errors, then no.

Realistically though, I don't know if MySQL has this. You'd probably be better off using a filesystem that gives these kind of guarantees and running your database on that.

link
zzzcpan 3390 days ago
Every ACID compliant database is supposed to calculate checksums.
link
copperx 3390 days ago
Good to know.
link
blablabloe 3389 days ago
If you run on proper enterprise gear, the likelyhood of encountering an issue like this is very, very rare.

HP/Dell/SM servers are all ECC memory top to bottom, are properly wired (snark) and SANs have also ECC everywhere. Even on the disk caches.

And in this particular instance, it was basically some private server build being messed up.

link