We performed a comparison between MySQL and SingleStore based on real PeerSpot user reviews.
Find out what your peers are saying about Oracle, PostgreSQL, MariaDB and others in Open Source Databases."Like other databases, it has a rich set of functions, such as stored procedures and its own procedural language, which is akin to Oracle SQL. It also has trigger and cursor commands you would expect with a good database language."
"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."
"The solution is very stable."
"Fully scalable and stable SQL-based RDBMS, with a straightforward and easy setup."
"The easy access to the data and the ability to sort the data with multiple methods are very valuable features."
"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 most valuable features are that it's free and the documentation is good."
"The way that MySQL has improved my organization is that it comes free and also works fine on the technical side."
"The most valuable feature is the ability to create pipelines, streamline and extract data from the pipelines."
"The ability to store data in memory is a standout feature, enhanced by robust failover mechanisms."
"MemSQL supports the MySQL protocol, and many functions are similar, so the learning curve is very short."
"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 product's initial setup phase was pretty straightforward, with no complex processes."
"The product can automatically reinstall and reconfigure in case of a shutdown."
"The licensing cost of the solution is expensive, which MySQL needs to consider improving."
"Since we upgraded from 8.0.12 to 8.0.22, it has had some slowness-related issues. Some of the queries that were fast previously are quite slow now. I did some research, and I found many people complaining about it."
"MySQL tutorials and guides could be improved. Often they are too complex for someone with no database experience to understand."
"Security is a concern. MySQL could have better security features."
"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."
"It is not as powerful as SQL Server. It can be more powerful. It is not scalable and has certain limitations, which is not the case with SQL Server."
"It does not stand out regarding scalability. When the company size increases, the user base having actual experience with (very) large MySQL solutions is reduced."
"The full-text search feature must be improved."
"We don't get good discounts in Pakistan."
"Having the ability to migrate servers using a single command would be extremely beneficial."
"Poor key distribution can significantly impact performance, requiring a backward approach in design rather than adding tables incrementally."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"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."
MySQL is ranked 1st in Open Source Databases with 142 reviews while SingleStore is ranked 6th in Database as a Service with 7 reviews. MySQL is rated 8.2, while SingleStore is rated 8.8. The top reviewer of MySQL writes "Good beginner base but it should have better support for backups". On the other hand, the top reviewer of SingleStore writes "A reasonably priced product that offers good speed and seamless support". MySQL is most compared with Firebird SQL, PostgreSQL, MariaDB, Teradata and SQL Server, whereas SingleStore is most compared with SQL Server, Teradata, Oracle Database, CockroachDB and Vertica.
We monitor all Open Source Databases 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.