We performed a comparison between MySQL and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, PostgreSQL, MariaDB and others in Open Source Databases."It creates a unified view of the entire architecture and performance factor, helping to manage the network more easily."
"Table partitioning is most valuable. It is easy to use."
"The feature that I have found most valuable is its ubiquity. MySQL is everywhere, so if I need to find a developer to do things to it that I don't know, it's very easy to find someone who has expertise in it."
"The installation process for the most scalable solution is remarkably quick, taking only a short amount of time."
"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."
"Setup is easy. MySQL of various flavours has community editions to easily test, deploy, and run."
"The fact that it is free is what appeals to me the most."
"The solution is very stable."
"Eighty percent of the ETL operations have improved since implementing this solution."
"The product's initial setup phase is extremely simple."
"I have found the solution to be scalable."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"Vertica is a great product because customers can compress and code data. The infrastructure that data warehouse solutions need is a commodity server so that customers don't have to invest in infrastructure."
"Integrated R and geospatial functions are helping us improve efficiency and explore new revenue streams. "
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"It isn't as reliable as an SQL Server."
"The auto-tuning and NDB cluster has some limitations regarding foreign keys."
"They should come up with a better solution than the NDB cluster for better scaling. If they could come up with a better solution for write scaling, apart from the NDB cluster, which is supported by all open source communities, that would be great. Although the NDB cluster, I believe, is an open-source tool, it's not widely supported as a solution."
"It is not as powerful as SQL Server. It can be more powerful. It is not scalable and has certain limitations, which is not the case with SQL Server."
"The solution could improve by having better performance and security."
"Oracle should start putting in some of the enterprise features in the standard feature. There are some key features that should be part of the standard."
"The licensing cost of the solution is expensive, which MySQL needs to consider improving."
"I would rate the stability a seven out of ten. It does break down a little at times."
"Vertica seems to scale well, except for one use case where you are on a multi-node cluster. For example, if you had a nine-node cluster, one node goes down, then the eight nodes don't scale, because the absence of the node is very apparent, which is a problem. If you have nine nodes or multiple nodes, the whole idea is that if one of those nodes goes down, then you should not see an impact on the system if you have enough capacity. Even though we have enough capacity, you can still see the impact of the one node going down."
"In my opinion, Vertica's documentation could be improved. Currently, there is not enough documentation available to gain a comprehensive understanding of the platform."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"Documentation has become much better, but can always use some improvement."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"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."
MySQL is ranked 1st in Open Source Databases with 141 reviews while Vertica is ranked 4th in Data Warehouse with 82 reviews. MySQL is rated 8.2, while Vertica is rated 8.4. The top reviewer of MySQL writes "Good beginner base but it should have better support for backups". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". MySQL is most compared with Firebird SQL, PostgreSQL, MariaDB, Teradata and SQLite, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and SAP HANA.
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.