We performed a comparison between Amazon Aurora and MySQL based on real PeerSpot user reviews.
Find out in this report how the two Relational Databases Tools solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The most valuable feature is that the maintainability is offloaded to the service provider. I don't have to maintain a database or do any administrative tasks, which comes in handy."
"We had better control over the parameters that we could tweak in terms of intermediate storage and better indexing capabilities."
"Aurora's compatibility with MySQL or PostgreSQL benefited our database management. The migration from on-premise MySQL to Aurora was similar, so we didn't need to change our source code."
"The provision of custom read and write endpoints eliminates the need for managing a separate proxy load balancer."
"The most valuable feature is the ability to do multiple-read and single-write. These are the kinds of features that we were interested in, and Aurora takes care of that natively."
"The most valuable feature of Amazon Aurora is SQL standardization, it doesn't have its own syntax which is good. It has a lot of hands-off self-management type of activities, such as log rolling and auto-scaling."
"The solution’s scalability is good since we don’t need to take a maintenance window during unpredictable workloads. I like the solution’s behind-the-scenes happenings. It is a great feature."
"One of the most valuable features is MySQL's ability to run our email system. We use a system called Colab."
"Apart from the features that are in the enterprise part, we find the database to be valuable. The connectors and the backup features are valuable as well. We use the basic database. We don't really use the extra features. Our clients like the security features in the database."
"I use MySQL for employee service in an OLTP database."
"The deployment process is pretty fast."
"A lot of the software components have been trialed and tested for often more than 10 years."
"The relations in the database, the dynamic workflow, and the ability to connect with all columns. It's useful for e-commerce."
"The IO segregation in CGE is valuable."
"We are completely comfortable with the database’s performance and it is a mature product. My organization was looking for an open-source database for our smaller customers like the community edition. For bigger customers, we can scale into commercial and supported editions."
"I would like to see more AI-related features in future releases."
"It would have been helpful if they had provided some benchmarking numbers."
"The pricing could improve. It should be reduced."
"I would like to see performance insights on the database based on the queries. Currently, we use SolarWinds as the monitoring tool. I would like to leverage SolarWinds’ performance insights in AWS services. SolarWinds gives larger insights when we run performance issues."
"It is a bit costly. The features are quite good, and I wouldn't say it requires any technical improvements. But from a cost perspective, some clients wouldn't go for Aurora because of that."
"The product's distributed query process for MySQL needs improvement."
"There is improvement needed to have more developer focus. Additionally, it would be helpful to have a stand-alone solution outside of Amazon. Amazon has a tendency to favor developing web-based clients, which may not always provide the fastest or most responsive solution as desired."
"There are some issues with compatibility with Java environments that need to be improved. When Oracle bought this solution there were some driver changes that caused some issues with operations."
"The auto-tuning and NDB cluster has some limitations regarding foreign keys."
"Even for the best database, we always want the database to perform much better, so we wish MySQL would be much better, in terms of performance."
"If it had something similar to Microsoft’s DTS engine then it would be the best database system out there."
"While utilizing a comparable algorithm, is noted to be sensitive, especially when configuring the inner device."
"I would like to have the ability to cancel a query in SQL Developer."
"The GUI interface probably can be improved. Let us say I want to see the relationships in the database. In the query analyzer, I would like to go and drop the tables and create relationships between the tables. I haven't found a feature like that in MySQL. It was a shortcoming even in SQL Server. MySQL can have more performance monitoring tools. I know Google has these tools, but within MySQL, there are not that many tools to monitor things like performance and database locking. They might be in there, and I might not be familiar enough to know where they are. I am a pretty new user of MySQL."
"Security is a concern. MySQL could have better security features."
Amazon Aurora is ranked 10th in Relational Databases Tools with 7 reviews while MySQL is ranked 4th in Relational Databases Tools with 142 reviews. Amazon Aurora is rated 7.8, while MySQL is rated 8.2. The top reviewer of Amazon Aurora writes "Easy-to-manage platform with a valuable auto-scaling feature ". On the other hand, the top reviewer of MySQL writes "Good beginner base but it should have better support for backups". Amazon Aurora is most compared with SQL Server, Oracle Database, MariaDB, CockroachDB and SAP HANA, whereas MySQL is most compared with Firebird SQL, PostgreSQL, MariaDB, Teradata and Vertica. See our Amazon Aurora vs. MySQL report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools reviews to prevent fraudulent reviews and keep review quality high. We do not post reviews by company employees or direct competitors. We validate each review for authenticity via cross-reference with LinkedIn, and personal follow-up with the reviewer when necessary.