TrustRadius
Amazon Aurora is a MySQL compatible relational database system from Amazon Web Services.Great performance and easy transition from MySQLWe use Amazon Aurora as our primary data store which underlies the bulk of our system operations - primarily via web APIs. Its used beneath a PHP stack as a MySQL compatible cluster in a master-slave configuration. We also have master-only clusters for our development and test environments.,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,10,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,Amazon RDS, Amazon Relational Database Service and MySQL,AWS Lambda, AWS OpsWorks, Amazon API Gateway, Amazon CloudFront, Amazon Elastic Compute Cloud (EC2), Amazon ElastiCacheAmazon Aurora - A Boost on Standard MySQLCloud services are the trend. No infrastructure costs and no worries. Cloud databases are also the trend, as they can be easily scalable and upgraded. As a senior consultant I recently configured an Amazon Aurora database to serve as the back-end of an organization software. This software included a main server providing services for mobile applications and also as a back-office web application to manage transaction information. These services relied on the Amazon Aurora database to collect and save information. Customer needed a database accessible from everywhere, with high availability, fast, always up to date and scalable as it was expected the business to grow as well as its storage needs. The Amazon Aurora turned out to be a stable solution with high performance when compared with in-house solutions like MySQL.,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.,8,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.,MySQL, PostgreSQL, MariaDB and Microsoft SQL Server,MySQL, PostgreSQL, Microsoft SQL ServerUsing Amazon Aurora to better your software and development team!Amazon Aurora is used by my organization as the backend for our software. Previously, we hosted our own mysql servers which inevitably due to lack of resources ran behind on updates and thus performed more poorly than it should. Moving to Amazon Aurora has improved performance for a database that was poorly designed at the start and was operating on a slowly outdated MySQL version. Moving to Amazon Aurora not only improved performance, but allows my company to continue with fewer resources but yet have the advantage of a database that is more stable and stays up to date with the latest features. Since moving to Amazon Aurora, we also have fewer replication errors since Aurora does this flawlessly.,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.,7,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.,MySQL, PostgreSQL and Microsoft SQL Server,JIRA Software, HipChat
Unspecified
Amazon Aurora
41 Ratings
Score 8.0 out of 101
TRScore

Amazon Aurora Reviews

Amazon Aurora
41 Ratings
Score 8.0 out of 101
Show Filters 
Hide Filters 
Filter 41 vetted Amazon Aurora reviews and ratings
Clear all filters
Overall Rating
Reviewer's Company Size
Last Updated
By Topic
Industry
Department
Experience
Job Type
Role
Reviews (1-3 of 3)
  Vendors can't alter or remove reviews. Here's why.
Andrew Raines profile photo
April 20, 2018

Amazon Aurora Review: "Great performance and easy transition from MySQL"

Score 10 out of 10
Vetted Review
Verified User
Review Source
We use Amazon Aurora as our primary data store which underlies the bulk of our system operations - primarily via web APIs. Its used beneath a PHP stack as a MySQL compatible cluster in a master-slave configuration. We also have master-only clusters for our development and test environments.
  • 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
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.
Read Andrew Raines's full review
Vasco Mendes profile photo
October 26, 2017

Review: "Amazon Aurora - A Boost on Standard MySQL"

Score 8 out of 10
Vetted Review
Verified User
Review Source
Cloud services are the trend. No infrastructure costs and no worries. Cloud databases are also the trend, as they can be easily scalable and upgraded.

As a senior consultant I recently configured an Amazon Aurora database to serve as the back-end of an organization software. This software included a main server providing services for mobile applications and also as a back-office web application to manage transaction information. These services relied on the Amazon Aurora database to collect and save information. Customer needed a database accessible from everywhere, with high availability, fast, always up to date and scalable as it was expected the business to grow as well as its storage needs. The Amazon Aurora turned out to be a stable solution with high performance when compared with in-house solutions like MySQL.
  • 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.
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.
Read Vasco Mendes's full review
No photo available
May 02, 2017

Review: "Using Amazon Aurora to better your software and development team!"

Score 7 out of 10
Vetted Review
Verified User
Review Source
Amazon Aurora is used by my organization as the backend for our software. Previously, we hosted our own MySQL servers which inevitably due to lack of resources ran behind on updates and thus performed more poorly than it should. Moving to Amazon Aurora has improved performance for a database that was poorly designed at the start and was operating on a slowly outdated MySQL version. Moving to Amazon Aurora not only improved performance, but allows my company to continue with fewer resources but yet have the advantage of a database that is more stable and stays up to date with the latest features. Since moving to Amazon Aurora, we also have fewer replication errors since Aurora does this flawlessly.
  • 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.
Amazon Aurora (as is MySQL) is better suited for light to medium applications considering it still has some performance limitations from MySQL. I would not recommend it for enterprise level use without a carefully constructed backend system (code and database). My company's current backend architecture was not mapped out very well and this leads to performance problems that even Amazon Aurora has not been able to completely sort (although it has been a huge help).

Another area where I am finding it beginning to lack is for use in data warehousing. The more rows added, the less performant I'm finding the data warehouse. Although to be fair, Amazon has another product (Redshift) that we are looking to migrate data warehouses into.
Read this authenticated review

Amazon Aurora Scorecard Summary

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