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.
"I like the simplistic view of MySQL to build custom queries and things like that as compared to SQL Server, which seems more cluttered. SQL Server has a query analyzer. MySQL pretty much does the same, and performance-wise, it has less overhead for connecting to our ERP system. It seems more responsive and cleaner. With MySQL, you get what you need without any overbloating, for which Microsoft is known. That's why they have so many constant security patches for everything because there is so much stuff, which degrades performance."
"The feature I found most valuable is activity performance."
"It has a lot of features. The RDBMS, consistency, and multi-user features are valuable."
"For sure, the solution is very stable."
"We are completely comfortable with the database’s performance and it is a mature product. My organization was looking for an open-source database for our smaller customers like the community edition. For bigger customers, we can scale into commercial and supported editions."
"The solution is free to use, which is its most valuable aspect."
"The most valuable feature of MySQL is its reliability and performance."
"MySQL is a popular database platform for businesses because it is extremely easy to use."
"The most valuable features are the large volume of data and the structuring of the data to optimize it and get very optimal data warehouse solutions for customers."
"A conventional and easily defined way to build a data warehouse or a layer of data marts."
"I've never had any issues with scalability."
"Teradata features high productivity and reliability because it has several redundancy options, so the system is always up and running."
"Viewpoint, the detailed query logs and performance statistics are valuable features."
"Teradata can be easily used in ETL mode transformations, so there is no need for expensive and inconvenient ETL tools"
"Teradata's pretty fast."
"The initial setup was straightforward."
"There should be more tools to manage the on-premises version and more automation features."
"When I run into issues, I really have to research how to fix them."
"The solution is expensive."
"The solution could improve by having better performance and security."
"I would like to see the automatic backup feature in the solution as well. Data is very important and we need to preserve it in a safe place. It would be good if MySQL can back up the data automatically."
"Some problems with big table operations, and a struggle to keep the servers responding in peak situations."
"This solution needs to be improved when it comes to working with desktop applications on the developer side."
"Sometimes, not because the version is not the latest version, there are some issues with it. Sometimes there's an issue with the server which creates issues with it."
"I would like to see an improved Knowledge Base on the web."
"There is some improvement required on OLTP level and some analytical function is missing."
"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."
"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."
"The setup is not straightforward."
"The increasing volumes of data demand more and more performance."
"Teradata's UI could be improved."
"The following could be better: licensing, architecture openness, integration with other tools."
MySQL is ranked 4th in Relational Databases Tools with 24 reviews while Teradata is ranked 7th in Relational Databases Tools with 21 reviews. MySQL is rated 8.2, while Teradata is rated 8.4. The top reviewer of MySQL writes "A tool that offers an easy setup phase along with exceptional stability". On the other hand, the top reviewer of Teradata writes "Very fast with good database control and excellent support". MySQL is most compared with Firebird SQL, PostgreSQL, MariaDB, SQL Server and Oracle Database, 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.