MemSQL is an open-source, in-memory database that enables businesses to store and analyze data in real-time. It is a distributed database system that offers both rowstore and columnstore capabilities, allowing companies to store, retrieve, and analyze large amounts of data quickly and efficiently. MemSQL is designed to support applications that require low latency and high throughput, such as online transaction processing (OLTP) and online analytics processing (OLAP). It is designed to scale horizontally and supports both on-premises and cloud deployments. It can be used for a variety of applications, such as fraud detection, real-time analytics, machine learning, and more. It is compatible with the Hadoop ecosystem and supports multiple programming languages, such as Java, C++, and Python.
SQL server is disk based, not memory based