MemSQL Cloud Pricing
MemSQL is the real-time data warehouse that delivers immediate insights across live and historical data
Clusters are priced by size
Pay by the hour, cancel any time
Prepay to get big discounts
A single instance of MemSQL is referred to as a MemSQL cluster. A cluster consists of everything you need to start writing to and reading from MemSQL databases.
1 unitEach unit has 2 TB of storage capacity. 5-10x compresssion allows you to store up to 10 TB of raw data on 2 TB of disk.
In addition to the raw memory and storage resources, each cluster comes with a number of standard features to ensure a secure, stable, and flexible experience. Learn more.
Example Use Case
Consider a company who wants to run analytics on a large volume of user click data in order to better understand demographic preferences in different regions of the world to improve targeted advertising.
The company wants to display this data on a real-time dashboard to enable up to the second insights into how users are interacting with the site. They also want to enrich this real-time data with historical data to do analysis on broader trends over time.
To accomplish this, the company uses an X-Large MemSQL Cloud cluster.8 units
1) Load data with MemSQL Pipelines
First they load the data to a row store table from Kafka using MemSQL Pipelines
2) Hold live data for 24 hrs
Once loaded, they hold the data in the live data table for 24 hours.
3) Store the data nightly
Then they move it into a historical data column store table every evening.
MemSQL Pipelines empowers the company to do analytics on their user data in real-time.
Column store compression allows the company to use a relatively small amount of disk space to store large quantities of raw data.
Query processing enhancements enable sub-second scans over the companies largest data sets.