Re:MySQL is bazillion times faster than MemSQL
by Dylan16807 on Tuesday June 26, 2012 @03:28PM
(#4163710)
While backup power might be expensive in a hard drive situation, it looks like even cheap SSDs are available with power loss protection. And as far as I'm aware you're better off using SSDs for databases anyway.
Re:MySQL is bazillion times faster than MemSQL
by jharsman on Tuesday June 26, 2012 @04:17PM
(#4163897)
Note that writing data to a single disk (or SAN array, or RAID controller) really isn't durable either, even if the the data does actually get to the disk and isn't in a write cache somewhere.
What if that disk crashes, or the SAN array brakes and kills all the data, or the data center burns down?
The SQLite documentation goes into further detail surrounding the atomicity of writing a single 512 byte sector during a power failure (on old drives, on 4096 byte drives, and on SSDs). Few people seem to account for any of this stuff, yet sleep soundly at night regardless.