TrustRadius: an HG Insights company

Apache Cassandra

Score9 out of 10

95 Reviews and Ratings

What is Apache Cassandra?

Cassandra is a no-SQL database from Apache.

Top Performing Features

  • Scalability

    NoSQL databases are inherently more stable than relational databases and have built-in support for replication and partitioning of data to support scalability.

    Category average: 9.4

  • Availability

    Availability is the probability that the NoSQL database will be available to preform its function when called upon.

    Category average: 8.9

  • Performance

    How fast the database performs under data load

    Category average: 9.2

Areas for Improvement

  • Concurrency

    Concurrency is the ability for multiple processes to access or change shared data simultaneously. The greater the number of concurrent user processes that can execute without blocking each other, the greater the concurrency of the database system.

    Category average: 9

  • Deployment model flexibility

    Can be deployed on-premise or in the cloud.

    Category average: 8.9

  • Data model flexibility

    NoSQL databases do not rely on rely on tables, columns, rows, or schemas to organize and retrieve data, but use use more flexible data models to accommodate the large volume and variety of data being generated by modern applications.

    Category average: 9

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