Re:MongoDB, Data Durability and Improvements coming in 1.8
by lwat on Monday January 10, 2011 @08:27PM
(#2090477)
I'm not disagreeing with you, all I'm saying is that SQL Server databases are built from the ground up to resist data corruption and does exceedingly well at it. Not so with NoSQL data stores.
Re:MongoDB, Data Durability and Improvements coming in 1.8
by ericflo on Monday January 10, 2011 @09:17PM
(#2090580)
Not so with MongoDB. Let's please not blame all of NoSQL for MongoDB's bad design decisions.
Re:MongoDB, Data Durability and Improvements coming in 1.8
by aphyr on Tuesday January 11, 2011 @12:42AM
(#2091050)
Yeah. There are several nosql backends which offer resistance to corruption under sudden failure. Bitcask, for example, is structured for on-disk data durability using some of the ideas for log-structured filesystems.
In each of the cases where the customer had a true standby system, implemented via replication, log shipping, or mirroring, they were able to failover with little (log shipping) or no data loss.
In the cases where they had a single, standalone server, the option was to restore the last known good backup, or sent the database files had to Microsoft for analysis and repair.
ANY system (RDBMS, NoSQL, or otherwise), should have a standby replica to prevent data loss. If you data is stored on a single machine, you are doing it wrong.