Try our new research platform with insights from 80,000+ expert users

MySQL vs Vertica comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

MySQL
Average Rating
8.2
Reviews Sentiment
7.4
Number of Reviews
148
Ranking in other categories
Open Source Databases (1st), Relational Databases Tools (3rd)
Vertica
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Data Warehouse (5th), Cloud Data Warehouse (10th)
 

Mindshare comparison

MySQL and Vertica aren’t in the same category and serve different purposes. MySQL is designed for Open Source Databases and holds a mindshare of 11.6%, down 18.4% compared to last year.
Vertica, on the other hand, focuses on Data Warehouse, holds 8.5% mindshare, up 8.6% since last year.
Open Source Databases
Data Warehouse
 

Featured Reviews

Muzzamil  Hussain - PeerSpot reviewer
Native encryption ensures secure data management with a simple deployment
The most valuable feature is the on-premises data encryption facilities. By default, we can provide encryption, and this feature in MySQL is why we prefer it over other databases. The native encryption in MySQL encourages us to use this database model more frequently compared to Oracle and other databases. With Oracle, we have to buy another solution for encryption and masking, but MySQL supports native encryption, which enhances our return on investment. It perfectly supports our ROI, and we have no issues with its functionality.
T Venkatesh - PeerSpot reviewer
Processes query faster through multiple systems simultaneously, but it could support different data types
We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"Compared to other databases, MySQL is cheaper and we were using the community edition which was free of cost. ML is fully integrated with the database in HeatWave. It has also many other features. MySQL is a far better solution in terms of pricing."
"It creates a unified view of the entire architecture and performance factor, helping to manage the network more easily."
"MySQL is the best option for the Laravel PHP framework."
"MySQL has cross-platform support for multiple operating systems. The backups on a Linux machine can be restored on a Windows machine, and vice versa."
"The tool is open-source and there is no cost involved in its use."
"The feature I found most valuable is activity performance."
"​The most valuable feature of MySQL is the informative error outputs of command line interface.​"
"This specific version of this MySQL has been battle tested for a long time. Any issues are known issues and we pretty much don't have any problems when they're in production. So it's very stable."
"The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"The most valuable feature is Vertica's performance and the ease of using the database."
"Vertica is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"I have found the solution to be scalable."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"Initiate on one node, and the RPM propagates automatically to all other nodes. ​"
 

Cons

"Security is a concern. MySQL could have better security features."
"The replication needs improvement. It's becoming a native cloud product like Oracle DB or Cockroach DB."
"The data masking functionality should be improved as well as the native encryption functionality in the MySQL database."
"Improvements are required in character set support, scalability, and big data sets."
"​MySQL needs improvements on its diagnostic features.​"
"It isn't as reliable as an SQL Server."
"In an upcoming release, there should be something added similar to EPL. For example, when using the flow diagram, we can create a schema. We have two useful features to add or create the table, but there should be some UI features to allow us to drag and drop to create other schemas. This would be very helpful."
"The availability of tools could be improved in the MySQL open-source platform. They can provide more analytical tools. I haven't had any particularly difficult issues to troubleshoot on MySQL, but in the past, on Microsoft SQL Server, I had to troubleshoot some difficult issues, and better tools were in place to see what was going on in real-time on the server. So, that's the bit that is lacking on the MySQL open-source platform."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"It would be great if this were a managed service in AWS."
"It's hard to make it slow for a small data volume. For large volumes, it's hard to make it work. It's also hard to make it faster, and to make it scale."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases."
"They could improve on customer service."
 

Pricing and Cost Advice

"It's free."
"It has a community version."
"MySQL is very cheap. It could be free. It also has a yearly licensing option."
"The tool is open source."
"My company uses MySQL's corporate licenses."
"There is not a license required for this solution."
"There is no cost involved, no licensing fees."
"We are using the free community version of the solution."
"Vertica is an expensive tool."
"Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."
"The pricing and licensing depend on the size of your environment and the zone where you want to implement."
"The pricing could improve, it is a little expensive."
"The solution is free and we pay for the storage."
"The first TB is free and you can use all the Vertica features. After 1TB you have to pay for licensing. The product is worth it, but be aware of this condition, and plan. The compression ratio is explained in the documentation."
"The pricing for this solution is very reasonable compared to other vendors."
"I think it's starting to get a little expensive. Open source products are starting to get more robust, so I think that's something that they need to start looking at in terms of licensing."
report
Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
842,592 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
16%
Financial Services Firm
12%
Manufacturing Company
7%
Government
6%
Financial Services Firm
19%
Computer Software Company
18%
Manufacturing Company
8%
University
4%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Why are MySQL connections encrypted and what is the biggest benefit of this?
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, m...
Considering that there is a free version of MySQL, would you invest in one of the paid editions?
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 sim...
What is one thing you would improve with MySQL?
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 onli...
What do you like most about Vertica?
Vertica is easy to use and provides really high performance, stability, and scalability.
What is your experience regarding pricing and costs for Vertica?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
What needs improvement with Vertica?
The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases.
 

Comparisons

 

Also Known As

No data available
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Overview

 

Sample Customers

Facebook, Tumblr, Scholastic, MTV Networks, Wikipedia, Verizon Wireless, Sage Group, Glassfish Open Message Queue, and RightNow Technologies.
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about Oracle, PostgreSQL, Firebird and others in Open Source Databases. Updated: March 2025.
842,592 professionals have used our research since 2012.