MongoDB vs MySQL comparison

Cancel
You must select at least 2 products to compare!
MongoDB Logo
102 views|79 comparisons
91% willing to recommend
Oracle Logo
Read 142 MySQL reviews
10,906 views|8,720 comparisons
91% willing to recommend
Comparison Buyer's Guide
Executive Summary

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.
To learn more, read our detailed MongoDB vs. MySQL Report (Updated: March 2024).
768,886 professionals have used our research since 2012.
Featured Review
Quotes From Members
We asked business professionals to review the solutions they use.
Here are some excerpts of what they said:
Pros
"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."

More MongoDB Pros →

"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."

More MySQL Pros →

Cons
"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."

More MongoDB Cons →

"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."

More MySQL Cons →

Pricing and Cost Advice
  • "We are using the Community Edition of MongoDB."
  • "It is rather expensive."
  • "MongoDB is an open-source solution."
  • "This is an open-source solution."
  • "We use the open-source version, which is available to use free of charge."
  • "I don't know, but I have heard from people who procure it that it is much cheaper than Oracle."
  • "MongoDB is not expensive."
  • "At the moment, all customers are using the community version."
  • More MongoDB Pricing and Cost Advice →

  • "When you know the setup will continue to grow, make sure you have the paid support."
  • "​Enterprise editions and support are definitely needed for the heavy users who need direct support. ​"
  • "MySQL Enterprise Support is not cheap, though might still be cheaper than Oracle or SQL Server. They may not have local support depending on where you’re based, but there are many smaller agencies out there that will readily provide support. You’ll need to spend some time looking around."
  • "Can range from free to quite expensive, depending on the environments and requirements, so better to really set goals ahead of setting it up."
  • "I am using the Community Edition, which is available free of charge."
  • "This is an open-source product that can be used free of charge."
  • "It's an open-source database management system that can be used free of charge."
  • "Microsoft licensing for SQL Server is probably ten times more expensive. I used to work for the government, and I remember when we were looking into upgrading to the enterprise version of SQL Server 2019, the licensing was going to cost 350,000. To get the equivalent in the cloud, it was going to be about four grand to get the same processing power and everything else. With MySQL, it was going to be about 300 for the same licensing. Cost-wise, for sure, there is a huge difference. Would you prefer to pay 300 a month or 3,000 to have the same amount of data resources? You might lose a few options that you need, but it isn't worth the price difference."
  • More MySQL Pricing and Cost Advice →

    report
    Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
    768,886 professionals have used our research since 2012.
    Questions from the Community
    Top Answer:We decided to work with MongoDB as its interface is easier to understand and more universal.
    Top Answer:MongoDB is an open-source product. We don't have to pay for the licenses.
    Top Answer:They could provide more documentation and examples for adding pipeline stages. There could be a feature where commands made in MongoDB could be easily copied and shared in their original format. This… more »
    Top Answer:MySQL encrypts connections to protect your data and the biggest benefit from this is that nobody can corrupt it. If you move information over a network without encryption, you are endangering it… more »
    Top Answer:I may be considered a MySQL veteran since I have been using it since before Oracle bought it and created paid versions. So back in my day, it was all free, it was open-source and the best among… more »
    Top Answer:One thing I would improve related to MySQL is not within the product itself, but with the guides to it. Before, when it was free, everyone was on their own, seeking tutorials and how-to videos online… more »
    Ranking
    5th
    Views
    102
    Comparisons
    79
    Reviews
    27
    Average Words per Review
    355
    Rating
    8.0
    1st
    Views
    10,906
    Comparisons
    8,720
    Reviews
    29
    Average Words per Review
    421
    Rating
    8.6
    Comparisons
    InfluxDB logo
    Compared 29% of the time.
    Couchbase logo
    Compared 18% of the time.
    ScyllaDB logo
    Compared 13% of the time.
    Oracle NoSQL logo
    Compared 6% of the time.
    Cassandra logo
    Compared 6% of the time.
    Firebird SQL logo
    Compared 26% of the time.
    PostgreSQL logo
    Compared 11% of the time.
    MariaDB logo
    Compared 9% of the time.
    Teradata logo
    Compared 7% of the time.
    SQL Server logo
    Compared 7% of the time.
    Learn More
    Overview

    Headquartered in New York, MongoDB's mission is to empower innovators to create, transform, and disrupt industries by unleashing the power of software and data. Built by developers, for developers, our developer data platform is a database with an integrated set of related services that allow development teams to address the growing requirements for today's wide variety of modern applications, all in a unified and consistent user experience. MongoDB has tens of thousands of customers in over 100 countries. The MongoDB database platform has been downloaded hundreds of millions of times since 2007, and there have been millions of builders trained through MongoDB University courses. To learn more, visit www.mongodb.com.

    MongoDB Features

    MongoDB has many valuable key features. Some of the most useful ones include:

    • Load balancing: MongoDB supports large-scale load balancing via horizontal scaling features like replication and sharding.
    • Ad-hoc queries: With this feature, developers are able to update ad-hoc queries in real time.
    • Sharding: With MongoDB, sharding allows for much greater horizontal scalability, with queries that are directed to the correct shard based on specific shard keys.
    • Indexing: MongoDB allows indexing to be created on demand, accommodating real-time, ever-changing query patterns and application requirements. They can also be declared on any field within any document, including those nested within arrays.
    • Replication: MongoDB’s replication feature enables you to deploy multiple servers for disaster recovery and backup, which helps increase data availability and stability.

    MongoDB Benefits

    There are many benefits to implementing MongoDB. Some of the biggest advantages the solution offers include:

    • Horizontal architecture: Because MongoDB is designed with horizontal architecture, it is easy to scale.
    • Developer-friendly: Being that MongoDB is a document data model with NoSQL, developers are able to work faster. In addition, MongoDB gives developers a number of useful out-of-the-box capabilities, whether you need to run privately on site or in the public cloud.
    • Cloud-based: Because MongoDB is a full cloud-based application data platform, you gain access to a collection of services that can integrate nicely with your database.
    • Powerful analytics: MongoDB is designed to make data easy to access, and also allows you to perform complex analytics and querying.
    • High performance: With MongoDB, information can be embedded inside a single document rather than relying on expensive join operations from traditional relational databases.
    • Easy to install: MongoDB has an intuitive UI, making it easy to install. You can install the community or enterprise version directly on a server, create your own container, or use a pre-built community one.
    • Cost-effective: MongoDB gives you the option to choose an instance size that fits your current needs to help you keep your costs at a minimum.

    Reviews from Real Users

    Below are some reviews and helpful feedback written by PeerSpot users currently using the MongoDB solution.

    PeerSpot user Deepak K., Managing Director at SimSol Technologies And Services Pvt Ltd., says, “The solution is a very dynamic product. It becomes extremely easy for us to support user requirements and we also make use of the simplicity of a cloud redeployment.” He goes on to add, “The solution is easy to deploy, and the product can scale quite well. The solution's most important aspect is its seamless database. The solution offers excellent documentation.”

    A Senior Associate at a financial services firm mentions, “The most valuable feature of the solution is the ability to easily store documentation regarding structures. We can easily connect to MongoDB and search without transformation, without joining. If we want to use a simple search it's really fast. The initial setup isn't really that complex. The solution is pretty stable overall.”

    MySQL is an open-source relational database management system (RDBMS) owned by Oracle. Before Oracle acquired the product, it was completely free for users. After the merge, the solution started offering paid services with more features, alongside a free version. MySQL can easily integrate with a wide variety of programming languages, which makes it one of the most flexible and reliable products among its competitors. This cost-effective solution helps users deliver high-performance and scalable database applications through several products. They include:

    • MySQL HeatWave: This is an in-memory query accelerator for MySQL. It is a parallel, columnar, hybrid query-processing engine with algorithms for distributed query processing. This database service is used for transactions, analytics, and machine learning (ML). It offers simplified, secure real-time analytics. It can be deployed on Oracle Cloud Infrastructure (OCI), Amazon AWS, Azure, and users' data centers.

    • My SQL Enterprise Edition: This edition of the solution includes the most comprehensive set of advanced features, technical support, and management tools. The combination functions achieves security, scalability, reliability, and uptime, while reducing risk, cost, and complexity, in managing MySQL applications.

    • MySQL Standard Edition: This edition utilizes industrial-strength performance and reliability to help users deliver high-performance and scalable Open Transaction Processing (OLTP) applications.

    • MySQL Classic Edition: This is an embedded database for independent software vendors (ISVs), original equipment manufacturers (OEMs), and value-added resellers (VARs), that are developing applications using the MyISAM storage engine.

    • MySQL Community Edition: This is the free version of the product, which is supported by a large active community of open-source developers.

    • MySQL Cluster CGE: This is a distributed database that combines linear scalability and high availability. It offers in-memory real-time access across partitioned and distributed databases.

    • MySQL Embedded: This product offers MySQL as an embedded database and is most widely used by ISVs, OEMs, and VARs. It is utilized for making applications, hardware, and appliances more competitive by bringing them to market faster while lowering their cost of goods sold (COGs).

    My SQL Features

    The characteristics of each MySQL edition differ depending on what it offers and what clients it is catered towards. But the main features of the product include the following:

    • Internals and portability: These capabilities allow MySQL to work on multiple platforms and provide transactional and non-transactional storage engines. This set of features is tested with Purify, Vilgrind, and a broad range of different compilers.

    • Data types: Due to the flexibility of the data types feature of MySQL, the product is compatible with a very wide variety of data types, including fixed-length and variable-length string types.

    • Statements and functions: This feature allows MySQL full operator and function support. It supports a wide variety of functions and allows users to refer to tables from different databases in the same statement.

    • Security: The security features of MySQL provide users with a flexible privileged password system that enables host-based verification. The product offers encryption of all password traffic when users connect to a server.

    • Scalability and limits: MySQL supports large databases with up to approximately 50 million records and up to 64 indexes per table.

    • Connectivity: The connectivity features of the product allow clients to connect to MySQL using several protocols, providing them with freedom of choice in terms of which ones to use.

    • Localization: Through this feature, the product offers availability to users in many languages. The server time zone can be changed dynamically and allows clients to specify their own time zone for their convenience.

    • Clients and tools: The product includes several client and utility programs among its capabilities.

    MySQL Benefits

    MySQL brings many benefits to organizations that use it for their data. The most common ones include:

    • Due to its initial open-source nature, MySQL is an easy to understand and beginner-friendly product.

    • The solution still supports an open-source version as well, which means users can download, use, and modify it based on their requirements.

    • MySQL ensures the consistency of data by storing it efficiently and minimizing redundancy.

    • This is considered one of the fastest solutions on the market, a fact which is backed by many benchmark tests.

    • MySQL is very flexible and supports a large number of embedded applications.

    • The solution is compatible with many operating systems.

    • This product offers clients the option to roll back transactions, as well as commit, and crash recovery.

    Reviews from Real Users

    According to a database engineer at a retailer with more than 10,000 employees, MySQL is a great open-source product that offers great scalability and compatibility.

    Yong S., a solutions specialist, system integration, appreciates this product because it has different licensing options and is easy to set up.

    Sample Customers
    Facebook, MetLife, City of Chicago, Expedia, eBay, Google
    Facebook, Tumblr, Scholastic, MTV Networks, Wikipedia, Verizon Wireless, Sage Group, Glassfish Open Message Queue, and RightNow Technologies.
    Top Industries
    REVIEWERS
    Computer Software Company28%
    Financial Services Firm16%
    Legal Firm6%
    Comms Service Provider6%
    VISITORS READING REVIEWS
    Financial Services Firm16%
    Computer Software Company13%
    Comms Service Provider7%
    University6%
    REVIEWERS
    Computer Software Company22%
    Financial Services Firm11%
    University10%
    Comms Service Provider9%
    VISITORS READING REVIEWS
    Computer Software Company16%
    Comms Service Provider10%
    Financial Services Firm10%
    Manufacturing Company6%
    Company Size
    REVIEWERS
    Small Business41%
    Midsize Enterprise14%
    Large Enterprise46%
    VISITORS READING REVIEWS
    Small Business24%
    Midsize Enterprise14%
    Large Enterprise62%
    REVIEWERS
    Small Business45%
    Midsize Enterprise19%
    Large Enterprise37%
    VISITORS READING REVIEWS
    Small Business26%
    Midsize Enterprise15%
    Large Enterprise59%
    Buyer's Guide
    MongoDB vs. MySQL
    March 2024
    Find out what your peers are saying about MongoDB vs. MySQL and other solutions. Updated: March 2024.
    768,886 professionals have used our research since 2012.

    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.