Deploy a MemSQL Cluster min read


Using AWS CloudFormation is the easiest way to test out MemSQL in a clustered environment and connect it to our cluster management tool MemSQL Studio. In addition to deploying a cluster, the template also installs our management tool, MemSQL Studio, that allows you to immediately interact with your cluster. With the default CloudFormation configuration, you can use MemSQL on AWS for about $2.20 an hour.

Info

There are no licensing costs for using MemSQL up to 128 GB of RAM across your nodes. If you need a cluster with more RAM, please create an Enterprise License trial key.

Before You Begin

  • You must be logged in to AWS.

  • You must have the License key copied from the MemSQL Customer Portal.

  • You must have an existing Amazon EC2 key pair.

  • You must have an AWS account with permissions to create EC2 instances.

Start MemSQL Cluster

Info

Please navigate back to this guide after you have launched the CloudFormation template for further instructions.

  1. Select the type of MemSQL cluster to create on Amazon CloudFormation.

    Basic installation with ideal cluster configs set for you.

       Launch MemSQL Cluster

    Advanced installation for if you have an existing VPC with subnets and security groups.

       Launch MemSQL Cluster in Existing VPC
  2. In the template, select a Key Name from the dropdown.

  3. Paste in the MemSQL License key.

  4. Enter a MemSQL Password for the root database user. You will use this to login to Studio in the next step.

    Note: Confused about Advanced Configurations? The ideal cluster configurations have already been determined for you, so you can leave them as is.

  5. When you’re ready, scroll down and click Create. The deployment process will take four minutes.

    CREATE_COMPLETE The CloudFormation setup process takes around four minutes – refresh the page after this. When the Status in the CloudFormation dashboard changes to a green CREATE_COMPLETE, your instances will be provisioned with a MemSQL cluster!

  • Specify the Aggregator Instance Type you want to use for the Aggregators in your cluster. The default determined for you is m4.2xlarge. This instance type for both the Aggregator and Leaf, along with the default number of nodes specified in this template, will allow you to create a four-node 128 GB cluster with 128 GB RAM and 32 vCPU while only paying for AWS infrastructure costs.

  • Select the Number of Child Aggregators you want for your cluster. The default value of 1 has been selected for you.

  • Specify the Leaf Instance Type you want to use for the Leaves in your cluster. The default determined for you is m4.2xlarge.

  • Select the Number of Leaves for your cluster. The default of 2 has been selected for you.

  • Optional: The default is to enable High Availability on your cluster; however, if you want to disable high availability, select false from the drop-down list.

  • Optional: Enter an Availability Zone if you have one that you would like to use for your cluster.

  • Optional: Enter a CIDR range in CIDR Range for Remote Access if you want to restrict which IP addresses can connect to your cluster or access MemSQL Studio.

Interact with Your Cluster

MemSQL Studio

In addition to deploying a cluster, the template also installs our monitoring and debugging tool, MemSQL Studio, that allows you to immediately interact with your cluster.

See the next step on how to start MemSQL Studio.

Was this article useful?