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."MariaDB performs well as the backend database for our cloud-based telephony solution."
"The solution runs very quickly. It's not slow at all."
"The performance is very good."
"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 product has been stable and reliable."
"Great monitoring and performance stability."
"The most valuable feature is that it uses multiple cores, which is better than some of the other databases."
"The solution has PL/SQL compatibility."
"Partition and join back to node are easy and simple for DBAs."
"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."
"Allows us to take volumes and process them at a very high speed."
"The performance is very good and the aggregate records are fast."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"The solution is quick, has good compression data, and is not expensive."
"The feature of the product that is most important is the speed. I needed a columnar database, and its speed is what it's built to do, and so that's what really does differentiate Vertica from its competitors."
"It maximize cloud economics for mission-critical big data analytical initiatives."
"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."
"Integration with AWS could be improved."
"MariaDB can improve by adding more features. There are a lot of features, which are available in Oracle, and which are not available in MariaDB. We hope they will introduce the features soon."
"Master-master replication is something that needs to be simplified."
"The customer service and support are okay. But the response time is slow. Moreover, the material is not available freely."
"The stability could always continue to be improved upon."
"It should work across all fields like SQLite, as it is the basis of any application, even apps for phones and the like."
"I am editing."
"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."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"Suboptimal projection design causes queries to not scale linearly."
"They could improve on customer service."
"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."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"Documentation has become much better, but can always use some improvement."
"It needs integration with multiple clouds."
MariaDB is ranked 3rd in Open Source Databases with 51 reviews while Vertica is ranked 4th in Data Warehouse with 83 reviews. MariaDB is rated 8.2, while Vertica is rated 8.2. 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.