MySQL and MongoDB Enterprise Advanced compete in the database management category. MySQL holds an advantage in SQL compatibility and performance, while MongoDB Enterprise Advanced is more flexible for handling diverse datasets.
Features: MySQL offers multi-threaded architecture, crash recovery techniques, and SQL compatibility supporting features like replication and stored procedures, ideal for small to medium web applications due to its performance and scalability. MongoDB Enterprise Advanced is noteworthy for its flexibility in handling NoSQL data, scalability, and real-time analytics, making it suitable for large, diverse datasets.
Room for Improvement: MySQL could benefit from simplifying InnoDB, enhancing big data support, and improving clustering and security, which affects its scalability. MongoDB Enterprise Advanced needs better transactional support, enhanced security features, and ease of implementing complex queries.
Ease of Deployment and Customer Service: MySQL is widely used on-premises, offering familiarity but sometimes complexity in hybrid setups. While community support is robust, professional support is limited. MongoDB Enterprise Advanced benefits from diverse deployment options and comprehensive support services, though the initial setup may be challenging.
Pricing and ROI: MySQL offers a low-cost entry as an open-source solution with optional paid Oracle support, providing valuable ROI for small to medium businesses. MongoDB Enterprise Advanced offers a free version but can be costly at the enterprise level, delivering significant ROI for businesses requiring scalable and flexible solutions for complex datasets.
Actually, with MongoDB, it's difficult to calculate the return on investment; it's too expensive for our use.
I would say we see value in money and return on investment with MongoDB Enterprise Advanced.
We have received fairly good support whenever we reached out to the technical teams; they were prompt.
We have no issues and usually receive timely responses.
In CosmoDB, the scalability is much better than with the MongoDB ReplicaSet models.
MongoDB is highly scalable.
Overall, on a scale of one to ten, I would rate MongoDB an eight; it's mostly because we're still running a monolithic environment on old hardware, so there are some limitations with read-write access.
Meeting scalability requirements through cloud computing is an expensive affair.
It's pretty much stable; we have not faced any major challenges or difficulties with MongoDB Enterprise Advanced.
We face certain integration issues, especially when we integrate the database with security solutions like IBM QRadar.
While solutions for other databases like SQL or PostgreSQL already exist, MongoDB requires additional integrations for developing AI solutions.
We have not contracted the security options in our contract because they're too expensive; thus, we implement just encrypted databases and not the security pack.
From the AWS standpoint, if robust integration and data warehouse integration specific tools are added in the advanced suite, that would definitely be helpful.
It could be more beneficial if MySQL can enhance its data masking functionality in the same way it has improved data encryption.
Oracle could improve on scalability.
The load balancer, MySQL LB, which is used to connect to the application, lacks clear documentation.
We use the free version of MongoDB, so there are no licensing costs.
We have to pay approximately 2,000 euros per month for MongoDB.
For a small company, the cost of MongoDB Enterprise Advanced is reasonable, but for heavy data usage, we see a little bit of cost pressure but it's acceptable.
Oracle has different components, so if you need security, you have to procure a different license, but here everything is inbuilt and it's not costly.
It offers flexibility in schema adaptation, allowing us to change the schema and add new data points.
In ReplicaSet, it's acceptable, but if your workload needs more performance, and you must pass to a Sharding model, it becomes complicated in MongoDB; in Cosmos DB, however, it's simple.
MongoDB has definitely helped us improve our network monitoring and reporting dashboard.
With Oracle, we have to buy another solution for encryption and masking, but MySQL supports native encryption, which enhances our return on investment.
It allows programming, writing stored procedures, creating views, constraints, and triggers easily.
My experience with MySQL is very good for organizations that consider database security and availability as priorities.
| Product | Market Share (%) |
|---|---|
| MySQL | 8.8% |
| MongoDB Enterprise Advanced | 5.0% |
| Other | 86.2% |
| Company Size | Count |
|---|---|
| Small Business | 35 |
| Midsize Enterprise | 13 |
| Large Enterprise | 38 |
| Company Size | Count |
|---|---|
| Small Business | 73 |
| Midsize Enterprise | 31 |
| Large Enterprise | 61 |
MongoDB Enterprise Advanced is a comprehensive platform renowned for its scalability, user-friendliness, and high performance, underpinned by its flexible document-based storage and open-source model. JSON compatibility, clustering, and security elevate its standing among professionals.
The platform facilitates efficient data management through developer-friendly tools and a strong aggregation framework. MongoDB’s no-schema requirement, supported by community expertise, underlines its adaptability. While its sharding capabilities and affordably support large data volumes, there are aspects such as security enhancement and enterprise tool integration that need attention. Indexing and query optimization pose challenges, alongside high costs. Improvements in analytics and UI could advance its infrastructure further.
What are the key features of MongoDB Enterprise Advanced?Industries leverage MongoDB Enterprise Advanced for significant roles in data storage within IoT platforms, healthcare apps, public service monitoring, and big data analytics. Companies in logistics and telecommunications find it instrumental for business process management and video content management, benefiting from its seamless integration and unstructured data support.
MySQL is an open-source database known for its ease of use and high performance. It offers features like replication and clustering, making it ideal for diverse applications. Its cost-effectiveness and LAMP integration are key advantages for businesses.
MySQL supports a variety of languages and platforms, providing reliable, scalable data management. Its graphical interface and LAMP architecture integration enhance its usability, while community support further strengthens its appeal. Challenges include scalability issues with large databases, lack of advanced clustering, and limited high-availability features. Complex queries may affect performance, and integration can pose difficulties. The outdated interface and insufficient documentation are also concerns, along with replication and backup reliability issues.
What are MySQL's key features?MySQL is widely implemented in industries such as web development, e-commerce, and finance. It's used for managing dynamic websites, powering e-commerce platforms, and supporting financial applications. Its compatibility with PHP and cost-effectiveness make it suitable for CMS platforms like WordPress. With cloud services integration, MySQL is a backend choice for scalable applications in various sectors.
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.
