The queries are mostly the same as mysql so it's pretty easy to move to use memsql.
The queries runs much faster and give our users a great experience using our system. Review collected by and hosted on G2.com.
The first loading of the queries is a bit slow. Review collected by and hosted on G2.com.
Ease of use from Spark. Tables in hdfs was easy to put inside MemSQL from Spark (table is created from df schema). Connectivity plugin is added through spark-submit. Web UI allows writing commands, see memory usage, schema etc. Review collected by and hosted on G2.com.
Upon uploading hdfs table into MemSQL due to insufficient memory node was going down. Wasn't able to delete this table due to some nodes being down. Auto table creating from Spark was missing columnstore save mode. Review collected by and hosted on G2.com.
Unique value proposition, provide performance and scalability of similar NoSql products, with a flexible SQL query support Review collected by and hosted on G2.com.
Doesn't behave like traditional SQL DBs, lots of concepts and new behaviors to master, not so comprehensive analysis/monitoring tools available yet Review collected by and hosted on G2.com.
The MemSql Studio is a great tool (profiling and resource usage are great features)
The MySql compatibility is a great help for porting existing projects. Review collected by and hosted on G2.com.
The FullText feature is limited in comparison to other tools (Analyzer flexibility), but I expect it to be improved. Review collected by and hosted on G2.com.
Good performance, scalability and easy setup. Kafka Integration was easy with native UI Review collected by and hosted on G2.com.
Integration with BI tools (tableau, microstrategy) Review collected by and hosted on G2.com.
Great to hear you had a really smooth Kafka integration. How can we improve integration with Tableau and Microstrategy? Reach out to community@memsql.com so we can learn more about your use-case here.
Store data across RAM's cluster and could access It really fast Review collected by and hosted on G2.com.
Some strange behaviour like Primary Keys disorder in past upgrade. Review collected by and hosted on G2.com.
Easy to perform maintenance of cluster and perform administrative tasks. Highly reliable and available even in default configuration. Review collected by and hosted on G2.com.
Technical documentation is sometimes not great. I've needed to engage tech support frequently to bridge gaps and verify procedures. Review collected by and hosted on G2.com.
Obviously the processing capability. Though we are still in the initial stages, we are beginning to notice how efficient MemSQL is with its lightening quick speeds. Review collected by and hosted on G2.com.
Lack of a good GUI. Having trouble with ODBC compatibilities, need to homogenize the drivers. Review collected by and hosted on G2.com.
Very fast performance, excellent scalability, good support, good documentation and very stable product Review collected by and hosted on G2.com.
No native admin tools means you have to use command line or MySQL workbench witch isn’t ideal Review collected by and hosted on G2.com.
Excellent performance is wonderful. Have you tried using MemSQL Studio, the web-based SQL Editor and monitoring tool?
The Columnar store on the disk and the performance it gives on commodity hardware. Review collected by and hosted on G2.com.
HA can be enabled only for the entire configuration, it would have been great if we could enable HA just for the memory components or just at disk level. Review collected by and hosted on G2.com.
Get practical answers, real workflows, and honest pros and cons from the G2 community or share your insights.
What are the benefits and drawbacks of using SingleStore for database management?
Is there provisin forthe software to be open source or will this be only following a Pay for Services model?
Averages based on real user reviews.
4 months
21 months
