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.
"It is pretty simple to use and I don't have anything really bad to say about it."
"The deployment process is pretty fast."
"MySQL has cross-platform support for multiple operating systems. The backups on a Linux machine can be restored on a Windows machine, and vice versa."
"It creates a unified view of the entire architecture and performance factor, helping to manage the network more easily."
"The initial setup is easy."
"It's a mature solution that's been around for decades."
"The most valuable feature of MySQL is the informative error outputs of command line interface."
"A good traditional database that supports JSON."
"The key advantages are Performance when processing Terabytes of data and scalability."
"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."
"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."
"The flexibility in design is very good."
"I found all parts --loading, transformation, processing & querying work in parallel, and end-to-end-- to be valuable."
"Improved performance of ETL procedures, reporting."
"It has a solid set of tools and consulting services."
"It's very mature from a technology perspective."
"The analytics features are in need of improvement."
"The solution could be more secure."
"The interface could be improved."
"While utilizing a comparable algorithm, is noted to be sensitive, especially when configuring the inner device."
"Security is a concern. MySQL could have better security features."
"The replication needs improvement. It's becoming a native cloud product like Oracle DB or Cockroach DB."
"MySQL's performance requires attention. For optimal performance, one should review and sometimes revise the code, particularly when using server-side scripting."
"We have encountered some performance issues, and the solution takes time for performing complex queries."
"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."
"Teradata's pricing is quite high compared to Redshift, Synapse, or GCP alternatives."
"Data ingestion is done via external utilities and not by the query language itself. It would be more convenient to have that functionality within its SQL dialect."
"It could use some more advanced analytics relating to structured and semi-structured data."
"The setup is not straightforward."
"The SQL Assistant is very basic. This tool can be improved for usability."
"An additional feature I would you like to see included in the next release, is that it needs to be more cloud-friendly."
"Teradata hardly supports unstructured data or semi-structured 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.