MySQL and InfluxDB are popular databases competing in the database solutions category. MySQL appears to have the upper hand in terms of pricing and support, while InfluxDB stands out for its features and scalability, appealing for specific use cases despite higher costs.
Features: MySQL is known for its multi-threaded architecture, triggers, replication, and full-text search, making it flexible and reliable for small to medium applications and popular in web development. InfluxDB excels in time-series database capabilities, efficient data handling, and strong performance with visualization tools, although it may lack some relational features compared to MySQL.
Room for Improvement: MySQL users highlight challenges with InnoDB complexity, limited support for advanced RDBMS features, and replication reliability. InfluxDB could improve with better clustering, user-friendly interfaces, and comprehensive documentation for easier integration with other tools.
Ease of Deployment and Customer Service: MySQL offers flexibility in deployment across various environments and extensive community support due to its open-source nature. InfluxDB supports diverse deployment options, though users seek better integration. MySQL relies on community forums for support, while InfluxDB users may face higher support costs.
Pricing and ROI: MySQL is cost-effective with a free open-source version and paid enterprise options, offering solid ROI for basic database functions without licensing fees. InfluxDB, also open-source, may incur scaling costs with recent price increases impacting its value for extensive deployments. Both can provide good returns depending on business needs and technical demands.
InfluxDB reduced my time to show data without any interruption, also reducing the number of people needed to manage the project; it is very good to have InfluxDB in my project.
Time saved is there, as I mentioned, because we have an analytics system from where we get alerting and monitoring.
I have seen a return on investment with MySQL, as it allows us to manage with fewer employees, focusing on business logic rather than database management.
I would rate the documentation and online support a 10 out of 10.
We have no issues and usually receive timely responses.
The main challenge with InfluxDB, which is common with all databases, was handling very high throughput systems and high throughput message flow.
We’ve scaled on volume with seven years of continuous data without performance degradation.
InfluxDB's scalability is fine for me; I gather a lot of metrics and have not had any issues.
Meeting scalability requirements through cloud computing is an expensive affair.
MySQL's scalability is currently adequate, as we have increased operations from ten thousand to twelve thousand devices, and it is working fine for us.
It serves as the backbone of our application, and its stability is crucial.
It is very stable, with no reliability or downtime in InfluxDB.
After integrating Kafka, it never broke again, as Kafka handled messages and metrics appropriately, decreasing the message throughput.
We face certain integration issues, especially when we integrate the database with security solutions like IBM QRadar.
From my experience, MySQL was pretty stable.
InfluxDB deprecated FluxQL, which was intuitive since developers are already familiar with standard querying.
Having a SQL abstraction in InfluxDB could be beneficial, making it more accessible for teams that prefer querying with SQL-style syntax.
It could include automated backup and a monitoring solution for InfluxDB or a script developed by a REST API.
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 open-source version of InfluxDB, so it is free.
My experience with pricing, setup cost, and licensing for InfluxDB was great, as I did not use any license.
We are using an open-source solution, so there is no cost on that.
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.
The most important feature for us is low latency, which is crucial in building a high-performance engine for day trading.
InfluxDB’s core functionality is crucial as it allows us to store our data and execute queries with excellent response times.
It helps me maintain my solution easily because it is very reliable, so we didn't face any performance issues or crashes regarding our queries; we can get the results very fast.
With Oracle, we have to buy another solution for encryption and masking, but MySQL supports native encryption, which enhances our return on investment.
The main feature we utilize in MySQL is the view, and I can say that it is the most valuable feature for our needs.
It allows programming, writing stored procedures, creating views, constraints, and triggers easily.
| Product | Market Share (%) |
|---|---|
| MySQL | 9.0% |
| InfluxDB | 5.0% |
| Other | 86.0% |
| Company Size | Count |
|---|---|
| Small Business | 5 |
| Midsize Enterprise | 3 |
| Large Enterprise | 8 |
| Company Size | Count |
|---|---|
| Small Business | 74 |
| Midsize Enterprise | 32 |
| Large Enterprise | 62 |
InfluxDB is open-source software that helps developers and enterprises alike to collect, store, process, and visualize time series data and to build next-generation applications. InfluxDB provides monitoring and insight on IoT, application, system, container, and infrastructure quickly and easily without complexities or compromises in scale, speed, or productivity.
InfluxDB has become a popular insight system for unified metrics and events enabling the most demanding SLAs. InfluxDB is used in just about every type of industry across a wide range of use cases, including network monitoring, IoT monitoring, industrial IoT, and infrastructure and application monitoring.
InfluxDB offers its users:
InfluxDB Benefits
There are several benefits to using InfluxDB . Some of the biggest advantages the solution offers include:
Reviews from Real Users
InfluxDB stands out among its competitors for a number of reasons. Two major ones are its flexible integration options and its data aggregation feature.
Shalauddin Ahamad S., a software engineer at a tech services company, notes, “The most valuable features are aggregating the data and the integration with Grafana for monitoring.”
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.
