We performed a comparison between MariaDB and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, PostgreSQL, MariaDB and others in Open Source Databases."Easy to use and available in most environments."
"We use MariaDB for identity provider services. Most of the things that we are doing are deployed in the container mode. All such solutions require a database, and MariaDB is easier to use for these kinds of deployments."
"The most valuable feature of the solution is a relational database, which is fairly reliable...It is a stable solution."
"The solution is very stable. It was originally built under MySQL. It has a similar level of stability."
"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."
"MariaDB is easy to install and is stable and scalable."
"There is the need for a robust IDE for MongoDB. The existing PHP admin console doesn't meet the client's requirements effectively."
"Great monitoring and performance stability."
"I like the projection feature, which increases query performance."
"For me, It's performance, scalability, low cost, and it's integrated into enterprise and big data environments."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"Eighty percent of the ETL operations have improved since implementing this solution."
"The performance is very good and the aggregate records are fast."
"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."
"The solution is quick, has good compression data, and is not expensive."
"MariaDB's GUI is an area with certain shortcomings where improvements are required."
"The product needs more features and more functionality. It's imperative that it supports more platforms, and supports more operating systems."
"The solution should do some fine-tuning on maybe the transaction per second so that users can get more than they can on the Microsoft SQL Server."
"It should work across all fields like SQLite, as it is the basis of any application, even apps for phones and the like."
"One feedback I can quickly provide is the need for a robust IDE for MongoDB. The existing PHP admin console doesn't meet the client's requirements effectively."
"Integration with AWS could be improved."
"The GUI could be improved a bit. The user interface needs to be improved."
"It's not very stable. It needs improvement."
"They could improve the integration and some of the features in the cloud version."
"It would be great if this were a managed service in AWS."
"Promotion/marketing must be improved, even though it is a very useful product at very good price, it is not as "popular" as it should be."
"Fact-to-fact joins on multi-billion record tables perform poorly."
"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."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"I have found that coding support could be simplified."
"We faced some challenges when trying to use the temporary tables feature."
MariaDB is ranked 3rd in Open Source Databases with 51 reviews while Vertica is ranked 4th in Data Warehouse with 82 reviews. MariaDB is rated 8.2, while Vertica is rated 8.4. The top reviewer of MariaDB writes "Simultaneously use active server capabilities but lacks the maturity ". 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, PostgreSQL and Firebird SQL, 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.