MemSQL Cloud Pricing

Clusters

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.

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.

Monitoring

MemSQL Cloud console includes an easy metrics user interface to track resource usage of your cluster to maintain maximum performance.

Scale Out Provisioning

MemSQL can efficiently scale out on industry standard hardware to address changes in workload, user concurrency or ingestion performance.

Encryption and Authentication

MemSQL Cloud Security Groups ensure that only IP addresses you verify can connect to your cluster. Default SSL makes sure there’s always an encrypted connection between your cluster and the outside network.

Technical Support

Each MemSQL Cloud cluster includes technical support from a team of experts. They ensure the environment runs smoothly and efficiently so you can run your business as peak performance.

Updates and Upgrades

MemSQL Cloud is automatically upgraded during regularly scheduled maintenance windows ensuring the latest features and improvements are readily available.

High Availability

Each MemSQL unit uses replication to ensure high availability. MemSQL automatically handles switching from Primary to Replica nodes in the event of failures, allowing users to maintain their workloads.

Cluster Sizes

Use the guide below to select a cluster size. Results may vary based on your workload and use case.

SMALL

small cluster

Load

1.25 GB Per Min

Make your batch loading real-time with full transaction guarantees.

500k Inserts Per Sec

Handle high velocity data, traffic spikes and streaming with ease.

Store

10 TB Historical Data

Use the column store to compress data 5-10x for large scale analytics.

30 GB Real-Time Data

Use the in-memory row store to power applications and streaming.

Query

500 Queries Per Sec

Run your queries concurrently across applications and users while maintaining consistently high performance. All queries are converted to machine code for low latency execution.

MEDIUM

medium cluster

Load

2.5 GB Per Min

Make your batch loading real-time with full transaction guarantees.

1M Inserts Per Sec

Handle high velocity data, traffic spikes and streaming with ease.

Store

20 TB Historical Data

Use the column store to compress data 5-10x for large scale analytics.

60 GB Real-Time Data

Use the in-memory row store to power applications and streaming.

Query

1,000 Queries Per Sec

Run your queries concurrently across applications and users while maintaining consistently high performance. All queries are converted to machine code for low latency execution.

LARGE

large cluster

Load

5 GB Per Min

Make your batch loading real-time with full transaction guarantees.

2M Inserts Per Sec

Handle high velocity data, traffic spikes and streaming with ease.

Store

40 TB Historical Data

Use the column store to compress data 5-10x for large scale analytics.

120 GB Real-Time Data

Use the in-memory row store to power applications and streaming.

Query

1,500 Queries Per Sec

Run your queries concurrently across applications and users while maintaining consistently high performance. All queries are converted to machine code for low latency execution.

EXTRA LARGE +

xlarge cluster

Load

10+ GB Per Min

Make your batch loading real-time with full transaction guarantees.

4M+ Inserts Per Sec

Handle high velocity data, traffic spikes and streaming with ease.

Store

80+ TB Historical Data

Use the column store to compress data 5-10x for large scale analytics.

240+ GB Real-Time Data

Use the in-memory row store to power applications and streaming.

Query

2,000+ Queries Per Sec

Run your queries concurrently across applications and users while maintaining consistently high performance. All queries are converted to machine code for low latency execution.

Pricing

MemSQL Cloud is available on demand or as an annual subscription. Your signup includes $300 in free credit when you create an account.

Size
First Cluster Price*
On-Demand Price
Reserved Price
Small
$0.99/hr
$3.00/hr
$2.50/hr 17% Off
Medium
$3.99/hr
$6.00/hr
$4.80/hr 20% Off
Large
$9.99/hr
$12.00/hr
$9.00/hr 25% Off
X-Large +
Contact us for larger or reserved pricing configurations

* First cluster pricing available until August 31.

Sizing Examples

Business Intelligence Dashboard Analytics

Scenario
You collect user engagement data from your website’s advertisements and want analytics on clicks for a given month. Normally you are looking at the past month of data, but you occasionally want to go back and compare with the previous year to gauge growth.

Your dataset is approximately 20 terabytes uncompressed, and you use columnstore tables. With an estimated 10x compression you expect your compressed data set to be 2 TB.

As data in MemSQL Cloud is replicated for high availability, you require 4 TB of storage.

Recommendation
Medium Cluster

Calculation
(20 TB uncompressed / (10x Compression)) * 2 Replicas = 4 TB of storage = Medium Cluster.

High Volume Ingest

Scenario
You collect high-volume, real-time sensor data for an IoT use case using the all memory rowstore. You require writing 1,000,000 rows a second, and each row contains 200 bytes of data. You want the last 10 minutes of data to remain active for machine learning algorithms using both the incoming and historical data.

Recommendation
Large Cluster

Calculation
200 bytes/s * 60 seconds * 10 minutes = 120GB of data stored in memory. As data is replicated in memory for rowstore use cases, you need 240 GB of total memory.

Many Concurrent Queries

Scenario
You have a data set of historical transactions in a columnstore table. The dataset is 40TB uncompressed, and you expect to have 100 users querying this database. You expect about 30 concurrent queries at a time.

Recommendation
Large Cluster

Calculation
For this use cases, we recommend starting with a cluster that meets your sizing requirements. From there, you can test your workload, and increase cluster size for more performance.

At an expected compression rate of 10x, you know that you need 4TB of storage per replica in this scenario, so 8 TB total. For 8TB of storage, we recommend a Large cluster.

Need help deciding?

Schedule a personal demo and get your questions answered by a MemSQL specialist