3 ms·
WAL mode also relies on fsync to persist data to disk, so it has the same failure mode if fsync is not working as advertised. I briefly looked at the link you
by jeffreyrogers 9y ago
WAL mode also relies on fsync to persist data to disk, so it has the same failure mode if fsync is not working as advertised.
I briefly looked at the link you posted and it appears they also do fault injection/simulation rather than directly unplugging power or crashing the OS, so their tests won't catch disk controller problems.
- infogulch 9y agoTesting OS/controller/hardware failure will quickly devolve into extremely specific configuration issues and even fully verifying one particular configuration may be meaningless for the next configuration. Fault injection is probably as close as you can get to reliably exercising any fault tolerance properties while still being generic enough to apply to more than 1 real system in the wild.
- jasonwatkinspdx 9y agoWell, if you read the original SQL post you'd see they do make very conservative assumptions, including that fsync may lie on some systems. Alice is considerably more sophisticated than yanking a power cord and hoping it catches bad behavior.