Amazon Aurora Reviews

63 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener noreferrer'>trScore algorithm: Learn more.</a>
Score 8.9 out of 100

Do you work for this company? Manage this listing

Overall Rating

Reviewer's Company Size

Last Updated

By Topic

Industry

Department

Experience

Job Type

Role

Filtered By:

Reviews (1-12 of 12)

Ilyas Bakouch | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Optimized storage type for intensive I/O operations.
  • Continuous backups to S3.
  • 5x higher throughput than regular MySql 5.6.
  • Even though you are only billed per second of usage, there is a minimum of 5 minutes billed each time the database is active.
  • For high load apps, Aurora Serverless is extremely expensive as compared to a single provisioned Aurora instance.
Read Ilyas Bakouch's full review
Arthur Zubarev | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Easy scaling - can be either horizontal and/or vertical.
  • Nearly seamless backups, easy management.
  • 0 worries about server-side security.
  • Secondaries: up to 15 read-only replicas are enough even for very analytics hungry enterprises plus it makes all the data immutable.
  • Speed: it is hard to say 100% accurately, but in my view, Aurora beats all in the cost to speed ratio.
  • The Small and Medium instances are only good for testing or development, the number of connections and resources is limited.
  • The 5.7 as the latest version of AWS Aurora in MySQL compatibility is behind feature-wise to what the most recent release of MySQL offers (the same applies to Postgres mode).
  • Some odd or sub-optimal configuration values with some parameters not changeable.
  • No online development experience. So one must rely on Open Source tooling that is typically subpar to commercial offerings which in turn often are pricey and requires a desktop environment. I wish AWS Cloud 9 could offer in the Cloud Aurora development.
Read Arthur Zubarev's full review
Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Adding and removing reader nodes is seamless
  • Failover is fast
  • Low replication delay on reader nodes
  • Some quirks exist with corner case behaviors. e.g. we had some perf issues with GIN indexes.
  • A little slow to provide the latest Postgres versions. We'd love to use Postgres 12.
  • The endpoints are ok, but we end up implementing our own to better meet our use cases.
  • Best practices incur additional data transfer costs. I would expect those not to be charged.
Read this authenticated review
Jesse Bickel, MS - PMP | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Amazon Aurora's billing style is ideal. You only pay for what and when you use it. If you store large amounts of data but do not need to query against it, there is no cost until you do.
  • Amazon Aurora is highly supported and has seemed to be supported by a knowledgeable staff. While the use rolled into our premium support agreement, we found their staff and training resources to be well above average.
  • The speed is industry leading relational database. That simple. Faster, more secure and reliable.
  • While the service is outstanding there does seem to be a routine issue in connecting or keeping connections to Amazon RDS DB Instances at times or the connection is slow. I think clearer documentation would be highly beneficial here.
  • Increased logs or discovery notes in the event of a replication failure.
Read Jesse Bickel, MS - PMP's full review
Anonymous | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • It is a high performance and low latency database. You can also be assured of the high-availability of the database and the services hosted.
  • The Security provided by Amazon is again top notch because all of the data is encrypted and secured. The customers feel much more relaxed and assured when the project is using Amazon Aurora to host their services.
  • A big plus point for Amazon Aurora is the latest and impactful upgrades which it brings in the package. The automated up-gradation and maintenance is an outstanding feature which it provides to receive and stay up to date with the latest upgrades in the DB world.
  • It is compatible with MySQL and PostgreSQL. It essentially means that the database is able to support the old data-sets and tools which were being used on those DB's. This is a great advantage because it is essentially backward compatible.
  • The Amazon technical team behind the development of this software is very knowledgeable and supportive as well. We told our requirements clearly and they suggested the best use of the database for us, which scenario it should be used, and which it is not a perfect fit.
  • I think the biggest point for a project or team to consider is the cost. Although it can scale and descale according to your requirements, still you need to be cautious and have a vision of how big your database is going to be, how complex it is going to be, and how much does latency matter. You need to factor all those decisions before going to spend extra on Amazon Aurora as compared to a simple MySQL database.
  • It suffers from Clod start which is a very well known aspect of the product. But the recovery part is also not up to the mark. They need to improve on the ability to restore a copy of the backup, but mostly it is seen that the copy is corrupted or not the latest one.
  • It does allow us to add new nodes to the existing cluster but we need to be wary of that the new nodes are read-only nodes. All the functions of write/update will still be carried out by the master node only.
Read this authenticated review
Anonymous | TrustRadius Reviewer
March 11, 2019

Amazon Aurora Review

Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Performance: We utilize Aurora as a PostgreSQL replacement, and Aurora's throughput is up to 3 times higher.
  • Simple Instance Auto-Scaling: We can scale the underlying database engine up or down with no down time.
  • Auto-Growing Storage: Rather than having to over-provision, Aurora automatically adds blocks of 10GB to your storage cluster up to multiple terabytes of storage.
  • Support for additional engines: Right now, Aurora is limited to MySQL and PostgreSQL.
  • PostgreSQL-specific Instance Types: The PostgreSQL has high minimum instance type variants; while MySQL can take advantage of t3 instances, the minimum PostgreSQL instance is too large for lower-budget workflows and tests/debugging.
Read this authenticated review
Shiv Shivakumar | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • used as a supplement to mySQL database in the business for SQL
  • sheer power of performance is much faster
  • supports data growth/data storage and having replicas of databases very well
  • ability to read faster from the replicas in the event that there is a problem with Amazon Aurora - there is a latency involved and this can be reduced
  • supports only a particular version of mySQl 5.16.10 and hence does not work with older versions
Read Shiv Shivakumar's full review
Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Aurora is a relational database as a service on AWS which is MySQL and Postgres compatible. So if you are looking for a serverless option which going through need to host and manage a database then Aurora as a service is great.
  • It is a simple and cost-effective open source database which is much cheaper than a normal database cost. Hence very efficient for microservices database where you do not need one very large centralized database but many small databases that are available and low latency.
  • Aurora provides high performance and low latency. Last year they also announced multi-master in the same region and read replicas in multiple regions. This is very convenient if you are trying to design and build a highly reliable application.
  • Just like AWS DynamoDB which is a not a SQL solution and is truly a global DB, it would be great if AWS Aurora can become a global DB. What that means is that it is multi-region multi-master. That way writes to different regions of AWS would all be in sync and available in replicas on different regions.
Read this authenticated review
Anonymous | TrustRadius Reviewer
Score 9 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • Aurora's throughput is great compared to MySQL and MariaDB.
  • Aurora Serverless's pay-per-use makes it very inexpensive when used for services that are idle most of the day. This helps us adhere to the one-database-per-microservice pattern; cost is no longer a concern.
  • Aurora is mostly managed. Administering databases will never be a competitive advantage for my company.
  • Aurora has great integration with other AWS products, like DMS.
  • 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.
Read this authenticated review
Andrew Raines | TrustRadius Reviewer
Score 10 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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
  • 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
Read Andrew Raines's full review
Vasco Mendes | TrustRadius Reviewer
Score 8 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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
  • 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.
Read Vasco Mendes's full review
Anonymous | TrustRadius Reviewer
Score 7 out of 10
Vetted Review
Verified User
Review Source

Pros and Cons

  • 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.
  • 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.
Read this authenticated review

About Amazon Aurora

Amazon Aurora is a MySQL compatible relational database system from Amazon Web Services.
Categories:  Relational Databases

Amazon Aurora Technical Details

Operating Systems: Unspecified
Mobile Application:No