We performed a comparison between MySQL and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, PostgreSQL, Firebird and others in Open Source Databases."MySQL is easy to integrate. It works with just about every language."
"The replication feature is the most valuable. We are replicating our servers."
"The main advantage is the very large user base. This enables users to fix about any issue by answering any question."
"MySQL is a popular database platform for businesses because it is extremely easy to use."
"The solution has been very easy to scale so far."
"The most valuable feature of MySQL is auto-scaling."
"Fully scalable and stable SQL-based RDBMS, with a straightforward and easy setup."
"The solution is very simple. It's easy to use. That's the most important feature."
"The extensibility and efficiency provided by their C++ SDK."
"Bulk loads, batch loads, and micro-batch loads have made it possible for our organization to process near real-time ingestions and faster analytics."
"The performance is very good and the aggregate records are fast."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"The solution is quick, has good compression data, and is not expensive."
"Partition and join back to node are easy and simple for DBAs."
"Vertica is easy to use and provides really high performance, stability, and scalability."
"We are able to integrate our Vertica data warehouse with Tableau to create numerous reports quickly and efficiently."
"I am looking for the Temporal SQL feature, which basically means that there is complete history for each table. This feature is currently available in MariaDB. PostgreSQL has something called a foreign-data wrapper, which is another way to access external data from inside. MySQL could have a similar feature."
"The solution could improve the monitoring. At the present time, you need to use third-party monitoring solutions."
"Improvements to MySQL depend on the specific use case. For example, in my scenario, I frequently need to maintain and store data, which can then be utilized to generate reports. On the other hand, others may suggest incorporating a feature that allows for easier visualization of the data, such as what is available in Power BI or other similar tools."
"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."
"It could be a little bit simpler to use."
"The tool needs to improve table visualization."
"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."
"Scalability could be improved."
"Support is an area where it could get better."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"The geospatial functionality could be designed better."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"Vertica's native cloud support could be improved, and its installation could be made easier."
"When it is about to reach the maximum storage capacity, it becomes slow."
"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."
"They could improve on customer service."
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 Amazon Aurora, 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.