I am evaluating Cassandra as a candidate for our next-gen database. One of my colleagues told me that "it's not recommended to use it as your system of Record because it CAN lose data". Can someone with architecture understanding shed some light on under what circumstance Cassandra cluster can either lose data or become inconsistent ? (a node in a cluster crashes, network partitions, I/O glitches, etc.)
Thanks, Steve