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

"It's a very easy product to set up."
"The documentation is quite straightforward."
"The most valuable feature of MariaDB is the replication mode."
"From the user's perspective, the performance of the columnar queries is very good in terms of the database when comparing it to the Oracle, and MySQL."
"I would say that for most use cases it works fine."
"I haven't faced any technical issues with the product, and it works fine."
"It is a stable solution."
"The solution's features have effectively met our operational requirements as a standard SQL database."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"The solution has great capabilities. The tool that instructs the internal database forward is easy to use and is very powerful."
"Vertica is a columnar database, this support our developments in analytics, advanced analytics, and ETL process with large sets of data."
"The extensibility and efficiency provided by their C++ SDK."
"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."
"Vertica uses advanced Azure technologies to compress raw data using indexing, allowing a large amount of data to be stored with minimal physical space. Advanced algorithms are employed in data compression."
"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."
"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."
 

Cons

"The ability to create stored procedures in MariaDB is an area where the tool lacks a bit."
"It's not very stable. It needs improvement."
"A well-known issue for a lot of different users is associated with write-intensive applications."
"The maintenance and performance could be a bit better."
"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."
"It would be helpful if I could specify multiple drives for the database storage."
"I would like to see a better user interface which would make the tool less complex."
"The solution can improve by having support for more integration. However, at this time it is working well for us."
"Limitations in group by projections is where I would like to see an improvement."
"Documentation has become much better, but can always use some improvement."
"Some of our small to medium-sized customers would like to see containerization and flexibility from the deployment standpoint."
"Performance of management of metadata layer (database catalog) needs improvement. We still have to have smaller customers on PostgreSQL; Vertica cannot manage thousands of schemata."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"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."
"They could improve on customer service."
 

Pricing and Cost Advice

"This is an open source solution with no licensing fees."
"We use the solution's free version."
"This is an open-source product, which can be used free of charge."
"When it comes to MariaDB, it should have a more cost-effective license."
"We pay for a yearly license."
"MariaDB is a free-to-use solution."
"MariaDB is open-source and self-hosted."
"The cost is quite good. You can have the open source, free version, which has adequate capacity."
"It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy."
"The first TB is free and you can use all the Vertica features. After 1TB you have to pay for licensing. The product is worth it, but be aware of this condition, and plan. The compression ratio is explained in the documentation."
"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."
"The solution is free and we pay for the storage."
"From a cost perspective, the software is less than most of its competitors."
"It's an expensive product"
"Read the fine print carefully."
"Vertica has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."
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.