

Teradata and MySQL compete in the database management system category with Teradata having an advantage in handling large data volumes efficiently due to its performance and scalability features.
Features:Teradata offers robust MPP architecture, fast parallel processing, and inbuilt security and redundancy options suitable for large-scale data warehousing. MySQL is favored for simplicity, ease of integration, and cost-effectiveness, supporting a broad range of storage engines ideal for versatile use cases.
Room for Improvement:Teradata needs to enhance cloud integration, scalability for on-premises setups, and unstructured data handling. MySQL could improve in scaling capabilities, backup methods, and user interface usability.
Ease of Deployment and Customer Service:Teradata provides strong technical support and comprehensive training, though it can be costly. MySQL benefits from community support and easier deployment options, though it may require third-party support for complex issues.
Pricing and ROI:Teradata is a high-cost option offering strong ROI for complex analytics in enterprises, while MySQL’s open-source nature provides a cost-effective solution with low operational costs, suitable for startups and smaller businesses.
I have seen a return on investment with MySQL, as it allows us to manage with fewer employees, focusing on business logic rather than database management.
At least fifteen to twenty percent of our time has been saved using Teradata, which has positively affected team productivity and business outcomes.
Independent research showed that Teradata VantageCloud users achieved an average ROI of 427% across three years with payback under a year, demonstrating the platform's ability to deliver a strong financial return.
We have realized a return on investment, with a reduction of staff from 27 to eight, and our current return on investment is approximately 14%.
I would rate the documentation and online support a 10 out of 10.
We have no issues and usually receive timely responses.
The customer support for Teradata has been great.
They are responsive and knowledgeable, and the documentation is very helpful.
Customer support is very good, rated eight out of ten under our essential agreement.
Meeting scalability requirements through cloud computing is an expensive affair.
MySQL's scalability is currently adequate, as we have increased operations from ten thousand to twelve thousand devices, and it is working fine for us.
Whenever we need more resources, we can add that in Teradata, and when not needed, we can scale it down as well.
This flexibility allows organizations to scale according to their needs, balancing performance, cost, and compliance requirements.
This expansion can occur without incurring downtime or taking systems offline.
We face certain integration issues, especially when we integrate the database with security solutions like IBM QRadar.
From my experience, MySQL was pretty stable.
Its massively parallel process architecture allows the platform to distribute workload efficiently, enabling organizations to run heavy analytic queries without compromising speed or stability.
I find the stability to be almost a ten out of ten.
The workload management and software maturity provide a reliable system.
It could be more beneficial if MySQL can enhance its data masking functionality in the same way it has improved data encryption.
Oracle could improve on scalability.
The load balancer, MySQL LB, which is used to connect to the application, lacks clear documentation.
I want to highlight two features for improvement: first, storing data in various formats without requiring a tabular structure, accommodating unstructured data; and second, adding AI ML features to better integrate Gen AI, LLM concepts, and user-friendly experiences such as text-to-SQL capabilities.
Unlike SQL and Oracle, which have in-built replication capabilities, we don't have similar functionality with Teradata.
The most challenging aspect is finding Teradata resources, so we are focusing on internal training and looking for more Teradata experts.
Oracle has different components, so if you need security, you have to procure a different license, but here everything is inbuilt and it's not costly.
Teradata is much more expensive than SQL, which is well-performed and cheaper.
Initially, it may seem expensive compared to similar cloud databases, however, it offers significant value in performance, stability, and overall output once in use.
Role-based access control (RBAC), strong audit and compliance features, high availability, fault tolerance, and encrypted data at rest and in-transit are key features.
With Oracle, we have to buy another solution for encryption and masking, but MySQL supports native encryption, which enhances our return on investment.
The main feature we utilize in MySQL is the view, and I can say that it is the most valuable feature for our needs.
It allows programming, writing stored procedures, creating views, constraints, and triggers easily.
Teradata's security helps our organization meet compliance requirements such as GDPR and IFRS, and it is particularly essential for revenue contracting or revenue recognition.
Its architecture allows information to be processed efficiently while maintaining stable performance, even in highly demanding environments.
It facilitates data integration, where we integrate and analyze data from various sources, making it a powerful and high-quality reliable solution for the company.
| Product | Mindshare (%) |
|---|---|
| MySQL | 5.9% |
| Teradata | 4.1% |
| Other | 90.0% |


| Company Size | Count |
|---|---|
| Small Business | 75 |
| Midsize Enterprise | 33 |
| Large Enterprise | 61 |
| Company Size | Count |
|---|---|
| Small Business | 28 |
| Midsize Enterprise | 13 |
| Large Enterprise | 52 |
MySQL is an open-source database known for its ease of use and high performance. It offers features like replication and clustering, making it ideal for diverse applications. Its cost-effectiveness and LAMP integration are key advantages for businesses.
MySQL supports a variety of languages and platforms, providing reliable, scalable data management. Its graphical interface and LAMP architecture integration enhance its usability, while community support further strengthens its appeal. Challenges include scalability issues with large databases, lack of advanced clustering, and limited high-availability features. Complex queries may affect performance, and integration can pose difficulties. The outdated interface and insufficient documentation are also concerns, along with replication and backup reliability issues.
What are MySQL's key features?MySQL is widely implemented in industries such as web development, e-commerce, and finance. It's used for managing dynamic websites, powering e-commerce platforms, and supporting financial applications. Its compatibility with PHP and cost-effectiveness make it suitable for CMS platforms like WordPress. With cloud services integration, MySQL is a backend choice for scalable applications in various sectors.
Teradata is a powerful tool for handling substantial data volumes with its parallel processing architecture, supporting both cloud and on-premise environments efficiently. It offers impressive capabilities for fast query processing, data integration, and real-time reporting, making it suitable for diverse industrial applications.
Known for its robust parallel processing capabilities, Teradata effectively manages large datasets and provides adaptable deployment across cloud and on-premise setups. It enhances performance and scalability with features like advanced query tuning, workload management, and strong security. Users appreciate its ease of use and automation features which support real-time data reporting. The optimizer and intelligent partitioning help improve query speed and efficiency, while multi-temperature data management optimizes data handling.
What are the key features of Teradata?
What benefits and ROI do users look for?
In the finance, retail, and government sectors, Teradata is employed for data warehousing, business intelligence, and analytical processing. It handles vast datasets for activities like customer behavior modeling and enterprise data integration. Supporting efficient reporting and analytics, Teradata enhances data storage and processing, whether deployed on-premise or on cloud platforms.
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.