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."SKIP LOCKED is a valuable feature."
"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."
"MySQL is easy to integrate. It works with just about every language."
"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."
"It was easy to install."
"We are completely comfortable with the database’s performance and it is a mature product. My organization was looking for an open-source database for our smaller customers like the community edition. For bigger customers, we can scale into commercial and supported editions."
"We use the basic features of MySQL. The interface that allows us to see the parameters of the server is good."
"The solution helps us perform with our databases and extract data."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"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."
"The product's initial setup phase is extremely simple."
"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."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"Its projections and encoding are excellent tools for tuning large volumes."
"Partition and join back to node are easy and simple for DBAs."
"The replication needs improvement. It's becoming a native cloud product like Oracle DB or Cockroach DB."
"It could be more secure."
"As an open-source product, there isn't really any technical support available if you get into trouble or have issues."
"While utilizing a comparable algorithm, is noted to be sensitive, especially when configuring the inner device."
"The user interface could be more user friendly. Mainly because most of the times we see black and white digital lines. Something like Python."
"Security is a concern. MySQL could have better security features."
"MySQL could introduce more indexing strategies."
"There should be more tools to manage the on-premises version and more automation features."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
"When it is about to reach the maximum storage capacity, it becomes slow."
"The biggest problem is the cost of cloud deployment."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"They could improve on customer service."
"We faced some challenges when trying to use the temporary tables feature."
"Vertica offers a platform-as-a-service version, but their software-as-a-service solution is only available on AWS. They need to get a SaaS version on Azure and GCP as fast as possible."
"They could improve the integration and some of the features in the cloud version."
MySQL is ranked 1st in Open Source Databases with 142 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.