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 is very easy to install and has all basic database features."
"SKIP LOCKED is a valuable feature."
"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."
"It creates a unified view of the entire architecture and performance factor, helping to manage the network more easily."
"The feature I found most valuable is activity performance."
"It is a scalable solution."
"I like MySQL's feature that helps to automate things."
"It's a good tool, a good database platform."
"I like the projection feature, which increases query performance."
"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."
"Its analytics has enabled Pythian's clients to get the business insights as quick as they wanted. Its lower maintenance has also improved the ROI."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"Allows us to take volumes and process them at a very high speed."
"The Vertica architecture means it can process/ingest data in parallel to reporting and analyzing because of its in-memory Write-Optimized Storage sitting alongside the analytics optimized Read-Optimized Storage."
"I enjoy the cybersecurity and backup features."
"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 GUI could improve in MySQL."
"When it comes to supporting big data, there is space to improve upon the database engines that are supported by MySQL."
"MySQL needs improvements on its diagnostic features."
"I would like to have the ability to cancel a query in SQL Developer."
"MySQL doesn't have the auto-clustering and database clustering features that other competitors provide. They can include these features."
"I would like to see more integrations of the solution with other platforms and improve the support on different data types."
"The workbench could be improved. In particular, error messages can be improved, which are horrific and completely unhelpful. I'd like to see improved parsing of errors. When you write SQL and it crashes, it usually is something completely irrelevant and not helpful. I've started to use GPT 3.5 for finding out how to do things. I got to do something a bit different, and that I found to be very useful. If there was some way to tie it into one of the new AI tools, that would probably be a good idea."
"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."
"The integration with AI has room for improvement."
"I think they need an easy client so that you can write queries easily, but it's not necessarily a weak point. I think some users would need them."
"Suboptimal projection design causes queries to not scale linearly."
"I believe the installation process could be streamlined."
"Whatever's out, the core is not always as great as the engine, especially their first version."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"I have found that coding support could be simplified."
MySQL is ranked 1st in Open Source Databases with 142 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. MySQL is rated 8.2, while Vertica is rated 8.2. 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.