What users are saying about

Apache Spark

99 Ratings

MySQL<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>

Top Rated
634 Ratings

Apache Spark

99 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8.6 out of 101

MySQL<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow'>Customer Verified: Read more.</a>

Top Rated
634 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow'>trScore algorithm: Learn more.</a>
Score 8 out of 101

Add comparison

Likelihood to Recommend

Apache Spark

Apache Spark has rich APIs for regular data transformations or for ML workloads or for graph workloads, whereas other systems may not such a wide range of support. Choose it when you need to perform data transformations for big data as offline jobs, whereas use MongoDB-like distributed database systems for more realtime queries.
Nitin Pasumarthy profile photo

MySQL

MySQL is very well-suited to read-intensive database applications. It is very fast. It is also a great enterprise database for new DBAs because it is easy to obtain and installs on a variety of systems and platforms. Although I have not directly experienced problems, MySQL developers report that transactions aren't handled efficiently and that its trigger functionality is lacking sophistication. The biggest problem I've seen with it is how difficult it is to maintain stored procedures. That is a very common complaint and not isolated to my applications.
Kenneth Hess profile photo

Pros

  • Machine Learning.
  • Data Analysis
  • WorkFlow process (faster than MapReduce).
  • SQL connector to multiple data sources
Anson Abraham profile photo
  • Speedy System
  • Independent Platform
  • Mass Data Manipulation
  • Above Average Support
No photo available

Cons

  • Memory management. Very weak on that.
  • PySpark not as robust as scala with spark.
  • spark master HA is needed. Not as HA as it should be.
  • Locality should not be a necessity, but does help improvement. But would prefer no locality
Anson Abraham profile photo
  • MySQL simply doesn't scale as well as commercial databases. It seems to reach a performance plateau where you are then required to shard the data into different instances to get the performance you need.
  • The stored procedure and programming language is too limited compared to TSQL or PL/SQL.
  • Configuring the different storage engines is cumbersome to enable features like spatial queries. It would be helpful if all features could run out of the InnoDB storage engine.
  • It lacks some of the higher end features of commercial databases such as flashback recovery, updateable views, etc.
Christopher Weiss profile photo

Likelihood to Renew

No score
No answers yet
No answers on this topic
MySQL8.1
Based on 3 answers
For teaching Databases and SQL, I would definitely continue to use MySQL. It provides a good, solid foundation to learn about databases. Also to learn about the SQL language and how it works with the creation, insertion, deletion, updating, and manipulation of data, tables, and databases. This SQL language is a foundation and can be used to learn many other database related concepts.
No photo available

Usability

No score
No answers yet
No answers on this topic
MySQL7.6
Based on 4 answers
I give MySQL a 9/10 overall because I really like it but I feel like there are a lot of tech people who would hate it if I gave it a 10/10. I've never had any problems with it or reached any of its limitations but I know a few people who have so I can't give it a 10/10 based on those complaints.
Kenneth Hess profile photo

Support

No score
No answers yet
No answers on this topic
MySQL8.4
Based on 2 answers
The support staff is friendly, knowledgeable, and efficient. I only had to get part way through my explanations before they had a solution. They will walk you through a fix or actually connect in and fix the problem for you--or would if you can allow it. I've done it both ways with them. They are always forthcoming with 'how to do this if it happens again' information. I love working with MySQL support.
Kenneth Hess profile photo

Implementation

No score
No answers yet
No answers on this topic
MySQL7.3
Based on 1 answer
1. Estimate your data size.2. Test, test, and test.
No photo available

Alternatives Considered

Even with Python, MapReduce is lengthy coding. Combination of Python with Apache Spark will not only shorten the code, but it will effectively increase the speed of algorithms. Occasionally, I use MapReduce, but Apache Spark will replace MapReduce very soon. It has many built-in and faster features.
Kartik Chavan profile photo
Compared to Oracle MySQL is lacking some of the advanced features Oracle provides but through a detailed business and technical requirements capture process it became clear we would not need these very advanced features. Oracle is stronger on the backup and restore side of things and here I mean it does seem quicker using Oracle to import/export very large databases/indexes and partitions however we decide to live with the difference. All in all set up and ongoing costs was a significant factor in our decision to use MySQL.Our business doesn't have significant SQL Server expertise and with the costs and limited choice of OS involved of using SQLServer we eliminated it at a very early stage.
No photo available

Return on Investment

  • Optimization at its best (Super Fast).
  • Handles huge data with simple syntax whereas other programming language takes hell a lot of coding.
  • Best for parallel computing applications.
Kamesh Emani profile photo
  • Project Setup Costs - As MySQL is under a GPL licence and for our project there we no licensing costs (you need to check you are covered for your project). This has a huge saving compared to using Oracle and other such heavy weights.
  • Development Cycle - We found that MySQL was well suited for using it within Lean/Agile software development environments. Changes can be made quickly without being over complicated to implement and most of the time by an application DBA or a middleware developer.
  • Cluster Design - To date we have had no DB outages (we are using a HA cluster design) and therefore lead to cash and end customers T2R processes have been 100% available.
No photo available

Pricing Details

Apache Spark

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details

MySQL

General
Free Trial
Free/Freemium Version
Premium Consulting/Integration Services
Entry-level set up fee?
No
Additional Pricing Details