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 like the easy way that we can collect data from other databases."
"The solution is very stable. It was originally built under MySQL. It has a similar level of stability."
"The most valuable feature of MariaDB is the replication mode."
"The most valuable features of the solution stem from the fact that it is a cloud-based tool, so it is pretty fast."
"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."
"The stability of MariaDB is good, it has high availability."
"The most valuable feature of the solution is a relational database, which is fairly reliable...It is a stable solution."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"The extensibility and efficiency provided by their C++ SDK."
"I have found the solution to be scalable."
"I appreciate the flexibility offered by Vertica's projections. It allows for modifying the primary projection without altering the tables, which helps to optimize queries without the need to modify the underlying data."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"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 performance is very good and the aggregate records are fast."
"Initiate on one node, and the RPM propagates automatically to all other nodes. "
"It's not very stable. It needs improvement."
"An improvement would be scaling it up to the levels of Oracle, especially when it comes to resilience, so that we can do higher transactions for two databases or power our operation."
"MariaDB could improve by adding support for non-relational structures and new data types."
"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."
"MariaDB could be improved by adding more automation."
"Data continuity could be improved."
"The GUI could be improved a bit. The user interface needs to be improved."
"The biggest problem is the cost of cloud deployment."
"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."
"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."
"When it is about to reach the maximum storage capacity, it becomes slow."
"The integration with AI has room for improvement."
"I believe the installation process could be streamlined."
"Fact-to-fact joins on multi-billion record tables perform poorly."
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.