What users are saying about

Amazon Aurora

41 Ratings

Amazon Redshift

88 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

Amazon Redshift

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

Add comparison

Likelihood to Recommend

Amazon Aurora

Amazon Aurora should be considered for those who need a fast and reliable cloud database service. It includes the main features of a MySQL database, using the latest trends in architectural principals. It ensures out-of-the-box fault-tolerance and high scalability. It is also very important for those who don’t want to worry about features and security updates. As the price is higher than a standard MySQL for instance, it should only be considered for higher applications where performance and scalability is really important.
Vasco Mendes profile photo

Amazon Redshift

Redshift is a viable platform to house a large or very large data warehouse designed for performance and scalability. It is especially well-suited in the cases where your source data is already stored inside of the AWS services infrastructure.
Michael Romm 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
  • AWS infrastructure and support simplifies maintenance and administration
  • familiarity with PostgreSQL makes adopting Redshift as a column store easier
  • columnar data store allows for high performance queries on large volumes of data
No photo available

Cons

  • Without direct access to the instances it isn't possible to do a few things you'd be able to do if you were running your own database server, but this is rarely an issue
Andrew Raines profile photo
  • It is PostgreSQL. I miss some commands and procedural features.
  • It is perfect for analytics purposes, but not fast enough for web apps.
  • Too expensive for ETL processing.
Tamás Imre profile photo

Alternatives Considered

Using cloud-based services such as RDS or Aurora take all the hassle out of managing database servers yourself. It also gives you the flexibility to easily spin up and down additional instances and as when required. Where Aurora outshines RDS is in terms of performance - we saw around 2-5x improvement in query read times across the board.
Andrew Raines profile photo
At the time of evaluation, BigQuery didn't have full SQL support. SQL support has since been added, but I'm not sure if it supports full ANSI SQL.
Yogen Sanghani profile photo

Return on Investment

  • Moderately reduced database running costs
  • Improved performance of database cluster which in turn has had a positive impact on the response times of our API services
Andrew Raines profile photo
  • Our clients have achieved great ROI by migrating all or parts of their data from expensive data warehouse hardware solutions to Redshift.
  • Some clients are seeing increasing costs of Redshift, as they are being charged for provisioned capacity, and are looking at alternative solutions which provide pay per use options.
Yogen Sanghani 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

Amazon Redshift

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