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."I rate the solution's stability a ten out of ten since it has been running flawlessly."
"I like MySQL because of its community."
"Setup is easy. MySQL of various flavours has community editions to easily test, deploy, and run."
"It creates a unified view of the entire architecture and performance factor, helping to manage the network more easily."
"The most valuable feature is the ease of use."
"It is free, which is probably its most valuable feature. It is a pretty full-featured relational database. It really does everything we need it to do."
"The deployment process is pretty fast."
"The installation process for the most scalable solution is remarkably quick, taking only a short amount of time."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"The performance is very good and the aggregate records are fast."
"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."
"Allows us to take volumes and process them at a very high speed."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"Vertica has a few features that I like. From an architecture standpoint, they have separated compute and storage. So you have low-cost object storage for primary storage and the ability to have several sub-clusters working off the same ObjectStore. So it provides workload isolation."
"The extensibility and efficiency provided by their C++ SDK."
"I like the projection feature, which increases query performance."
"I feel that some tools which make it easier to create queries or make it easier for other functions would be really interesting to see."
"Clusters are hard to perform so we use no SQL alternates like MongoDB."
"It can have better monitoring. In addition, the enterprise manager should be able to cater to more than one virtual machine. Currently, you need one license per server. It seems a bit too much to get one license for one enterprise manager. I hope the enterprise manager for MySQL can accommodate more virtual machines for MySQL."
"The backup methods need improvement."
"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."
"I would like to have features that allow us to jump between the cloud and our on-premises system."
"I would like to see more integrations of the solution with other platforms and improve the support on different data types."
"There are some issues with compatibility with Java environments that need to be improved. When Oracle bought this solution there were some driver changes that caused some issues with operations."
"The biggest problem is the cost of cloud deployment."
"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."
"The integration with AI has room for improvement."
"I believe the installation process could be streamlined."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"I have found that coding support could be simplified."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"Documentation has become much better, but can always use some improvement."
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 LocalDB, 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.