
Ease of use, robust dependability and excellent support Review collected by and hosted on G2.com.
Some timing issues with cache clearing, etc. But, resolved. Review collected by and hosted on G2.com.
I like it because it is a database manager very good compilations of data in structured language, it is easy to use is not cumbersome Review collected by and hosted on G2.com.
Some timing issues with cache clearing, etc. But, resolved. Review collected by and hosted on G2.com.
The ease of installation and compatibility with all cloud providers is the best. Resilient components makes it easy for installing and maintaining as distributed components.DB replication feature is the best. Review collected by and hosted on G2.com.
Instances are hard wired to memsql instance ids, It would be easier if we have option to add new one's and delete existing ones easily. The process of node joins and node decommission can made be simpler making all the cloud operations easy. Review collected by and hosted on G2.com.
MemSQL durability is slightly different for its in-memory rowstore and an on-disk columnstor which makes it awesome and a cluster can be configured in "High Availability" mode. It is also one of the fastest databases for columnar storage and analytical workloads. Review collected by and hosted on G2.com.
A little maybe better documentation would be helpful , espically for beginners. Also to play around for smaller machines like raspbeery pi and some fun projects to start with. Review collected by and hosted on G2.com.
The speed of queries, Kafka stream support, the easy to learn - syntax same as Mysql.
Your support is great, answer quickly on ticket. Review collected by and hosted on G2.com.
First query run time (compilation time), not easy and clear how to analyze/improve slow query. Review collected by and hosted on G2.com.
The similarity to mysql. very clever architecture. very easy to use Kafka with im Review collected by and hosted on G2.com.
The time that take for first query.
The time that take to query with temp table (and in mySql is work very quick) Review collected by and hosted on G2.com.
For extremely large data mining, memsql stands above the rest. The ability to process an extreme amount of data expediently is by far the greatest part of memsql. Review collected by and hosted on G2.com.
Being on the Operations side of Memsql comes with it's challenges. There's a high learning curve for it, and at this time there isn't nearly as much out on the internet to help. Support is great, but being able to get in-the-moment answers is lacking. Review collected by and hosted on G2.com.
Well, our engineers were extremely happy to use MemSQL to integrate a no. of data we were trying to pull together. As i understand, this product made the ride jiffy! Keep doing the great work. Review collected by and hosted on G2.com.
There was nothing specific that I can recollect we encountered while deploying memSQL. In case there was, I believe the support team was excellent. Review collected by and hosted on G2.com.
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.
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.
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.
Its capability to integrate with almost all databases is the best Review collected by and hosted on G2.com.
I wish eval version had more features so that people can make out the decision after much exploration Review collected by and hosted on G2.com.
I would suggest them to make the physical persistence more robust. Review collected by and hosted on G2.com.
The physical persistence is not as robust as I would have liked to. Review collected by and hosted on G2.com.
Distributed columnar database which allow online analytics queries.
Fast insert and update data volums Review collected by and hosted on G2.com.
No foreign keys (at least as a hint) to allow distributing tables which share the same key at the same nodes. Review collected by and hosted on G2.com.
it was fast to query, there is a lot of support, updates in real time, effective database Review collected by and hosted on G2.com.
Lack of alerts , log in failed a few times Review collected by and hosted on G2.com.
- Speed : Aggregate queries are very fast.
- Disk Compression: CS engine compresses data 60 to 80% on avg.
- Drop-in Solution : Low learning curve if you come from MySQL background
- Pipelines: Easiest and fastest way to ingest data . Automatically detect new data in S3 buckets. Review collected by and hosted on G2.com.
- Lack of DB Performance monitoring: MemSQL should provide Percona PMM dashboard type of monitoring with explanation of the metrics being monitors and action to take. SolarWind for MySQL is also excellent at aggregating queries over time. Review collected by and hosted on G2.com.
I like the flexibility of the data access patterns I can use while building my code. Review collected by and hosted on G2.com.
The documentation needs more clarity to onboard. Review collected by and hosted on G2.com.
MemSQL has both row and columnar based storage and seamlessly able to query across both Review collected by and hosted on G2.com.
Deployment need more work and it need to several works to be done Review collected by and hosted on G2.com.