MemSQL Reviews & Product Details

MemSQL has an excellent processing power that helps in scaling and performing large data queries of IOT data. Deploying and configuring database clusters is really easy and clusters are deployed within a minute. MemSQL is capable of performing distributed parallel queries to execute thousands and millions of rows. Review collected by and hosted on G2.com.

I have nothing specific to dislike about MemSQL and it has been an amazing experience utilizing MemSQL and it has shown great potential against other database solution in the organization Review collected by and hosted on G2.com.

I would like to rate it at a full star. Having worked with almost all the databases, I can simply say it aces every database that I worked.

Permissioning a new cluster by adding a super-user to MemSQL Ops and via GRANT statements on the cluster itself.

Best practices for configuring memory limits.

Best practices for basic cluster monitoring, and how to retrieve the relevant metrics. Review collected by and hosted on G2.com.

I don't have any particular dislikes, but would love to see its own Client interface, inbuilt Data Modelling capabilities and a superb front end which can help potentially any Developers or Programmers to start the development from Day 1.

Some administrative functions such as incremental, point-in-time, and object-specific backups and restore are lacking. The product is not fully mature. Although it uses the MySQL protocol, it does not always work with MySQL-compliant products. Review collected by and hosted on G2.com.

Overall experience with MemSQL is extremely great that helps to get interactive analytic on massive datasets with effortless operations scalability. It has a great architecture mechanism to easily ingest data into a distributed storage system and produce high-efficiency complex queries over the latest datasets. Storing data also very secure and row-column oriented that allows us to create a table with great customization. It is also available in a free trial to analyze the tool first before deploying it in the premises and very responsive to support customer issues with the application. Review collected by and hosted on G2.com.

It requires little more informative documentation for the beginners to understand the overall tool mechanism. Review collected by and hosted on G2.com.

I had a great experience with MemSQL that provides amazing performance in AdHoc queries and streaming analytics on the big databases. It is a robust software that easily aces every database and executing fast queries with real-time data ingestion. It is easy to setup and legacy compatible. The customer support was great and helpful to resolve technical issues. Overall I liked this software that has less learning path, easily supports MySQL, and compatible with other products as well. Review collected by and hosted on G2.com.

Documentation has to be more informative and detailed with functionality. Overall I liked this software that has less learning path, easily supports MySQL, and compatible with other products as well. Review collected by and hosted on G2.com.

MemSQL efficiently handles large data and provides maximum performance. We can easily spin up new cloud database clusters and monitor the health of the database cluster. We can easily integrate and deploy MemSQL on different cloud service providers. It accepts AWS S3 as storage inputs and serves well as the data storage service. Review collected by and hosted on G2.com.

MemSQL has helped us in having the fastest and powerful database that is capable of handling and processing large datasets. It is highly scalable and has almost fulfill our organization needs and we haven't had any issues with it. Review collected by and hosted on G2.com.

MemSQL is the most powerful and fastest database for performing high-performance queries. The primary factor for utilizing MemSQL is speed and performance and capability to query over billions of rows. MemSQL is way more powerful and reliable than traditional databases in terms of speed, accuracy, and performance. We can have access to data in real-time and server crucial data to thousand of our users. Review collected by and hosted on G2.com.

We never encountered any issues with MemSQL and it was a pretty awesome experience utilizing it. Review collected by and hosted on G2.com.

MemSQL is the most perfect and reliable solution for streaming analytics and performing ad-hoc queries on large datasets. It can query millions of data in a matter of seconds and consuming fewer system resources. Queries and processes that usually took a lot of time are now processed very quickly and accurately without any issues. Review collected by and hosted on G2.com.

MemSQL being a powerful and reliable database solution there is only one single problem that I have personally faced with backup and restoration process. Review collected by and hosted on G2.com.

MemSQL helps in powering our complex applications by quickly analyzing and processing large datasets in the database. It can easily handle massive queries and provide quick processing and response. The process of storing and retrieval is pretty fast and it can easily process complex queries in seconds. Review collected by and hosted on G2.com.

MemSQL utilizes huge physical resources of the instances in case of processing large datasets and it can be an issue if auto-scaling isn't configured. Review collected by and hosted on G2.com.

- Super simple, we implemented the whole of our customer-facing streaming analytics data store in a 2-day hackathon

- Natively integrates with AWS & other services (we are a multi-petabyte S3 shop with huge Kafka clusters)

- Since most of it is SQL, anyone can hit the ground running in no-time, an ultra-low barrier to entry

- We saw a sub-second response on a test case with 1000 concurrent heavy API calls (scanning billions of rows across many tables + window functions etc) along with applying RBAC functionalities on the fly

- Incredibly fast out of the box, basic performance tuning will suffice 95% of use cases

- Fantastic partners to work with, super helpful, we have access to their core engineering team, +100 on Customer engagement! Review collected by and hosted on G2.com.

In my humble opinion, it solved a very unique hard problem for us elegantly (without having to compromise on any architectural or data principles). Problem of streaming analytics on high-velocity high volume data sets with sub-second API responses can be a handful. For me, this along with other use-cases they mention is their core strength. So anything beyond these capabilities is a "Nice to have" for me. Their roadmap covers most of what the community is asking - hot back-up's, better UI, modelling etc. Review collected by and hosted on G2.com.

MemSQL is a highly reliable and scalable database service that is capable of processing the heavy workload of data. It guarantees deliverability of streaming data and provides detailed reports. It supports multiple database inputs such as MySQL, Postgres, SQL Server and many more. Review collected by and hosted on G2.com.

Deployment process needs to be improved and their support isn't that quick and responsive in solving our technical issues. Review collected by and hosted on G2.com.

MemSQL is a database that performs most of the operations in the frame compared to other commercial solutions, therefore it is also a much faster solution perfectly suited for data analysis compared to other databases. A great advantage of MemSQL is that the database is memsql compatible, making the transition very easy. Review collected by and hosted on G2.com.

MemSQL is not suitable for smaller projects due to the need for a large amount of frame memory. Review collected by and hosted on G2.com.

We have had excellent luck with ingest rates and the ability to do lightning fast counts and other general math on time based data sets. If you are already familiar with SQL you will have little trouble utilizing this platform. Although we have had few occasions to use it, paid support was quite responsive and helped us correct issues quickly. Toolset allows for quick builds and deployments and services have been stable over significant periods of uptime. MemSQL Ops dashboard also allows for at-a-glace view to determine if your cluster is generally healthy. Review collected by and hosted on G2.com.

Although I have heard of some people have positive results, I would like to implement autoscaling with the ability to increase licensing cost only for the time a cluster is scaled. I will soon be looking into MemSQL's Helios product to see if that is a reasonable path forward for us. Review collected by and hosted on G2.com.

Having worked on the database for a quite a good time, I believe it is really going to be standing with its flag high. Its really fast, wonderful optimization, lots of flexibility and overall is very agile to git into the needs of small to large enterprises. Review collected by and hosted on G2.com.

At present not many bloggers or its own forum which can really help the developers and architects for a quick resolution. Mostly relying on MYSQL posts to get the resolution. Review collected by and hosted on G2.com.

I started using memsql last year and found that it is really quite easy to learn and work with MemSQL and unlike other databases you don't need extensive administrator activities to admin the memsql cluster and database per say.

Apart from that when you start working with memsql, you can very well observe that the data storage and retrieval is quite fast and doesn't matter how many joins and complexities are involved in the queries, the query results are pretty fast.

I also like the feature of memsql that the same DB system can be used for OLTP and OLAP purpose as well. Review collected by and hosted on G2.com.

Many a times few things behave unique and different in memsql because of the settings of system variables which are set for the database, so user/developer needs to be aware of those variables. Example - Data truncation and data types conversion happen implicitly and provides different output depending on the system variables settings. Review collected by and hosted on G2.com.

I love how we can get scale and speed out of this database technology. We have loaded data in volumes that have historically stopped other database technologies in their tracks. We also have integrated the Memsql with our data visualization software which streamlines our reporting channels. Review collected by and hosted on G2.com.

I don't have any complaints at this point. Review collected by and hosted on G2.com.

By making use of the memsql-ops tooling, I'm able to quickly and easily spin up an entire cluster with HA. Review collected by and hosted on G2.com.

The database makes heavy use of memory (which is one of its selling points), which can make it challenging in instances where large queries can bring a node to a halt due to out of memory issues. Improved understanding of the system and better monitoring can help work around that potential pit fall. Review collected by and hosted on G2.com.

The UI of the product looks great but there is still scope for improvement. The Performance degrades at times. The buttons and features could be more interactive and re-prioritized for easiness of the customers working on it. Review collected by and hosted on G2.com.

Structural backbone of the product looks unsustainable and might cause trouble in our use case. Latency on complex schema designs. We process huge chunk of data in TBs everyday and it is back and forth read write step that requires minimum latency, this product may not work as anticipated. Review collected by and hosted on G2.com.

The ease with which our team can build out new data models and deploy them into our production systems without worry that our infrastructure can handle it. Review collected by and hosted on G2.com.

While MemSQL is an excellent managed database service, the price tag for the features that they deliver is fairly high compared to the market. Review collected by and hosted on G2.com.

Memsql works very fast it is easy to use and implement and it is mostly very stable and the support is mostly quick and responsive Review collected by and hosted on G2.com.

There are some bugs sometimes but mostly they are fixable and you can continue without any impact . Review collected by and hosted on G2.com.

Simple to deploy, administer and operate with the highest performance to fulfill client requests. Fits well into the microservice and container-based application with the reliability you can count on. Capable to scale with the application demand. Easy to administer with the centralized tool and reactive web UI. Review collected by and hosted on G2.com.

The backup and restoration can be a bit challenging. Simultaneous extraction of the back up can be a challenge with large scale deployment. lack of logging on deployment failures which are related to environmental factors. Requirements on internet access make it difficult to deploy in a closed network environment. Review collected by and hosted on G2.com.

The best thing about memsql is the speed at which queries are run - add kafka pipelines for your ETL process and everything data related becomes much easier. Review collected by and hosted on G2.com.

Nothing really - everything runs pretty smooth and the support provided is great. Review collected by and hosted on G2.com.

Few quires will run faster if you did everything correctly as per undocumented, unexplained MemSQL specification. Review collected by and hosted on G2.com.

It's unusable as ANSI compliant SQL server. Single and simple insert, update and delete do not work. Data can be loaded faster if it is in perfectly formatted CSV file. It frequently runs out of memory. We have 3 nodes with 2 aggregates with total of 160GB of memory and it still runs out of memory. Local Pipelines can do very less in real world scenarios. Review collected by and hosted on G2.com.

Fast response times which makes it a good fit for an alternate ODS for legacy databases like Db2 on mainframe. Also, it has potential to be used for both for transaction processing as well analytical queries. Review collected by and hosted on G2.com.

Some of the data types supported by legacy databases are not supported by MemSQL Review collected by and hosted on G2.com.

Amazing performance of MemSQL both for reads and writes.

No blocking sessions.

Non blocking indexes.

Excellent performance for Dashboards, mobile applications, warehouses, data science, realtime reporting performance. Review collected by and hosted on G2.com.

Central monitoring not available.

Indexes are built on start up and if there are too many indexes it takes more time. Review collected by and hosted on G2.com.

We, a Big 4 accounting firm, use MemSQL for rapid creation and destruction of clusters. MemSQL's speed and reliability are key for our use case since speed is our priority. Review collected by and hosted on G2.com.

Getting used to using a shard key for our tables was a little slow for teammates to adopt. Review collected by and hosted on G2.com.