Try our new research platform with insights from 80,000+ expert users

MySQL vs Teradata vs Vertica comparison

 

Comparison Buyer's Guide

Executive Summary

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Mindshare comparison

Open Source Databases
Data Warehouse
Data Warehouse
 

Featured Reviews

Muzzamil  Hussain - PeerSpot reviewer
Native encryption ensures secure data management with a simple deployment
The most valuable feature is the on-premises data encryption facilities. By default, we can provide encryption, and this feature in MySQL is why we prefer it over other databases. The native encryption in MySQL encourages us to use this database model more frequently compared to Oracle and other databases. With Oracle, we have to buy another solution for encryption and masking, but MySQL supports native encryption, which enhances our return on investment. It perfectly supports our ROI, and we have no issues with its functionality.
RajeshKumar25 - PeerSpot reviewer
Harnessing advanced parallelism for top performance while embracing cloud trends
Teradata is primarily used for data warehousing across all customers. My clients have built-in applications that use Teradata, and their use varies from customer to customer, depending on the industry and database size. The primary function is as an OLAP analytical ecosystem Scalability is…
T Venkatesh - PeerSpot reviewer
Processes query faster through multiple systems simultaneously, but it could support different data types
We use the solution for various tasks, including preparing data marts and generating offers. It helps extract data based on rules from the policy team and provides insights to enhance business operations. We also analyze transactions to target customers and improve business performance The…

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:
 

Pros

"It is very easy to install and has all basic database features."
"The solution is great for small applications in particular."
"MySQL is the best option for the Laravel PHP framework."
"MySQL solution is overall stable."
"What I've been most pleased with is the cost point, performance, and ease of use."
"The solution is very stable."
"This product is a good teaching tool for students who want to learn about networked databases."
"The initial setup for the SQL database is not complex and it even integrates into the platform. You set up the recipe and then just follow the runbook, the build book. Then it works as long as you follow the procedures."
"It's very mature from a technology perspective."
"The data mover is valuable over the last two years as it allows us to achieve data replication to our disaster recovery systems."
"IntelliFlex is easy to scale - one of its best features is that you can upscale it to the size you want."
"It has massive parallel processing ability to do large amounts of concurrent querying."
"It has given our business the ability to gain insights into the data and create data labs for analysis and PoCs."
"In Data Lab, you can schedule any testing you want to do in production. You can take a small subset of data from production, copy it there, and run all your tests. It reduces your testing costs because it's all in the lab."
"The product is reliable."
"It has increased the speed of reporting."
"The fast columnar store database structure allows our query times to be at least 10x faster than on any other database."
"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."
"DBAs don’t need to add a partition every month/quarter like with other DBs."
"The most valuable feature of Vertica is the unmatchable database performance."
"The solution was executed quite quickly due to its columnar storage underground, which is the most valuable feature of our company"
"Partition and join back to node are easy and simple for DBAs."
"I have found the solution to be scalable."
"Vertica enabled us to close large deals. Customers with large data sets had to be migrated from PostgreSQL to Vertica due to performance."
 

Cons

"Its scalability can be better. It is probably not as scalable as Oracle. I had some issues with connectors. I used it from a C++ program, and it required some work to make it run, but finally, it worked."
"This solution needs to be improved when it comes to working with desktop applications on the developer side."
"When it comes to supporting big data, there is space to improve upon the database engines that are supported by MySQL."
"The GUI could improve in MySQL."
"We want high availability and replication features, which are currently missing in this solution. It would be great if they can provide an in-built replication feature, similar to Oracle RAC, in MySQL."
"The data masking functionality should be improved as well as the native encryption functionality in the MySQL database."
"From a user perspective, the initial setup could be simplified a bit."
"Sometimes, I get lost in the toggles and buttons, and a better visual design would be nice. The layout is not user-friendly or efficient."
"Teradata can improve the way it handles big data and unstructured data."
"It needs a teaching web site with more training on third-party tools used for BI."
"Apart from Control-M, it would be nice if it could integrate with other tools."
"Teradata's UI could be improved."
"The solution could improve by having a cloud version or a cloud component. We have to use other solutions, such as Amazon AWS, Microsoft Azure, or Snowflake for the cloud."
"GUI of administrative tools is really outdated."
"There are some ways that the handling of unstructured data could be improved."
"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."
"I have found that coding support could be simplified."
"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."
"Vertica can improve automation and documentation. Additionally, the solution can be simplified."
"In a future release, we would like to have artificial intelligence capabilities like neural networks. Customers are demanding this type of analytics."
"The geospatial functionality could be designed better."
"Metadata for database files scale okay, but metadata related to tables/columns/sequences must be stored on all nodes."
"If you do not utilize the tuning tools like projections, encoding, partitions, and statistics, then performance and scalability will suffer."
"Support is an area where it could get better."
 

Pricing and Cost Advice

"The solution’s pricing depends on customer requirements. A license is not required for the community edition."
"MySQL is released under an open-source license, so you have nothing to pay to use it."
"I use the open-source free community version."
"MySQL is a cheap solution."
"The price of the solution is good because we have a good partner."
"It's cheaper than other solutions."
"I am using the Community Edition, which is available free of charge."
"It is an open source platform."
"The tool costs about 30,000 euros a month, while Azure Synapse SQL only costs 10,000."
"Teradata is not cheap, but you get what you pay for."
"In this day and age, we want to get things done quickly. So, we go to the AWS Marketplace."
"​When looking into implementing this product, pricing is the main issue followed by technical expertise​."
"The solution requires a license."
"Price is quite high, so if it is really possible to use other solutions (e.g. you do not have strict requirements for performance and huge data volumes), it might be better to look at alternatives from the RDBMS world."
"Teradata pricing is fine, and it's competitive with all the legacy models. On a scale of one to five, with one being the worst and five being the best, I'm giving Teradata a three, because it can be a little expensive, when compared to other solutions."
"The price of Teradata is expensive. However, what they deliver they are outstanding. If you're looking for an inexpensive solution to run a database, this isn't your tool. It's the Ferrari of databases for data warehousing."
"It is fast to purchase through the AWS Marketplace."
"The price of Vertica is less expensive than some competitors, such as Teradata."
"The solution is free and we pay for the storage."
"The pricing depends on the license model because there are several. It depends on the client, but it's cheaper than other solutions. I think it's cheap for all the functionality and robustness. It's not very expensive to deploy."
"It's difficult today to compete with open-source solutions. In these areas, there is a lot of competition and the price of this solution is a bit pricy."
"The pricing for this solution is very reasonable compared to other vendors."
"The price is reasonable. We use a pay per license model. Firstly, you need to buy a license. After that, you mainly pay the annual support fee of around 20% or 25%. I think their prices are quite reasonable."
"Vertica is an expensive tool."
report
Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.
854,618 professionals have used our research since 2012.
 

Comparison Review

it_user232068 - PeerSpot reviewer
Aug 5, 2015
Netezza vs. Teradata
Original published at https://www.linkedin.com/pulse/should-i-choose-net Two leading Massively Parallel Processing (MPP) architectures for Data Warehousing (DW) are IBM PureData System for Analytics (formerly Netezza) and Teradata. I thought talking about the similarities and differences…
 

Top Industries

By visitors reading reviews
Computer Software Company
16%
Financial Services Firm
11%
Manufacturing Company
7%
Government
6%
Financial Services Firm
27%
Computer Software Company
11%
Healthcare Company
7%
Manufacturing Company
7%
Financial Services Firm
19%
Computer Software Company
17%
Manufacturing Company
7%
University
4%
 

Company Size

By reviewers
Large Enterprise
Midsize Enterprise
Small Business
 

Questions from the Community

Why are MySQL connections encrypted and what is the biggest benefit of this?
MySQL encrypts connections to protect your data and the biggest benefit from this is that nobody can corrupt it. If y...
Considering that there is a free version of MySQL, would you invest in one of the paid editions?
I may be considered a MySQL veteran since I have been using it since before Oracle bought it and created paid version...
What is one thing you would improve with MySQL?
One thing I would improve related to MySQL is not within the product itself, but with the guides to it. Before, when ...
Comparing Teradata and Oracle Database, which product do you think is better and why?
I have spoken to my colleagues about this comparison and in our collective opinion, the reason why some people may d...
Which companies use Teradata and who is it most suitable for?
Before my organization implemented this solution, we researched which big brands were using Teradata, so we knew if ...
Is Teradata a difficult solution to work with?
Teradata is not a difficult product to work with, especially since they offer you technical support at all levels if ...
What do you like most about Vertica?
Vertica is easy to use and provides really high performance, stability, and scalability.
What is your experience regarding pricing and costs for Vertica?
The solution is relatively cost-effective. Pricing and licensing are reasonable compared to other solutions.
What needs improvement with Vertica?
The product could improve by adding support for a wider variety of data types and enhancing features to better compet...
 

Comparisons

 

Also Known As

No data available
IntelliFlex, Aster Data Map Reduce, , QueryGrid, Customer Interaction Manager, Digital Marketing Center, Data Mover, Data Stream Architecture
Micro Focus Vertica, HPE Vertica, HPE Vertica on Demand
 

Overview

 

Sample Customers

Facebook, Tumblr, Scholastic, MTV Networks, Wikipedia, Verizon Wireless, Sage Group, Glassfish Open Message Queue, and RightNow Technologies.
Netflix
Cerner, Game Show Network Game, Guess by Marciano, Supercell, Etsy, Nascar, Empirix, adMarketplace, and Cardlytics.
Find out what your peers are saying about Firebird, PostgreSQL, Oracle and others in Open Source Databases. Updated: May 2025.
854,618 professionals have used our research since 2012.