4 ms·

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 data

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?

Mister_Snuggles 10y 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.
- zzzcpan 10y ago
  Every ACID compliant database is supposed to calculate checksums.
  - copperx 10y ago
    Good to know.
blablabloe 10y 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.