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

"Installation is straightforward."
"MariaDB performs well as the backend database for our cloud-based telephony solution."
"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."
"The solution is very stable. It was originally built under MySQL. It has a similar level of stability."
"It delivers fast processing times, particularly for frequent select queries and insert/update operations."
"MariaDB is a fast and flexible tool."
"I like the global transaction IDs (GTIDs) feature. It's quite reliable for replication between a master and a replica server, and it's a feature that MySQL also has but implemented differently."
"It's easy to set up."
"Partition and join back to node are easy and simple for DBAs."
"The extensibility and efficiency provided by their C++ SDK."
"It has improved my organization's functionality and performance."
"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."
"The most valuable feature is Vertica's performance and the ease of using the database."
"We are also opening new areas of business and potential new revenue streams using Vertica's analytic functions, most notably geospatial, where we are able to run billions of comparisons of lat/long point locations against polygon and point/radius locations in seconds. ​"
"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."
"It maximize cloud economics for mission-critical big data analytical initiatives."
 

Cons

"In the next release, I would like to see improvements in the scalability and redundancy features."
"MariaDB should provide HA and archive logging... I haven't had the opportunity to use the features provided by the solution since I don't know how to see them."
"I would like to see more compatibility going forward. This would help if there is a need to change databases."
"The difficult part related to the product stems not from the tool itself but is related to learning how to implement the product in the right way without creating any wrong configuration that could cause security issues or performance issues."
"With respect to clustering and the master-slave configuration, sometimes the slave goes out of synch."
"It does not have tools for debugging procedures and functions."
"The solution can improve by having support for more integration. However, at this time it is working well for us."
"When we have had issues with accidental computer shutdown or a power outage, our MariaDB database was corrupted."
"The geospatial functionality could be designed better."
"The integration of this solution with ODI could be improved."
"It would be great if this were a managed service in AWS."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"I believe the installation process could be streamlined."
"In our company, we have faced difficulties in scaling the solution for certain use cases."
"The integration with AI has room for improvement."
"We faced some challenges when trying to use the temporary tables feature."
 

Pricing and Cost Advice

"I rate the product's price a three on a scale of one to ten, where one is low price, and ten is high price since there are some support costs involved, even though it isn't an open-source solution."
"MariaDB is open-source and self-hosted."
"This is an open-source product, which can be used free of charge."
"MariaDB is a free-to-use solution."
"The price of this solution represents a very good compromise between the cost and what it offers."
"It is an open-source solution."
"The product is not expensive."
"The cost is quite good. You can have the open source, free version, which has adequate capacity."
"The price of Vertica is less expensive than some competitors, such as Teradata."
"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 price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."
"Start with license per 1TB. Starting from hundreds of TB there is unlimited licensing to be considered. Move historical data to HDFS/S3 which are significantly cheaper or even free."
"Work with a vendor, if possible, and take advantage of more aggressive discounts at mid-fiscal year (April) and fiscal year-end (October).​"
"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 has a perpetual license, but they are currently trying to convert all those licenses to subscription-based licenses on a yearly basis."
"It is fast to purchase through the AWS Marketplace."
report
Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
849,190 professionals have used our research since 2012.
 

Top Industries

By visitors reading reviews
Computer Software Company
17%
Financial Services Firm
11%
Educational Organization
9%
Comms Service Provider
8%
Financial Services Firm
19%
Computer Software Company
18%
Manufacturing Company
7%
University
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: April 2025.
849,190 professionals have used our research since 2012.