What users are saying about
50 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
121 Ratings
50 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.8 out of 101

Amazon Redshift

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>
121 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.4 out of 101

Likelihood to Recommend

Amazon Aurora

For workloads that already use, or plan on using, MySQL or PostgreSQL, Aurora is our new go-to favorite deployment option for projects on AWS. The best use cases for Aurora will be substantial workloads that are well-suited to the simple scaling controls (both from an instance type perspective, as well as storage perspective), and will benefit from Aurora's simple, very low latency read replicas. Aurora is extremely fault tolerant and has improved self-healing ability.
No photo available

Amazon Redshift

Very well suited for aggregating/denormalizing data when you need a reporting environment. Can provide extremely fast querying for analytical purposes. Very nice to not have to have in house responsibility for sensitive data.Not appropriate for a transactional system (though this is not what it is built for obviously). Must keep in mind the data you are syncing up to the cloud and scrub if necessary before. Something to always be mindful of of course.
Brendan McKenna profile photo

Pros

Amazon Aurora

  • Amazon Aurora has high availability, since the customer started to use it, the database never had to be left out of service.
  • Amazon Aurora provides frequent and automated upgrades, which makes our database system always up to date on the latest features and security practices
  • Since Amazon Aurora uses MySQL as its core database, it is very easy to find specialized people to work. Amazon’s relational database management system also makes it very easy to expand and create new databases
Vasco Mendes profile photo

Amazon Redshift

  • Extremely fast querying allowing for concurrent analysis.
  • PostgreSQL syntax which allows for developers with a SQL background to easily begin working with the data.
  • Multiple output formats including JSON.
  • Safe, easy, and reliable backups.
Brendan McKenna profile photo

Cons

Amazon Aurora

  • Cold-starts are part of the Aurora Serverless compromise, but they are painful nonetheless.
  • We're accustomed to sub-second metering for AWS Lambda; Aurora Serverless has 1-minute minimums for resources.
  • Aurora Serverless is compatible with MySQL 5.6. MySQL 5.6 lacks many of the features PostgreSQL users will expect.
No photo available

Amazon Redshift

  • We've experienced some problems with hanging queries on Redshift Spectrum/external tables. We've had to roll back to and old version of Redshift while we wait for AWS to provide a patch.
  • Redshift's dialect is most similar to that of PostgreSQL 8. It lacks many modern features and data types.
  • Constraints are not enforced. We must rely on other means to verify the integrity of transformed tables.
Gavin Hackeling profile photo

Usability

Amazon Aurora

No score
No answers yet
No answers on this topic

Amazon Redshift

Amazon Redshift 8.6
Based on 8 answers
Just very happy with the product, it fits our needs perfectly. Amazon pioneered the cloud and we have had a positive experience using RedShift. Really cool to be able to see your data housed and to be able to query and perform administrative tasks with ease.
Brendan McKenna profile photo

Alternatives Considered

Amazon Aurora

Aurora MySQL 5.6 lacks many of the features of PostgreSQL, and even more recent versions of MySQL or MariaDB. You may be able to tolerate these deficiencies; simple OLTP use-cases will be served adequately. Like RDS and DynamoDB, Aurora is managed and integrates well with other AWS products. Amazon Aurora Serverless can be much less expensive than RDS, however.
No photo available

Amazon Redshift

It was a company-wide decision to move to AWS, so we did not get to compare Redshift against SQL Server Azure.
Michael Romm profile photo

Return on Investment

Amazon Aurora

  • Aurora Serverless has allowed us to inexpensively implement best-practices for our microservices architecture.
  • Aurora is mostly managed; our engineers can focus on features instead of database administration.
  • Aurora is capable of high throughput. Speed is not our first priority, but we still benefit from it.
No photo available

Amazon Redshift

  • Redshift has enabled us to expose more of our product and business performance data which was previously not accessible or reportable.
  • We can now make data driven decisions for our business.
No photo available

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

Add comparison