reference deployment


Scalable database for operational analytics

This Partner Solution deploys MemSQL, a distributed, highly scalable structured query language (SQL) database, to the Amazon Web Services (AWS) Cloud. It also includes MemSQL Studio, a visual user interface that is supported on Google Chrome and Mozilla Firefox browsers. This Partner Solution is for database administrators, data architects, data scientists, and data analysts.

MemSQL ingests data continuously to perform operational analytics on billions of rows of data in relational SQL, JavaScript Object Notation (JSON), geospatial, and full-text search formats. MemSQL can handle both database workloads and data warehouse workloads, meeting transactional and analytical requirements. Together, MemSQL and AWS provide a compelling platform for building real-time applications.

MemSQL logo

This Partner Solution was developed by MemSQL Inc. in collaboration with AWS. MemSQL is an AWS Partner.

  •  What you'll build
  • Use this Partner Solution to automatically set up MemSQL on AWS. The deployment includes the following:

    • A high-durability architecture in a single Availability Zone.*
    • A virtual private cloud (VPC) configured with a public subnet according to AWS best practices, to provide you with your own virtual network on AWS.*
    • An internet gateway to allow access to the internet. This gateway is used by hosts to send and receive traffic.*
    • In the public subnet, one master aggregator node, one child aggregator node, and leaf nodes; the diagram shows four leaf nodes, the default is two, and the maximum is six.
    • A network load balancer that controls access to the MemSQL cluster’s aggregator nodes.
    • One attached Amazon Elastic Block Store (Amazon EBS) volume in each Amazon Elastic Compute Cloud (Amazon EC2) instance.

    * The template that deploys the Partner Solution into an existing VPC skips the components marked by asterisks and prompts you for your existing VPC configuration.

  •  How to deploy
  • To deploy this Partner Solution, follow the instructions in the deployment guide, which includes these steps.

    1. Sign in to your AWS account. If you don't have an account, sign up at
    2. Obtain a MemSQL license, or choose the Free Cloud Trial option on the MemSQL website.
    3. Launch the Partner Solution. The stack takes about 5–15 minutes to deploy. Before you create the stack, choose the AWS Region from the top toolbar. Choose one of the following options:

    Amazon may share user-deployment information with the AWS Partner that collaborated with AWS on this solution.  

  •  Costs and licenses
  • There are no licensing costs for using MemSQL up to 128 GB of RAM across four nodes. To request a free cloud trial, refer to the MemSQL website. If you need a cluster with more RAM, you can create an account and request an enterprise license. Fill out the form, and you will receive a license key via email.

    You are responsible for the cost of the AWS services and any third-party licenses used while running this solution. There is no additional cost for using the solution.

    This solution includes configuration parameters that you can customize. Some of these settings, such as instance type, affect the cost of deployment. For cost estimates, refer to the pricing pages for each AWS service you use. Prices are subject to change.

    Tip: After you deploy a solution, create AWS Cost and Usage Reports to track associated costs. These reports deliver billing metrics to an Amazon Simple Storage Service (Amazon S3) bucket in your account. They provide cost estimates based on usage throughout each month and aggregate the data at the end of the month. For more information, refer to What are AWS Cost and Usage Reports?