We performed a comparison between MariaDB and Vertica based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, PostgreSQL, Firebird and others in Open Source Databases."MariaDB is easy to install and is stable and scalable."
"The most valuable feature is that it uses multiple cores, which is better than some of the other databases."
"It is an absolutely stable solution."
"Easy to use and available in most environments."
"I am editing."
"The most valuable features of the solution stem from the fact that it is a cloud-based tool, so it is pretty fast."
"What I like best about MariaDB is that it is open-source and reliable."
"MariaDB has a straightforward initial setup with easy-to-understand documentation."
"Partition and join back to node are easy and simple for DBAs."
"I don't need any special hardware. I can use commodity hardware, which is nice to have in a commercial solution."
"I like the projection feature, which increases query performance."
"Allows us to take volumes and process them at a very high speed."
"I enjoy the cybersecurity and backup features."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"Vertica gives knowledgeable users and DBAs excellent tools for tuning."
"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 GUI could be improved a bit. The user interface needs to be improved."
"The performance could be a bit better."
"It does not have tools for debugging procedures and functions."
"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."
"I would like to see more compatibility going forward. This would help if there is a need to change databases."
"When we have had issues with accidental computer shutdown or a power outage, our MariaDB database was corrupted."
"The product needs more features and more functionality. It's imperative that it supports more platforms, and supports more operating systems."
"Data continuity could be improved."
"We are looking for a cheaper deployment for the solution. Although we did a lot of benchmarks, like Redshift. We tried Redshift, it didn't work. It didn't work out for us as well."
"When it is about to reach the maximum storage capacity, it becomes slow."
"Monitoring tools need to be lightweight. They should not take up heavy resources of the main server."
"The biggest problem is the cost of cloud deployment."
"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."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"There are a lot of limitations within this product and it makes things extremely hard for developers. It lacks Stored Procedure, packages, and triggers like other RDBMs."
MariaDB is ranked 4th in Open Source Databases with 52 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 "Easy to deploy, cost-effective, and integrates seamlessly with other products". 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, Firebird SQL and PostgreSQL, whereas Vertica is most compared with Snowflake, SQL Server, Amazon Redshift, Teradata and BigQuery.
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.