13 ms·
If your DB is ACID AND your underlying storage has not lied to you about committing the write...
by newman314 12y ago
If your DB is ACID AND your underlying storage has not lied to you about committing the write...
- CaptainZapp 12y agoThis is the basic reason why raw devices where the way to go for decades for use as database devices and are still in use in most installations. I'm talking about Sybase here. But any database, which shifts the commit responsible to the operating system (without explicit guarantees that committed data is indeed written to disk) may invite you in for a huge and very unpleasant surprise.
- newman314 12y agoCounting on raw devices when you have a SAN underneath presenting LUNs to the server means unless you are very careful, it does not mean that said write necessarily made it all the way onto disk.