We compared Teradata and MySQL based on our user's reviews in several parameters.
Teradata stands out for its powerful analytics, scalability, and security features, while users appreciate its thorough customer support. On the other hand, MySQL is praised for its efficiency in managing data, user-friendly interface, and strong performance. While both have positive ROI, Teradata requires improvements in speed and user interface, while MySQL needs enhancements in performance optimization and documentation.
Features: Teradata's valuable features include powerful analytics, scalability, efficient data management, reliable performance, robust security, easy integration, user-friendly interface, and extensive support. MySQL, on the other hand, boasts efficient data handling, strong performance, compatibility, ease of use, flexibility, and robust security measures.
Pricing and ROI: The setup cost for Teradata is mentioned to be minimal, allowing for a smooth implementation process. On the other hand, MySQL is praised for its affordable setup cost. Both products offer flexible pricing and licensing options to cater to different business needs., Teradata's ROI is significant, with users benefiting from improved data management and informed decision-making. MySQL also has a positive ROI, praised for its reliability, cost-effectiveness, scalability, and community support.
Room for Improvement: Teradata product has room for improvement in areas such as performance, user interface, workflow, and support resources. In comparison, MySQL needs enhancements in performance, documentation, support, scalability, compatibility, and security features.
Deployment and customer support: User reviews for Teradata indicate varying experiences and time requirements for the deployment, setup, or implementation phases. In contrast, with MySQL, some users reported several months for deployment and an additional week for setup, while others mentioned both processes taking only a week in total., Teradata's customer service focuses on addressing needs and resolving issues, while MySQL's support team is praised for their prompt, helpful, and knowledgeable assistance, offering efficient solutions with clear and effective communication.
The summary above is based on 45 interviews we conducted recently with Teradata and MySQL users. To access the review's full transcripts, download our report.
"MySQL's most significant attribute is its capability to create, modify, and maintain databases. This is crucial and advantageous in procedures, such as SOAR. Therefore, all SQL functions are beneficial to any backend developer or developer who requires data storage."
"MySQL is an open-source product and has good community support. If you encounter any problem, you can easily ask other members of the community to help. They help you a lot. On top of being free, MySQL is a cross-platform database, meaning it can work on both Windows and Linux. It is very good for us."
"It is easy to use."
"MySQL is easy and convenient for me. I don't need to rely on anyone. I can write the code and extract the information. It is fast if you know how to use it. The solution is not expensive, and most of the developers know how to use it. It is easy to create tables. The solution is stable and has good performance. The connection with AWS gives regular updates, which is manual otherwise and a nightmare."
"The initial setup is easy."
"MySQL gives us all of the critical features that we need in a database, but without the costs."
"One of the most valuable features is MySQL's ability to run our email system. We use a system called Colab."
"The one interesting thing about this product is that it is open source. It comes from an open source product. MySQL has been positioned as open source, but it also provides support."
"The feature that we find most valuable is its ability to perform Massive Parallel Processing."
"It has given our business the ability to gain insights into the data and create data labs for analysis and PoCs."
"It's a pre-configured appliance that requires very little in terms of setting-up."
"Teradata's most valuable feature is that it's easy to use."
"It is a stable program."
"Building a data warehouse with Teradata has definitely helped a lot of our downstream applications to more easily access information."
"Things have started moving faster in my company, such as data retrieval happens more quickly."
"Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running."
"We require more ease of use, scalability, and high availability. These are some of the critical features that we use and look for in a product. It should be easier to manage clusters. Scalability is very important for us because our projects and concurrency requirements are quite big. We also require high availability of the server, application, and other things. It should also have more performance-based features or enhancements from the performance point of view. When we divide a database, it should be able to handle the queries very fast."
"The manuals or documentation could be better."
"The GUI interface probably can be improved. Let us say I want to see the relationships in the database. In the query analyzer, I would like to go and drop the tables and create relationships between the tables. I haven't found a feature like that in MySQL. It was a shortcoming even in SQL Server. MySQL can have more performance monitoring tools. I know Google has these tools, but within MySQL, there are not that many tools to monitor things like performance and database locking. They might be in there, and I might not be familiar enough to know where they are. I am a pretty new user of MySQL."
"The user interface could be more user friendly. Mainly because most of the times we see black and white digital lines. Something like Python."
"I did the implementation of the solution myself and I used community support. The support from the vendor costs money."
"It does not stand out regarding scalability. When the company size increases, the user base having actual experience with (very) large MySQL solutions is reduced."
"The solution could have better integration and security features."
"It isn't as reliable as an SQL Server."
"I think the UI is not there yet. It could be improved by being more user-friendly."
"Teradata's UI could be more user-friendly."
"Since I was working on the very basic, legacy systems, the memory thing was always a challenge. If Teradata is moving to the cloud, the space constraint or the memory issue that my company generally faces will eventually resolve, in time. What I'd like to see in the next release of Teradata is that it becomes full-fledged on the cloud, apart from better connectivity to various systems. For example, if I have to read or include a Python script, if I write some basic codes, I should be able to read even unstructured data. I know that it's not supported even in Snowflake, but at least semi-structured data support, if that can be a little more enhanced, that would be good."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"Apart from Control-M, it would be nice if it could integrate with other tools."
"Teradata could improve by being less complicated. There are some aspects that are not available on the Unix server and a Unix system is required to access some data, such as in case of an emergency."
"Limited interest and success in some areas make us hesitate about upgrading."
"I would like to see more integration with many different types of data."
MySQL is ranked 4th in Relational Databases Tools with 142 reviews while Teradata is ranked 7th in Relational Databases Tools with 54 reviews. MySQL is rated 8.2, while Teradata is rated 8.2. The top reviewer of MySQL writes "Good beginner base but it should have better support for backups". On the other hand, the top reviewer of Teradata writes "Offers seamless integration capabilities and performance optimization features, including extensive indexing and advanced tuning capabilities". MySQL is most compared with Firebird SQL, PostgreSQL, MariaDB, SAP HANA and SQL Server, whereas Teradata is most compared with SQL Server, Snowflake, Oracle Exadata, BigQuery and Amazon Redshift. See our MySQL vs. Teradata report.
See our list of best Relational Databases Tools vendors.
We monitor all Relational Databases Tools 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.