We performed a comparison between MongoDB and MySQL based on real PeerSpot user reviews.
Find out in this report how the two Open Source Databases solutions compare in terms of features, pricing, service and support, easy of deployment, and ROI."The aggregation framework is very powerful when elaborating on data."
"Migrating to MongoDB upgrades the IT environment and puts users in the NoSQL environment, which is faster."
"The solution does not hold data in tabular format like SQL does but rather clusters data so that it can link on a large scale."
"The most valuable features of MongoDB are we have a lot of documentation and SQL-based applications that run on it."
"The most valuable feature is that you can store unstructured data, which is helpful when you don't know what the best structure should be and you cannot use a relational database because of that."
"It's easy to add and remove things in MongoDB. You can alter the tables. MongoDB is faster at reading, slower at writings."
"I find the integration with other tools very easy."
"I think that MongoDB isn't too structured, and that's good for our technical team because they are able to search through the database better than if they are using SQL Server."
"The solution is very stable."
"We use the basic features of MySQL. The interface that allows us to see the parameters of the server is good."
"MySQL is an easy-to-use solution that provides stability, reliability, flexibility, performance, security, and high availability."
"I rate the solution's stability a ten out of ten since it has been running flawlessly."
"The most valuable feature of MySQL is auto-scaling."
"It has a community version. When I have to create a new database, I have no problems with licenses."
"MySQL is an open-source product and has good community support. If you encounter any problem, you can easily ask other members of the community to help. They help you a lot. On top of being free, MySQL is a cross-platform database, meaning it can work on both Windows and Linux. It is very good for us."
"MySQL gives us all of the critical features that we need in a database, but without the costs."
"The user interface is not as friendly as Oracle, which is something that can be improved."
"There should be better integration with other databases."
"Our program developer finds it to be a little unstable, development-wise."
"We'd like technical support to respond faster to queries."
"It would be much more useful if I have an admin user and a password."
"The performance can be improved."
"The product's data consistency could be more efficient than traditional SQLs."
"A normal Oracle or database tester will take some time to gear up to MongoDB because the way of writing queries is different in MongoDB. There should be some kind of midway where a person who is coming from an Oracle background can write a query and get a response by using something like a select * statement or other such things. There should be some way for MongoDB to interpret these commands rather than making a person learn MongoDB commands and writing them. I struggled while writing these MongoDB commands. I had not seen such queries before. It was pretty difficult to get them. This is one of the areas where it would help from the improvement standpoint."
"The interface could be improved."
"I did the implementation of the solution myself and I used community support. The support from the vendor costs money."
"From a user perspective, the initial setup could be simplified a bit."
"It can have better monitoring. In addition, the enterprise manager should be able to cater to more than one virtual machine. Currently, you need one license per server. It seems a bit too much to get one license for one enterprise manager. I hope the enterprise manager for MySQL can accommodate more virtual machines for MySQL."
"Its performance should be better. When we use big data, it is slow in performance. We should be able to use mirroring for improved performance."
"I would like to have the ability to cancel a query in SQL Developer."
"The licensing of the solution is on the expensive side."
"MySQL lacks a feature akin to Oracle's Real Application Clusters, which ensures continuous database availability within the same data center or nearby data centers."
MongoDB is ranked 5th in Open Source Databases with 69 reviews while MySQL is ranked 1st in Open Source Databases with 142 reviews. MongoDB is rated 8.2, while MySQL is rated 8.2. The top reviewer of MongoDB writes "Lightweight with good flexibility and very fast performance for searching data". On the other hand, the top reviewer of MySQL writes "Good beginner base but it should have better support for backups". MongoDB is most compared with InfluxDB, Couchbase, ScyllaDB, Oracle NoSQL and Cassandra, whereas MySQL is most compared with Firebird SQL, PostgreSQL, MariaDB, Teradata and SQL Server. See our MongoDB vs. MySQL report.
See our list of best Open Source Databases vendors.
We monitor all Open Source Databases 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.