What users are saying about
44 Ratings
89 Ratings
44 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
89 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

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

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

  • Automated maintenance for upgrades is by far the most superior feature of Amazon Aurora. Never be behind on upgrades again!
  • Performance improvements for poorly structured schema due to enhancements added by Amazon.
  • Replication works flawlessly due to added security measures added into Amazon Aurora which prevents admin users from "accidentally" breaking the slave instance.
  • Amazon Aurora is hosted on Amazon's RDBMS which also includes quick and easy setup of new database instances.
No photo available
  • Redshift is fully managed. Small teams do not have the resources to maintain a cluster. CloudWatch metrics are provided out-of-the-box, and it is easy to configure alarms.
  • Redshift's console allows you to easily inspect and manage queries, and manage the performance of the cluster.
  • Redshift is ubiquitous; many products (e.g., ETL services) integrate with it out-of-the-box.
  • Writing .csvs to S3 and querying them through Redshift Spectrum is convenient.
Gavin Hackeling profile photo

Cons

  • I'd like to see Amazon Aurora get ahead of the curve on MySQL and introduce their own improvements to MySQL to make it a superior database so that I don't need to use SQL Server or Oracle to get performance improvements. For example, improve performance of views.
  • Amazon Aurora needs to improve the ability to restore backups as needed. Currently, the user can only restore an entire instance to a new or existing RDBMS instance. If you need to retrieve data from a single table, this can be tedious after waiting hours for an entire restore to complete. Instead, allow the user to select a database to restore. Better yet, allow the user to restore a database backup to ANOTHER database - which would allow you to restore a database on the same instance.
  • Again beat MySQL to the punch and introduce REAL server to server communication since they have disabled the "Federated Engine" which was the only way previously to do this. I'd like to be able to setup MySQL instances to talk to other MySQL instances.
No photo available
  • 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

Usability

No score
No answers yet
No answers on this topic
Amazon Redshift10.0
Based on 1 answer
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

In the end, we went with Amazon Aurora due to the decent performance and cost. Cost was determined in two ways for us: 1) no additional license is required (such as using SQL Server or Oracle) and 2) the ability to cut down on needed resources to maintain the system from the maintenance perspective due to the built-in maintenance capabilities. Amazon Aurora is also based on MySQL (soon to include PostgreSQL ) which allowed my team to quickly and easily move our existing MySQL servers to a faster system.
No photo available
Prezi is using AWS so Amazon Redshift was the obvious choice. It is fast, scalable and easy to use. Supplemented with Spark and Hive I'm completely satisfied using Redhsift. Sometimes I miss commands I used earlier on MS and Oracle SQL and the lack of procedural features is also negative
Tamás Imre profile photo

Return on Investment

  • The main positive for my team is the time that has been freed up from the tasks of managing updates and fixing replication issues.
  • A negative for myself as a database administrator is removal of features that were available in Mysql. Examples include 1) the use of the storage engines other than InnoDB (such as the Federated Storage Engine), 2) certain administrative privileges such as ability to export to csv file and easy ability to kill processes. I seem to also forget they removed the built-in kill ability and you must use their own provided kill functionality.
No photo available
  • Increased the end users as the reports and dashboards was very helpful to give a clear insights of business
  • Increased business as the analysts were able to retrieve the data in quick time
  • Improved the data retrieval as most are familiar with SQL
Vinaybabu Raghunandha Naidu 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