Scalable database for operational analytics

This Quick Start deploys MemSQL, a distributed, highly scalable structured query language (SQL) database, on 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 Quick Start 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 Quick Start was developed by MemSQL Inc.
in collaboration with AWS. MemSQL
is an AWS Partner.

  •  What you'll build
  •  How to deploy
  •  Cost and licenses
  •  What you'll build
  • Use this Quick Start 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 Quick Start into an existing VPC skips the components marked by asterisks and prompts you for your existing VPC configuration.

  •  How to deploy
  • To deploy MemSQL on AWS, follow the instructions in the deployment guide. The deployment process takes about 5–15 minutes, depending on the number of instances chosen, and includes these steps:

    1. Sign in to your AWS account. If you don't have an account, sign up at https://aws.amazon.com.
    2. Obtain a MemSQL license or choose the Free Cloud Trial option on the MemSQL website.
    3. Launch the Quick Start. You can choose from the following two options:

    Amazon may share user-deployment information with the AWS Partner that collaborated with AWS on the Quick Start.  

  •  Cost and licenses
  • You are responsible for the cost of the AWS services used while running this Quick Start reference deployment. There is no additional cost for using the Quick Start.

    The AWS CloudFormation template for this Quick Start includes configuration parameters that you can customize. Some of these settings, such as instance type, will affect the cost of deployment. For cost estimates, see the pricing pages for each AWS service you will be using. Prices are subject to change.

    Tip: After you deploy the Quick Start, create  AWS Cost and Usage Reports to track costs associated with the Quick Start. 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 about the report, see  What are AWS Cost and Usage Reports?

    There are no licensing costs for using MemSQL up to 128 GB of RAM across four nodes. To request a Free Cloud Trial, visit 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 in email.