What users are saying about

Amazon Aurora

42 Ratings

MySQL<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>

Top Rated
634 Ratings

Amazon Aurora

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

MySQL<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>

Top Rated
634 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

Add comparison

Likelihood to Recommend

Amazon Aurora

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.
Andrew Raines profile photo

MySQL

MySQL is very well-suited to read-intensive database applications. It is very fast. It is also a great enterprise database for new DBAs because it is easy to obtain and installs on a variety of systems and platforms. Although I have not directly experienced problems, MySQL developers report that transactions aren't handled efficiently and that its trigger functionality is lacking sophistication. The biggest problem I've seen with it is how difficult it is to maintain stored procedures. That is a very common complaint and not isolated to my applications.
Kenneth Hess 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
  • It is incredibly simple to implement even across operating systems such as Windows and Linux.
  • It is very easy to configure and manage. Setting parameters and memory profiles is very straightforward, backups are simple, and stopping, starting, and deploying are very easy.
  • The different storage engines represent distinctive features sets and allow for flexible feature rich deployments within the same database.
  • It follows the more extended name space used by products such as SQL Server and Sybase. This namespace is more flexible.
Christopher Weiss profile photo

Cons

  • 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.
Vasco Mendes profile photo
  • Upgrading to newer versions of MySQL was sometimes challenging.
  • Communication with online backup server stopped working and is pretty complicated to set up.
  • Lots of the UI is very basic and limited.
No photo available

Likelihood to Renew

No score
No answers yet
No answers on this topic
MySQL8.1
Based on 3 answers
For teaching Databases and SQL, I would definitely continue to use MySQL. It provides a good, solid foundation to learn about databases. Also to learn about the SQL language and how it works with the creation, insertion, deletion, updating, and manipulation of data, tables, and databases. This SQL language is a foundation and can be used to learn many other database related concepts.
No photo available

Usability

No score
No answers yet
No answers on this topic
MySQL7.6
Based on 4 answers
Usability I think it's pretty good overall.
No photo available

Support

No score
No answers yet
No answers on this topic
MySQL8.4
Based on 2 answers
The support staff is friendly, knowledgeable, and efficient. I only had to get part way through my explanations before they had a solution. They will walk you through a fix or actually connect in and fix the problem for you--or would if you can allow it. I've done it both ways with them. They are always forthcoming with 'how to do this if it happens again' information. I love working with MySQL support.
Kenneth Hess profile photo

Implementation

No score
No answers yet
No answers on this topic
MySQL7.3
Based on 1 answer
1. Estimate your data size.2. Test, test, and test.
No photo available

Alternatives Considered

Unlike proprietary solutions like Microsoft SQL Server, Amazon Aurora does not need proprietary licensing, so we can use this budget to get cloud solutions with high availability and performance, at a similar rate. When compared to MySQL or Postgres SQL, it allows us to have a database system always updated with the most current features and security best practices without having to worry about it. In normal database systems like MySQL to keep the database system up to date we need to have someone always looking for new upgrades.As it relies on MySQL there is no extra formation for a team that is already used to a MySQL solution.
Vasco Mendes profile photo
MySQL is as good as any other relational database out there. Even it's closest competitor PostgreSQL, has only a slight advantage over performance and nothing big here.
Bhargav Nanekalva profile photo

Return on Investment

  • 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.
Vasco Mendes profile photo
  • Since it is not as resource hogging as other options, it is easier to set it up on relatively cheaper servers.
  • For projects with a very small implementation period, you'll be able to get up and running with it pretty quickly which is big deal in a lot of ways.
  • With proper configuration, it scales well, saving a lot of money again.
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

MySQL

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