TrustRadius: an HG Insights company

Cassandra

Score9 out of 10

95 Reviews and Ratings

What is Cassandra?

Cassandra is a no-SQL database from Apache.

Product Demos

review of cassandra

Pros

  • Masterless
  • Schema-less
  • Multiple datacenter usage w/ little or no data loss

Cons

  • Rebuild/repair of objects (tables) in the keyspaces, allow to ignore keyspaces to repair.
  • Monitoring tool form opscenter support for Cassandra 3.x (or some other open source tool)
  • UI browser type to view data (rather than csql)

Alternatives Considered

HBASE and MongoDB

Other Software Used

Aerospike Database, MongoDB, Redis, Couchbase Server

One of the Best NoSQL Databases!

Pros

  • Continuous data availability is extremely powerful feature of Cassandra.
  • Overall cost effective and low maintenance database platform.
  • High performance and low tolerance no SQL database.

Cons

  • Moving data from and to Cassandra to any relational database platform can be improved.
  • Database event logging can be handled more efficiently.

Return on Investment

  • Cost effective
  • Lower administration effort
  • Continuous data availability

Alternatives Considered

MongoDB

Other Software Used

SQL Server Integration Services, Teradata Database, ZappySys

Cassandra at scale

Pros

  • Availability
  • Fast performance
  • Horizontal scalability
  • Memory first
  • Partition based

Cons

  • Dealing with tombstone
  • Maintenance/upgrade
  • Compaction and repair

Return on Investment

  • High availability, which makes us use the tool
  • Partition key distribution mechanism is well defined
  • Horizontal scalability when needed for high volume days
  • Complex tombstone management

Other Software Used

Couchbase Data Platform, Azure SQL Database

Usability

Pretty good software

Pros

  • Runs on commodity hardware
  • Build in fault tolerance
  • Can grow horizontally

Cons

  • It is a bit difficult for people that come from the SQL world.
  • Managing anti-entropy repair is still a bit of a challenge.
  • Better security patches.

Return on Investment

  • Nothing beats free
  • People need to be retrained
  • Support model is a bit different

Cassandra - a tunable NoSQL datastore

Pros

  • Write speed. Cassandra is very fast while writing data due to its unique architecture.
  • Tunable consistency - During data replication, consistency can be tuned for a particular data set to be available during an outage.
  • CQL - cassandra query language is a subset of SQL and eases the transition from a more traditional database.

Cons

  • Aggregation functions are not very efficient.
  • Ad-hoc queries do not perform well. Queries which were visualized while designing the databases only perform well.
  • Performance is unpredictable.

Return on Investment

  • Low learning curve
  • Scalable with high performance
  • highly fault tolerant during outage

Other Software Used

Apache Kafka