Try our new research platform with insights from 80,000+ expert users

MariaDB vs Vertica comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Categories and Ranking

MariaDB
Average Rating
8.2
Reviews Sentiment
7.1
Number of Reviews
59
Ranking in other categories
Open Source Databases (4th), Relational Databases Tools (5th)
Vertica
Average Rating
8.2
Reviews Sentiment
7.0
Number of Reviews
86
Ranking in other categories
Data Warehouse (5th), Cloud Data Warehouse (11th)
 

Mindshare comparison

MariaDB and Vertica aren’t in the same category and serve different purposes. MariaDB is designed for Open Source Databases and holds a mindshare of 6.5%, down 12.5% compared to last year.
Vertica, on the other hand, focuses on Data Warehouse, holds 8.6% mindshare, down 8.7% since last year.
Open Source Databases
Data Warehouse
 

Featured Reviews

KumarManish - PeerSpot reviewer
Easy to deploy, cost-effective, and integrates seamlessly with other products
We had planned for an RDBMS version and not NoSQL. We use MariaDB Galera Cluster. It's a good product. It is cheap, scalable, performs well, and is efficient. We use GCP’s BigQuery for machine learning. We must follow the best practices of the tool. We missed some best practices like the storage engine and InnoDB. It was very difficult to identify why we were having performance issues. Then, we realized that some of our tables were still on MyISAM, the default storage engine. When we switched it back to the InnoDB, it was very smooth. InnoDB is the recommended one. We must follow the best practices given in the documentation during the initial setup. Overall, I rate the product a nine out of ten.
T Venkatesh - PeerSpot reviewer
Processes query faster through multiple systems simultaneously, but it could support different data types
We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"The most valuable feature is that it uses multiple cores, which is better than some of the other databases."
"The most valuable feature of the solution is a relational database, which is fairly reliable...It is a stable solution."
"It's open source."
"Installation is straightforward."
"The solution runs very quickly. It's not slow at all."
"MariaDB has a straightforward initial setup with easy-to-understand documentation."
"We like the easy way that we can collect data from other databases."
"It is very simple to install, and the commands are exactly the same as MySQL."
"The feature I like best is performance. We use Red Tool and Red Job for the data warehouse and reporting. It's perfect. Performance is good, and it can return ad hoc queries very quickly. Of course, it's a cluster, so it's easy to scale."
"I have found the solution to be scalable."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"I like the projection feature, which increases query performance."
"It has improved my organization's functionality and performance."
"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."
"I enjoy the cybersecurity and backup features."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
 

Cons

"It would be good if they can maybe improve the mass import in the database. Currently, for importing a large number of data, we create a CSV file and upload all the things in the system. The system does not activate them by default. We have to do this manually. This may be due to the version we are using, but this is something we would like to see improved."
"Could have more integration with user platforms."
"It does not have tools for debugging procedures and functions."
"The dashboard and pricing need improvement."
"It's not very stable. It needs improvement."
"There is room for improvement in terms of security."
"The license should be cheaper and closer to that offered by MySQL, Oracle and other products."
"With respect to clustering and the master-slave configuration, sometimes the slave goes out of synch."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"The biggest problem is the cost of cloud deployment."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"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."
"They could improve on customer service."
"The documentation of Vertica is an area with shortcomings where improvements are required."
"One feature, which has really benefited us, is the scalability offered by Vertica as it has enabled Pythian's clients to manage data with agility."
 

Pricing and Cost Advice

"There is a monthly subscription to use MariaDB."
"The tool is open-source."
"The price could be less expensive."
"MariaDB is open-source and self-hosted."
"MariaDB is an open-source software, meaning I don't need to pay for the product."
"The price of this solution represents a very good compromise between the cost and what it offers."
"This is an open-source product, which can be used free of charge."
"It is free of charge."
"The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy."
"Vertica is an expensive tool."
"It's free up to three nodes and 1TB, and then get in contact with their sales guys."
"It is fast to purchase through the AWS Marketplace."
"The pricing for this solution is very reasonable compared to other vendors."
"Read the fine print carefully."
"It's an expensive product"
"From a cost perspective, the software is less than most of its competitors."
report
Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
844,944 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
17%
Financial Services Firm
11%
Manufacturing Company
8%
Educational Organization
8%
Financial Services Firm
20%
Computer Software Company
18%
Manufacturing Company
8%
Real Estate/Law Firm
4%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

What do you like most about MariaDB?
The integration with other products is seamless.
What is your experience regarding pricing and costs for MariaDB?
I have found the price of commercial MariaDB to be pretty steep, although not as high as Oracle. Customers often prefer the Community Edition because it's free.
What needs improvement with MariaDB?
The only potential area for improvement could be the pricing model, which might benefit from being more flexible or a bit cheaper.
What do you like most about Vertica?
Vertica is easy to use and provides really high performance, stability, and scalability.
What is your experience regarding pricing and costs for Vertica?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
What needs improvement with Vertica?
The product could improve by adding support for a wider variety of data types and enhancing features to better compete with other databases.
 

Comparisons

 

Also Known As

No data available
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Overview

 

Sample Customers

Google, Wikipedia, Tencent, Verizon, DBS Bank, Deutsche Bank, Telefónica, Huatai Securities
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about Oracle, PostgreSQL, Firebird and others in Open Source Databases. Updated: March 2025.
844,944 professionals have used our research since 2012.