MySQL vs SingleStore comparison

Read 6 SingleStore reviews

2,197 Views
308 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: October 2025).

Open Source Databases

Download the complete report

Helped 872,778 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 (4th)

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 8.9%, down 14.6% compared to last year.
SingleStore, on the other hand, focuses on Database as a Service (DBaaS), holds 2.7% mindshare, up 1.1% since last year.

Open Source Databases Market Share Distribution
Product	Market Share (%)
MySQL	8.9%
PostgreSQL	16.6%
Firebird SQL	15.2%
Other	59.3%

Open Source Databases

Database as a Service (DBaaS) Market Share Distribution
Product	Market Share (%)
SingleStore	2.7%
Amazon RDS	19.1%
MongoDB Atlas	14.0%
Other	64.2%

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 solution is easy to use."

"I like the JSON stuff."

"MySQL's most significant attribute is its capability to create, modify, and maintain databases. This is crucial and advantageous in procedures, such as SOAR. Therefore, all SQL functions are beneficial to any backend developer or developer who requires data storage."

"MySQL is an easy-to-use solution that provides stability, reliability, flexibility, performance, security, and high availability."

"It is a scalable solution."

"It is easy to use."

"The most valuable feature is the on-premises data encryption facilities."

"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 product can automatically reinstall and reconfigure in case of a shutdown."

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

"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."

"The paramount advantage is the exceptional speed."

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

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

Cons

"They should come up with a better solution than the NDB cluster for better scaling. If they could come up with a better solution for write scaling, apart from the NDB cluster, which is supported by all open source communities, that would be great. Although the NDB cluster, I believe, is an open-source tool, it's not widely supported as a solution."

"MySQL could introduce more indexing strategies."

"The GUI could improve in MySQL."

"It can have better monitoring. In addition, the enterprise manager should be able to cater to more than one virtual machine. Currently, you need one license per server. It seems a bit too much to get one license for one enterprise manager. I hope the enterprise manager for MySQL can accommodate more virtual machines for MySQL."

"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."

"Rather than going in-depth about the technical features, which a technical person can directly tell, I would say that MySQL should be able to adapt to the next framework. The 5G framework means an unstructured framework. So if MySQL becomes smoother and more adaptable, it'll be easier."

"Sometimes, I get lost in the toggles and buttons, and a better visual design would be nice. The layout is not user-friendly or efficient."

"When it comes to supporting big data, there is space to improve upon the database engines that are supported by MySQL."

More MySQL cons

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

"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."

"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."

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

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

Pricing and Cost Advice

"Can range from free to quite expensive, depending on the environments and requirements, so better to really set goals ahead of setting it up."

"There is a licensing cost because we are going for a proprietary product. There are some other versions for which there is no licensing cost."

"It is open-source."

"MySQL is cheaper than Microsoft SQL Server."

"When you know the setup will continue to grow, make sure you have the paid support."

"For the on-premise version, no license is required."

"The pricing is not much expensive, it's cheap."

"The solution is open source so is free."

More MySQL pricing and cost advice

"SingleStore is a bit expensive."

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

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

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

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

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

872,778 professionals have used our research since 2012.

Top Industries

By visitors reading reviews

Computer Software Company

14%

Financial Services Firm

10%

Manufacturing Company

Comms Service Provider

Financial Services Firm

33%

Computer Software Company

11%

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 21% of the time

PostgreSQL vs MySQL

Compared 14% of the time

SAP HANA vs MySQL

Compared 7% of the time

SQL Server vs MySQL

Compared 6% of the time

MariaDB vs MySQL

Compared 6% of the time

More MySQL Competitors

Compared 10% 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 6% of the time

OpenText Analytics Database (Vertica) 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