What users are saying about

Amazon Aurora

41 Ratings

Cassandra

Top Rated
61 Ratings

Amazon Aurora

41 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8 out of 101

Cassandra

Top Rated
61 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.2 out of 101

Add comparison

Likelihood to Recommend

Amazon Aurora

When already using a relational database, either MySQL or PostgreSQL, the change to Amazon Aurora should be very straightforward. The main benefits you get are cost efficiency and ease with regards to the storage, as it scales with you, and managing clusters including failovers are made very straightforward for you.If you are looking for a database which can scale up and down quickly with demand, Aurora may not be the best fit. However, there is now an Amazon Aurora Serverless service which attempts to address this requirement. I do not have any experience with it, so cannot comment further - but it is possible it will fit your use-case.
Andrew Raines profile photo

Cassandra

Apache Cassandra is a NoSQL database and well suited where you need highly available, linearly scalable, tunable consistency and high performance across varying workloads. It has worked well for our use cases, and I shared my experiences to use it effectively at the last Cassandra summit! http://bit.ly/1Ok56TKIt is a NoSQL database, finally you can tune it to be strongly consistent and successfully use it as such. However those are not usual patterns, as you negotiate on latency. It works well if you require that. If your use case needs strongly consistent environments with semantics of a relational database or if the use case needs a data warehouse, or if you need NoSQL with ACID transactions, Apache Cassandra may not be the optimum choice.
Rekha Joshi profile photo

Pros

  • The MySQL compatibility meant we didn't have to change anything in our system which used to run on a MySQL database. It was a very simple configuration change to point at the new instance once set up
  • Much better performance than our previous MySQL database (hosted on AWS RDS) for lower costs due to the way storage is managed
  • Storage management is much more simple as it grows and shrinks with you without having to allocate and deallocate storage to the database
Andrew Raines profile photo
  • Performant. In particular, write performance is very good. Recently, a lot of work to address the changing systems environment has been done to take advantage of areas like SSDs and very dense storage systems.
  • Distributed system logic. Multiple data centers and other common network configurations like heterogeneous nodes are handled and exploited well.
  • Community. Strong community with users and project contributors worldwide. The open-source and commercial software people work well together with sharing of lessons learned and improvements based on feedback.
Gary Ogasawara profile photo

Cons

  • The cost of Amazon Aurora when compared to a simple MySQL instance is considerably higher, so we really need to look at and run some performance tests to compare if the performance improvements are worth the extra cost.
  • Although backup restores are a rare feature to use, when we need them it is always painful to restore our data. We are always searching for a database service to provide new and innovating features in terms of data recovery. For instance, being able to search on backup information to see if the needed data is there. It is a very common need to compare the hot data with the backup data, for example to fix some database data that a malfunction application wrongly updated.
  • Since aurora is an Amazon relational database service there is no way to run a dev database on a local storage for tests and development.
Vasco Mendes profile photo
  • Operational tools. Would like to see continued work to improve the operational capability for large clusters and large amounts of data. For example, analyzing the on-disk files.
  • Repair. Being able to run repair continuously and with greater control to avoid any spikes in resource use.
Gary Ogasawara profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
Cassandra8.0
Based on 11 answers
It is an important part of our infrastructure.
Gary Ogasawara profile photo

Alternatives Considered

Unlike proprietary solutions like Microsoft SQL Server, Amazon Aurora does not need proprietary licensing, so we can use this budget to get cloud solutions with high availability and performance, at a similar rate. When compared to MySQL or Postgres SQL, it allows us to have a database system always updated with the most current features and security best practices without having to worry about it. In normal database systems like MySQL to keep the database system up to date we need to have someone always looking for new upgrades.As it relies on MySQL there is no extra formation for a team that is already used to a MySQL solution.
Vasco Mendes profile photo
Cassandra is well suited to more complex networks like multiple data centers. The underlying distributed systems logic is fundamentally sound.
Gary Ogasawara profile photo

Return on Investment

  • The customers where we implemented Amazon Aurora database don't need to have an employee specialized in features and security upgrades.
  • The database replication and schedule for backup tasks are much easier, so less prone to errors.
  • We have never had a database downtime on our applications, which is essential for our customer business.
Vasco Mendes profile photo
  • Open source Apache Cassandra is free, the infrastructure to run it is cheap, and the expertise to use it is not. You'll be investing in your developers and devops team members, and they're worth it! Cassandra is incredibly cost-effective and it positions your applications to grow to web-scale.
  • DataStax Enterprise merits serious consideration. There are licensing fees, but it's worth it for (1) production support (especially if your own team is new to Cassandra), (2) stable releases, (3) sophisticated operational tools like OpsCenter, (4) integration with Apache Solr for geospatial, faceted, full-text search, and (5) integration with Apache Spark for machine learning and streaming analytics.
David Prinzing profile photo

Pricing Details

Amazon Aurora

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

Cassandra

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details