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 most valuable features are that it's free and the documentation is good."
"MySQL is easy to use, has fast performance, and it is comfortable for end-user to use. The schema level and structure we are using are very simple and easy to understand. Additionally, packaging tool development is straightforward and the data is presented in a way that is very simple to understand."
"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."
"The most valuable feature of MySQL is the informative error outputs of command line interface."
"The solution is free to use, which is its most valuable aspect."
"The connectivity with PHP is quite good."
"This product is a good teaching tool for students who want to learn about networked databases."
"The solution is great for small applications in particular."
"The most valuable feature of Teradata is the quick processing of large data."
"It's the same as your visual database. I like the fast load feature for data, the BTQ solution is very good, and storage procedures are very fast."
"It's very mature from a technology perspective."
"The ability to handle machine data parallel processing is the most valuable feature of Teradata."
"Teradata can be easily used in ETL mode transformations, so there is no need for expensive and inconvenient ETL tools"
"It has given our business the ability to gain insights into the data and create data labs for analysis and PoCs."
"Teradata can be deployed on-premise, on the cloud, or in a virtual machine, which means customers can move without having to create their architecture all over again."
"Their extensive experience in data warehousing, the platform's performance, and their strong reputation in the market are the most valuable."
"Scalability could be improved."
"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."
"Since we upgraded from 8.0.12 to 8.0.22, it has had some slowness-related issues. Some of the queries that were fast previously are quite slow now. I did some research, and I found many people complaining about it."
"When I run into issues, I really have to research how to fix them."
"The workbench could be improved. In particular, error messages can be improved, which are horrific and completely unhelpful. I'd like to see improved parsing of errors. When you write SQL and it crashes, it usually is something completely irrelevant and not helpful. I've started to use GPT 3.5 for finding out how to do things. I got to do something a bit different, and that I found to be very useful. If there was some way to tie it into one of the new AI tools, that would probably be a good idea."
"We want to continue using MySQL but it merged with Oracle and the scalage changed."
"The user interface could be more user friendly. Mainly because most of the times we see black and white digital lines. Something like Python."
"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."
"It's primarily designed for big projects and therefore, the pricing is pretty high. It's not suitable for smaller companies."
"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."
"I think the UI is not there yet. It could be improved by being more user-friendly."
"The solution needs improvement in its stability, support and pricing."
"The capability to implement it with comparable performance across various private cloud environments, ensuring adaptability to different infrastructure setups would be beneficial."
"We tried to use case Teradata for a data warehouse system, but we had some problems in relation to the Teradata system, CDC tools, and source databases. We were unable to transfer data from HPE Integrity mainframe to Teradata."
"There is a need to improve performance in high transaction processes, as well as the reporting system."
"The scalability could be better. The on-premises solution is always more complicated to scale."
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, 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.