MySQL vs SingleStore comparison

Read 6 SingleStore reviews

2,248 Views
292 Comparison Views

100% willing to recommend

MySQL

Comparison Buyer's Guide

Download the report

Executive Summary

We performed a comparison between MySQL and SingleStore based on real PeerSpot user reviews.

Find out what your peers are saying about Oracle, PostgreSQL, Firebird and others in Open Source Databases.

To learn more, read our detailed Open Source Databases Report (Updated: August 2025).

Open Source Databases

Download the complete report

Helped 867,497 peers since 2012

Review summaries and opinions

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Categories and Ranking

MySQL

Average Rating

8.2

Reviews Sentiment

7.4

Number of Reviews

150

Ranking in other categories

Open Source Databases (1st), Relational Databases Tools (5th)

SingleStore

Average Rating

8.8

Reviews Sentiment

7.4

Number of Reviews

Ranking in other categories

Database as a Service (DBaaS) (12th), Vector Databases (15th)

Mindshare comparison

While both are Databases solutions, they serve different purposes. MySQL is designed for Open Source Databases and holds a mindshare of 9.2%, down 15.2% compared to last year.
SingleStore, on the other hand, focuses on Database as a Service (DBaaS), holds 2.6% mindshare, up 0.9% since last year.

Open Source Databases Market Share Distribution
Product	Market Share (%)
MySQL	9.2%
PostgreSQL	16.8%
Firebird SQL	15.8%
Other	58.2%

Open Source Databases

Database as a Service (DBaaS) Market Share Distribution
Product	Market Share (%)
SingleStore	2.6%
Amazon RDS	20.1%
MongoDB Atlas	13.9%
Other	63.4%

Database as a Service (DBaaS)

Featured Reviews

Prabir Kumar Kundu

SR AVP–Presales Cloud & Platform Management Services at Path Infotech ltd

Offers robust security and availability with impressive replication capabilities

Regarding their documentation and interface, there is room for improvement. Documentation is definitely required when running multiple databases on a cluster system. The load balancer, MySQL LB, which is used to connect to the application, lacks clear documentation. When there are multiple application servers connecting to the MySQL cluster and going through the MySQL load balancer, the documentation is not user-friendly. It's there, but only technical persons with deep knowledge of the MySQL database can implement it. Most of the community users or ISVs who use MySQL don't have many technical persons or DBA experts, so they face some challenges for the high availability of connecting high available databases from high available applications. That documentation should be simplified.

Read full review

Yasin Sarı

Senior Data Analyst at a comms service provider with 1,001-5,000 employees

High-speed data processing, seamless scalability, and excellent high availability making it an optimal choice for those prioritizing performance and efficiency in a database solution

There's a noteworthy consideration when it comes to collecting massive amounts of data. It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks. Attempting to use it for direct extraction, for instance, might lead to memory-related challenges. While MySQL version five might lack extensive SQL capabilities, SingleStore also has its constraints, requiring simpler SQL writing. This becomes evident when seeking advanced functionalities like window functions or JSON functions, where SingleStore doesn't offer an extensive toolkit, necessitating a more straightforward approach to SQL.

Read full review

Quotes from Members

We asked business professionals to review the solutions they use. Here are some excerpts of what they said:

Pros

"The initial setup for the SQL database is not complex and it even integrates into the platform. You set up the recipe and then just follow the runbook, the build book. Then it works as long as you follow the procedures."

"The initial setup is easy."

"It is a very stable solution. I deployed the product six years ago, and it still works fine."

"What I really like about MySQL is the opportunity to search for information and organize it any way I like."

"MySQL is open-source. There are a lot of open-source communities trying to come up with their own patches, and to come up with their own features, which help MySQL develop faster than traditional databases like Oracle, which is closed source."

"MySQL solution is overall stable."

"MySQL is a scalable tool. Scalability-wise, I rate the solution a nine out of ten...The solution's technical support is good. I rate the technical support a nine out of ten."

"When comparing MySQL to other solutions it is easier to use and boots up faster. Additionally, when you want to query a lot of data, MySQL is better in performance."

More MySQL pros

"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."

"The paramount advantage is the exceptional speed."

"It's a distributed relational database, so it does not have a single server, it has multiple servers. Its architecture itself is fast because it has multiple nodes to distribute the workload and process large amounts of data."

"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."

"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."

"The product can automatically reinstall and reconfigure in case of a shutdown."

Cons

"The data masking functionality should be improved as well as the native encryption functionality in the MySQL database."

"There should be an arrangement for end-users to get trained to use the tool...Improvement-wise, a graphical interface could be added for new users, eliminating the need to memorize the complex syntax."

"MySQL could be improved by adding more automation."

"Oracle should start putting in some of the enterprise features in the standard feature. There are some key features that should be part of the standard."

"Security is a concern. MySQL could have better security features."

"The performance issues in the product can be considered as an area where improvements are required."

"We require more ease of use, scalability, and high availability. These are some of the critical features that we use and look for in a product. It should be easier to manage clusters. Scalability is very important for us because our projects and concurrency requirements are quite big. We also require high availability of the server, application, and other things. It should also have more performance-based features or enhancements from the performance point of view. When we divide a database, it should be able to handle the queries very fast."

"In MySQL, we need to define every table beforehand."

More MySQL cons

"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."

"Having the ability to migrate servers using a single command would be extremely beneficial."

"There should be more pipelines available because I think that if MemSQL can connect to other services, that would be great."

"For new customers, it's very tough to start. Their documentation isn't organized, and there's no online training available. SingleStore is working on it, but that's a major drawback."

"It is not the optimal choice for direct data collection through queries, and it's more suited for aggregation tasks."

"We don't get good discounts in Pakistan."

Pricing and Cost Advice

"There is a license needed for this solution."

"MySQL is a cheap solution."

"Microsoft licensing for SQL Server is probably ten times more expensive. I used to work for the government, and I remember when we were looking into upgrading to the enterprise version of SQL Server 2019, the licensing was going to cost 350,000. To get the equivalent in the cloud, it was going to be about four grand to get the same processing power and everything else. With MySQL, it was going to be about 300 for the same licensing. Cost-wise, for sure, there is a huge difference. Would you prefer to pay 300 a month or 3,000 to have the same amount of data resources? You might lose a few options that you need, but it isn't worth the price difference."

"We are using the free community version of the solution."

"We've never bought a commercial license. We just use the open-source community edition."

"We are using the free version of MySQL. We prefer paying for a yearly license."

"It's cheaper than other solutions."

"It's an open-source database management system that can be used free of charge."

More MySQL pricing and cost advice

"Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure."

"They have two main options: cloud installation and bare-metal installation, each with different pricing models."

"I would advise users to try the free 128GB version."

"SingleStore is a bit expensive."

"The product's licensing is not expensive. It is comparable."

See which vendors are best for you

Use our free recommendation engine to learn which Open Source Databases solutions are best for your needs.

See recommendations

867,497 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Computer Software Company

14%

Financial Services Firm

10%

Manufacturing Company

Educational Organization

Financial Services Firm

32%

Computer Software Company

12%

Comms Service Provider

University

Company Size

By reviewers

Large Enterprise

Midsize Enterprise

Small Business

By reviewers
Company Size	Count
Small Business	73
Midsize Enterprise	31
Large Enterprise	61

By reviewers
Company Size	Count
Small Business	4
Large Enterprise	3

Questions from the Community

Why are MySQL connections encrypted and what is the biggest benefit of this?

MySQL encrypts connections to protect your data and the biggest benefit from this is that nobody can corrupt it. If you move information over a network without encryption, you are endangering it, m...

Considering that there is a free version of MySQL, would you invest in one of the paid editions?

I may be considered a MySQL veteran since I have been using it since before Oracle bought it and created paid versions. So back in my day, it was all free, it was open-source and the best among sim...

What is one thing you would improve with MySQL?

One thing I would improve related to MySQL is not within the product itself, but with the guides to it. Before, when it was free, everyone was on their own, seeking tutorials and how-to videos onli...

What do you like most about SingleStore DB?

The paramount advantage is the exceptional speed.

What is your experience regarding pricing and costs for SingleStore DB?

Using it for analytical purposes can be cost-effective in the long run, especially in terms of infrastructure. While building an on-premise cluster incurs an initial cost for servers with ample RAM...

What needs improvement with SingleStore DB?

ClickHouse vs SingleStore

Comparisons

Firebird SQL vs MySQL

Compared 23% of the time

PostgreSQL vs MySQL

Compared 14% of the time

SAP HANA vs MySQL

Compared 8% of the time

MariaDB vs MySQL

Compared 6% of the time

SQL Server vs MySQL

Compared 6% of the time

More MySQL Competitors

Compared 11% of the time

SQL Server vs SingleStore

Compared 8% of the time

Supabase Vector vs SingleStore

Compared 7% of the time

CockroachDB vs SingleStore

Compared 7% of the time

Oracle Database vs SingleStore

Compared 6% of the time

More SingleStore Competitors

Product Reports

MySQL

Download MySQL product report

Download SingleStore product report

Overview

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?

Open-source nature: Freely available and customizable.
Cross-platform compatibility: Supports multiple operating systems.
Scalability: Capable of handling large volumes of data.
Replication and clustering: Ensure data redundancy and load balancing.
Full-text search: Provides powerful search capabilities.
LAMP integration: Seamlessly integrates with Linux, Apache, and PHP.

What benefits should users consider?

Cost-effectiveness: Reduces expenses due to its open-source nature.
High performance: Efficiently processes large volumes of data.
Active community support: Access to a wide range of resources and expertise.
Versatile use cases: Suitable for varied applications including web development and IoT.

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.

Oracle

SingleStore delivers the performance you need for enterprise AI, providing the most performant data platform for apps and analytics at scale. SingleStore enables organizations to scale from one to one million customers in one unified platform. SingleStore offers transparent pricing as shown here https://www.singlestore.com/pricing/

SingleStore caters to over 400 customers globally, including major banks and tech companies in 50+ countries and 40+ verticals. It offers seamless scaling for both transactional and analytical workloads, simplifying data management with its MySQL compatibility and real-time processing capabilities. SingleStore's distributed architecture ensures speed and reliability, efficiently handling large data volumes.

What are the key features of SingleStore?

MySQL Compatibility: Eases the learning curve for users.
Built-in Pipelines: Connects to S3, Kafka, and more.
High Concurrency: Processes billions of records swiftly.
Replication & Failover: Enhances speed and reliability.
In-memory Storage: Ensures data safety and quick access.

What benefits can users find in SingleStore reviews?

Automatic Reconfiguration: Simplifies management tasks.
Impressive SQL Performance: Supports complex queries efficiently.
Scalability: Handles large datasets with a multi-node setup.

Top banks and fintech companies leverage SingleStore for efficient management of financial data, while media and telecom industries use it for scalable metadata management and improved data processing. Retail and eCommerce sectors benefit from enhanced transactional capabilities, reducing the need for separate databases and optimizing reporting processes. SingleStore's capacity to unite diverse workloads makes it a strategic choice across many sectors.

Sample Customers

Facebook, Tumblr, Scholastic, MTV Networks, Wikipedia, Verizon Wireless, Sage Group, Glassfish Open Message Queue, and RightNow Technologies.

400+ customers including: 6sense, Adobe, Akamai, Ant Money, Arcules, CARFAX, Cigna, Cisco, Comcast, DELL, DBS Bank, Dentsu, DirectlyApply, EY, Factors.AI, Fathom Analytics, FirstEnergy, GE, Goldman Sachs, Heap, Hulu, IMAX, impact.com, Kroger, LG, LiveRamp, Lumana, Nvidia, OpenDialog, Outreach, Palo Alto Networks, PicPay, RBC, Samsung, SegMetrics, Siemens, SiteImprove, SiriusXM, SK Telecom, SKAI, SONY, STC, SunRun, TATA, Thorn, ZoomInfo.

Open Source Databases