reference deployment

MemSQL on AWS

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 APN 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 5-15 minutes, depending on the number of instances chosen, and includes these steps:

    1. If you don't already have an AWS account, sign up at https://aws.amazon.com, and sign in to your account.
    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, we recommend that you enable the AWS Cost and Usage Report to track costs associated with the Quick Start. This report delivers billing metrics to an S3 bucket in your account. It provides cost estimates based on usage throughout each month, and finalizes the data at the end of the month. For more information about the report, see the AWS documentation.

    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.