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."The solution's high availability is its most valuable aspect."
"It's easy to set up."
"One of the great features of MariaDB is its scalability. It's easy to handle even with large databases."
"Easy to use and available in most environments."
"MariaDB can solve things better than MySQL. Maria DB has better performance than MySQL."
"The most valuable feature of MariaDB is that it is open-source and we can easily migrate from other databases, such as Oracle to MariaDB."
"It is an absolutely stable solution."
"MariaDB is a user-friendly solution. Performance wise, it's better than SQL. With SQL, I would need to write a number of queries. In contrast, MariaDB is light."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
"I enjoy the cybersecurity and backup features."
"I like the projection feature, which increases query performance."
"Eighty percent of the ETL operations have improved since implementing this solution."
"The extensibility and efficiency provided by their C++ SDK."
"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."
"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 is a columnar database where the query performance is extremely fast and it can be used for real-time integrations for API and other applications. The solution requires zero maintenance which is helpful."
"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."
"The GUI could be improved a bit. The user interface needs to be improved."
"Replication could be better, and it's not so simple. It would be better if they had a replication server. It would make things a lot easier. You need to have that replication server, but not in the same server farm. Then there will be a bit of latency between both because you should have one in one city and another one in a different city. That kind of solution should be more baked into every single database today. Mirroring the database in a live environment where any record written on the production server replicates instantly across the fiber on the other server wasn't easy. Many people don't even bother with that, and they just run one server."
"Could have more integration with user platforms."
"It should work across all fields like SQLite, as it is the basis of any application, even apps for phones and the like."
"In future releases, mainly the addition of security features would be beneficial for MariaDB."
"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."
"I would like to see a better user interface which would make the tool less complex."
"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."
"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."
"It should provide a GUI interface for data management and tuning."
"They could improve on customer service."
"The geospatial functionality could be designed better."
"It needs integration with multiple clouds."
"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."
"We faced some challenges when trying to use the temporary tables feature."
MariaDB is ranked 3rd in Open Source Databases with 30 reviews while Vertica is ranked 4th in Data Warehouse with 10 reviews. MariaDB is rated 8.0, while Vertica is rated 8.4. The top reviewer of MariaDB writes "Allows for fetching data from multiple correlated or related databases in a single query, user-friendly and easy to handle". On the other hand, the top reviewer of Vertica writes "Reliable and feature-rich, with optimization techniques to fine-tune queries for faster report generation". MariaDB is most compared with SQL Server, PostgreSQL, Oracle Database, MySQL 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.