We performed a comparison between MariaDB 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."The most valuable feature of MariaDB is that it is open-source and we can easily migrate from other databases, such as Oracle to MariaDB."
"The solution's high availability is its most valuable aspect."
"Installation is straightforward."
"MariaDB is scalable."
"For non-production purposes. I'm just using it for my personal project, so it works quite well. I haven't faced any errors yet."
"Great monitoring and performance stability."
"The most valuable features of the solution stem from the fact that it is an open-source product and offers its users great online community support."
"I would say that for most use cases it works fine."
"Eighty percent of the ETL operations have improved since implementing this solution."
"The hardware usage and speed has been the most valuable feature of this solution. It is very fast and has saved us a lot of money."
"The most valuable feature of Vertica is the ability to receive large aggregations at a very quick pace. The use case of subclusters is very good."
"Any novice user can tune vertical queries with minimal training (or no training at all)."
"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."
"The most valuable feature is Vertica's performance and the ease of using the database."
"The solution is quick, has good compression data, and is not expensive."
"Allows us to take volumes and process them at a very high speed."
"The GUI could be improved a bit. The user interface needs to be improved."
"The interface should be more user-friendly. It should be able to connect directly to the database and Interact with it without having to use commands. It needs better integration."
"With respect to clustering and the master-slave configuration, sometimes the slave goes out of synch."
"It would be helpful if I could specify multiple drives for the database storage."
"Lacks time series data and additional driving support would be helpful."
"The dashboard and pricing need improvement."
"It's not very stable. It needs improvement."
"The PL/SQL performance is slow if you have big batch jobs running overnight."
"I have found that coding support could be simplified."
"Documentation has become much better, but can always use some improvement."
"It needs integration with multiple clouds."
"I would personally like to see extended developer tooling suited to Vertica – think published PowerDesigner SQL dialect support."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"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."
MariaDB is ranked 4th in Open Source Databases with 52 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. MariaDB is rated 8.2, while Vertica is rated 8.2. The top reviewer of MariaDB writes "Easy to deploy, cost-effective, and integrates seamlessly with other products". On the other hand, the top reviewer of Vertica writes " A user-friendly tool that needs to improve its documentation part". MariaDB is most compared with SQL Server, Oracle Database, Firebird SQL and PostgreSQL, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and Oracle Exadata.
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.