Your requirements might be perfect for Cassandra or another NoSQL engine, I'm not here to fight that. It's the unwavering, front-line suggestion for NoSQL that

Your requirements might be perfect for Cassandra or another NoSQL engine, I'm not here to fight that. It's the unwavering, front-line suggestion for NoSQL that I consider HDD. There was tons of this after Mongo started getting popular. But it's suggesting a satsuma as the best type of apple. Yeah, NoSQL does some stuff well, but there's a pile of things it doesn't handle at all. It's not a drop-in replacement and people treating it as such have wasted so much developer time trying to turn it back into a relational database. HA isn't a feature exclusive to either type of database.