What users are saying about
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
946 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
52 Ratings

MySQL

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
946 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 8.6 out of 100

SingleStore

<a href='https://www.trustradius.com/static/about-trustradius-scoring#question3' target='_blank' rel='nofollow noopener'>Customer Verified: Read more.</a>
Top Rated
52 Ratings
<a href='https://www.trustradius.com/static/about-trustradius-scoring' target='_blank' rel='nofollow noopener'>trScore algorithm: Learn more.</a>
Score 9.2 out of 100

Attribute Ratings

  • MySQL is rated higher in 2 areas: Usability, Support Rating
  • SingleStore is rated higher in 2 areas: Likelihood to Recommend, Likelihood to Renew

Likelihood to Recommend

8.5

MySQL

85%
133 Ratings
9.2

SingleStore

92%
35 Ratings

Likelihood to Renew

9.9

MySQL

99%
4 Ratings
10.0

SingleStore

100%
3 Ratings

Usability

10.0

MySQL

100%
6 Ratings
7.5

SingleStore

75%
6 Ratings

Performance

MySQL

N/A
0 Ratings
9.2

SingleStore

92%
9 Ratings

Support Rating

8.6

MySQL

86%
4 Ratings
7.7

SingleStore

77%
6 Ratings

Implementation Rating

8.0

MySQL

80%
2 Ratings

SingleStore

N/A
0 Ratings

Likelihood to Recommend

Oracle

For smaller database backends, this product works well. Our backend printer management software is using MySQL as its backend and we have not had any issues since it went live 2 years ago. It's also free so no licensing worries.
Read full review

SingleStore

The most important use case is to load huge files into a distributed database system within a short span of time without having memory and time complexities. Whenever there is a need to transfer data for ETL during the staging phase and data warehousing stage, the load should be transferred without a lot of resource usage. Especially in the cloud space, the lesser we use the resources, the more cost-effective SingleStore is perfect for running data analytics workloads due to how easy it is to get data in & out. The performance and ease of use of the product are almost unmatched, which saves us a tremendous amount of time over having to spin up custom RDS instances for data analytics.
Read full review

Pros

Oracle

  • Security: is embedded at each level in MySQL. Authentication mechanisms are in place for configuring user access and even service account access to applications. MySQL is secure enough under the hood to store your sensitive information. Also, additional plugins are available that sit on top of MySQL for even tighter security.
  • Widely adopted: MySQL is used across the industry and is trusted the most. Therefore, if you face any problems, simply Google it and you shall land in plenty of forums. This is a great relief as when you are in a need of help, you can find it right in your browser.
  • Lightweight application: MySQL is not a heavy application. However, the data you store in the database can get heavy with time, but as in the configuration and MySql application files, those are not very heavy and can easily be installed on legacy systems as well.
Read full review

SingleStore

  • Return results of complex queries scanning TBs of data in sub-seconds.
  • Customer support team answer tickets quickly and provide guidance.
  • MySQL engine which allows to query using simple MySQL drivers from different clients.
  • Queries profiling is easy to use and helps investigating performance.
Read full review

Cons

Oracle

  • Although you can add the data you require as more and more data is added, the fixity of it becomes more critical.
  • As the demand, size, and use of the system increase, you may also need to change or acquire more equipment on your servers, although this is an internal inconvenience for the company.
Read full review

SingleStore

  • We wish the product had better support for High Availability of the aggregator. Currently the indexes generated by the two different aggregators are not in the same sequential space and so our apps have more burden to deal with HA.
  • More tools for debugging issues such as high memory usage would be good.
  • The price was the one that kept us away from purchasing for the first few years. Now we are able to afford due to a promotion that gives it at 25% of the list price. Not sure if we'll continue after the promotion offer expires in another 2 years.
Read full review

Pricing Details

MySQL

Starting Price

Editions & Modules

MySQL editions and modules pricing
EditionModules

Footnotes

    Offerings

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services

    Entry-level set up fee?

    No setup fee

    Additional Details

    SingleStore

    Starting Price

    $69 per hour

    Editions & Modules

    SingleStore editions and modules pricing
    EditionModules
    OnDemand0.691

    Footnotes

    1. per hour

    Offerings

    Free Trial
    Free/Freemium Version
    Premium Consulting/Integration Services

    Entry-level set up fee?

    Optional

    Additional Details

    Pricing Info

    Likelihood to Renew

    Oracle

    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.
    Read full review

    SingleStore

    We haven't seen a faster relation database. Period. Which is why we are super happy customers and will for sure renew our license.
    Read full review

    Usability

    Oracle

    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.
    Read full review

    SingleStore

    [Until it is] supported on AWS ECS containers, I will reserve a higher rating for SingleStore. Right now it works well on EC2 and serves our current purpose, [but] would look forward to seeing SingleStore respond to our urge of feature in a shorter time period with high quality and security.
    Read full review

    Performance

    Oracle

    No answers on this topic

    SingleStore

    I have used alot of ETL tools I have even built spark based ETL scripts but using singlestoreDB's PIPELINE function makes it all easy. Ingestion of data already present at file storage systems like S3 or GCS or Azure Blob is much much easier. The set-up of a pipeline is really is easy to do and you can even set it to run in intervals with the requirements of your system
    Read full review

    Support Rating

    Oracle

    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.
    Read full review

    SingleStore

    Very responsive to trouble tickets - Often, I think, the SingleStore's monitoring systems have already alerted the engineers by the time I get around to writing a ticket (about 10 - 20 mins after we see a problem). I feel like things are escalated nicely and SingleStore takes resolving trouble tickets seriously. Also SingleStore follows up after incidents to with a post mortem and actionable takaways to improve the product. Very satisfied here.
    Read full review

    Implementation Rating

    Oracle

    1. Estimate your data size. 2. Test, test, and test.
    Read full review

    SingleStore

    No answers on this topic

    Alternatives Considered

    Oracle

    MongoDB is an application oriented solution with unstructured data. Percona Server for MySQL is a good solution when looking for performance peaks and the amount of data grows continuously over time. MySQL is the ideal solution when we have a data schema defined and we do not have great requirements at the performance level.
    Read full review

    SingleStore

    Vertica, Snowflake, SQL Server, Azure Data Warehouse, PowerBI, Aerospike, etc. From what I've seen MemSQL is well worth the cost when latency and data freshness needs are high, i.e. you need a lot of queries to run with UI latency (the query itself takes less than a second or so), with very fresh streaming fact and dimensional data. It will be more expensive per "unit of performance" but if you need that performance then it'll get the job done.
    • On-prem Vertica (note, not Eon) provides more knobs for optimizing a particular data set and set of queries against it and performs as well or better in a single table, fact table queries. It will also scale to data size more cheaply due to its on-disk model. For large queries against large data sets where data freshness isn't as important (and latency either is or isn't), I'd take Vertica, although if you need to do a lot of joins that will struggle). However, as they still are exclusively columnar, dimension table updates, and recalls based on them, can only be tuned to happen so fast (we could do much better than 10 seconds with 10-100 updates per second for raw replication, and Vertica's joins are always slow so recalls were worse).
    • Snowflake suffers similarly to Vertica in the data freshness, replication, and re-calc area; SF also doesn't give as many knobs to turn as Vertica for data set optimization but seems to be better at joins. If you have a lot of queries to run against a lot of data and joins are limited, you need query latency low and consistent but you don't need a ton of freshness, I'd stick with Vertica. If joins matter more, or you can accept notably-but-not-terribly worse performance, then Snowflake is fine and cheaper from what we've seen. (Again, I can't speak to SF vs Vertica Eon).
    • SQL Server and ADW we couldn't get to perform as well as the other options, but I'll say we didn't try that hard on those.
    • Aerospike is amazing as a KV store; however for OLAP use cases where you want to balance performance against the flexibility of queries against general event (time series) data (i.e. be able to roll up to different grains) then KV becomes challenging.
    • PBI is great if you want an integrated BI tool, but if you want an OLAP solution to build against, with some particular scale or performance needs to be mentioned above, I'd go with one of these other solutions. It really can be great for letting non-tech folks build relatively small data sets and quick insights for customers (internal or external), great leverage in that case.
    Read full review

    Return on Investment

    Oracle

    • It has made site management through a CMS like WordPress or Drupal infinitely easier to manage.
    • It is a critical part of the LAMP, WAMP and MAMP stack and has been a major driver of innovation in the content-management-system space, pushing site and web-application development toward greater democratization.
    • It has proved to be very reliable and easy to set up and administer and saves me tremendous time troubleshooting query and performance issues.
    Read full review

    SingleStore

    • As the overall performance and functionality were expanded, we are able to deliver our data much faster than before, which increases the demand for data.
    • Metadata is available in the platform by default, like metadata on the pipelines. Also, the information schema has lots of metadata, making it easy to load our assets to the data catalog.
    Read full review

    Add comparison