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."The product is flexible and easy to use."
"The main advantage is the very large user base. This enables users to fix about any issue by answering any question."
"The initial setup is easy."
"Fully scalable and stable SQL-based RDBMS, with a straightforward and easy setup."
"It is pretty simple to use and I don't have anything really bad to say about it."
"The solution is very stable."
"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."
"The way that MySQL has improved my organization is that it comes free and also works fine on the technical side."
"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 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."
"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."
"From a user perspective, the initial setup could be simplified a bit."
"The GUI could improve to make MySQL better."
"The solution could be more secure."
"I am looking for the Temporal SQL feature, which basically means that there is complete history for each table. This feature is currently available in MariaDB. PostgreSQL has something called a foreign-data wrapper, which is another way to access external data from inside. MySQL could have a similar feature."
"I did the implementation of the solution myself and I used community support. The support from the vendor costs money."
"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."
"In an upcoming release, there should be something added similar to EPL. For example, when using the flow diagram, we can create a schema. We have two useful features to add or create the table, but there should be some UI features to allow us to drag and drop to create other schemas. This would be very helpful."
"I would like to see more integrations of the solution with other platforms and improve the support on different data types."
"The product can be developed further to provide more appropriate output to users as it is one of the areas where there are shortcomings."
"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."
"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."
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 SAP HANA, whereas SingleStore is most compared with SQL Server, Teradata, CockroachDB, Oracle Database 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.