Cassandra as NoSQL fault tolerant database choice
July 06, 2017
Cassandra as NoSQL fault tolerant database choice
Score 9 out of 10
Vetted Review
Verified User
Overall Satisfaction with Cassandra
Cassandra is an open-source NoSQL database solution offered by Apache. What's nice about Cassandra is its ability to host the data in multiple nodes in a ring, and changes made to a node in the ring will shard the update to the rest. For geographically dispersed architecture requiring local database storage, this can be a valuable asset which makes this NoSQL option stand above the rest.
Pros
- Cassandra can preform read/writes very quick
- Nodes in a ring will keep up to date by sharding information to each other
- Cassandra is well suited for scalable application needing keyspace storage
Cons
- Cassandra's query language is clunky, which is likely due to the nature of NoSQL.
- Lacking the ability to relate data between sets makes querying harder, but this again is the nature of NoSQL.
- Cassandra has had a positive effect on our ROI by improving uptime and performance
- MySQL and PostgreSQL
Cassandra is the only NoSQL database I have extensive experience with. In terms of other open source database solutions, I can say that I like Cassandra as much or equally as traditional Oracle MySQL, and a lot more than PostgresSQL. The decision to use Cassandra was driven by the ability for fast read and writes, as well as fault tolerance by having multiple rings in a cluster which shard data to each other in near real time.
Comments
Please log in to join the conversation