Deploy a MemSQL Cluster min read


Using AWS CloudFormation is the easiest way to test out MemSQL in a clustered environment using your own AWS account. 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 up to four license units for the leaf nodes in your cluster. If you need a larger cluster with more/larger leaf nodes, 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. From a licensing perspective, you are not restricted on the size or number of aggregator nodes in your cluster; however, unless you have high amount of concurrent users, you should not need large instance sizes for your aggregators.

  • 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. A free tier license allows you to use up to four license units for the leaf nodes in your cluster. License units are calculated at the physical or virtual machine level and the m4.2xlarge will give you one license unit per EC2 instance.

  • 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, which allows you to immediately interact with your cluster.

See the next step on how to start MemSQL Studio.

Was this article useful?