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.
"The IO segregation in CGE is valuable."
"The solution is very simple. It's easy to use. That's the most important feature."
"SKIP LOCKED is a valuable feature."
"The tool is open-source and there is no cost involved in its use."
"It was easy to install."
"Compared to other databases, MySQL is cheaper and we were using the community edition which was free of cost. ML is fully integrated with the database in HeatWave. It has also many other features. MySQL is a far better solution in terms of pricing."
"MySQL is easy to integrate. It works with just about every language."
"MySQL gives us all of the critical features that we need in a database, but without the costs."
"The feature that we find most valuable is its ability to perform Massive Parallel Processing."
"It is a stable program."
"When it comes to integration, tools like Informatica seamlessly connect with Teradata. We ensure the Teradata database is configured correctly in Informatica, including the proper hostname and properties for the load process. We didn't find any major complexity or issues with integration."
"Viewpoint, the detailed query logs and performance statistics are valuable features."
"It's very mature from a technology perspective."
"I've never had any issues with scalability."
"The performance is great, we are able to query our data in one operation."
"It has a solid set of tools and consulting services."
"It could be more secure."
"There should be an arrangement for end-users to get trained to use the tool...Improvement-wise, a graphical interface could be added for new users, eliminating the need to memorize the complex syntax."
"MySQL tutorials and guides could be improved. Often they are too complex for someone with no database experience to understand."
"I find the Microsoft solution a bit better. But mostly in terms of the UI layout, I would say. I just find it a little bit more efficient."
"The tool needs to improve table visualization."
"MySQL needs improvements on its diagnostic features."
"As an open-source product, there isn't really any technical support available if you get into trouble or have issues."
"It should provide better customer experiences."
"I would like to see more integration with many different types of data."
"The following could be better: licensing, architecture openness, integration with other tools."
"I'm not sure about the unstructured data management capabilities. It could be improved."
"The current operational approach needs improvement."
"An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly."
"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."
"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."
"Apart from Control-M, it would be nice if it could integrate with other tools."
MySQL is ranked 4th in Relational Databases Tools with 142 reviews while Teradata is ranked 7th in Relational Databases Tools with 55 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 IBM Db2 Database. 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.