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.
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
Please navigate back to this guide after you have launched the CloudFormation template for further instructions.
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
In the template, select a Key Name from the dropdown.
Paste in the MemSQL License key.
Enter a Password which you will use 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.
When you’re ready, scroll down and click Create. The deployment process will take four minutes.
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!
Set the Stack Name for your cluster.
Specify the Instance Type you want to use for the Aggregators and Leaf in your cluster. The default determined for you is
m4.2xlarge. This instance type for both the Aggregator and Leaf 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
1has been selected for you.
Select the Number of Leaves for your cluster. The default of
2has been selected for you.
Define a root password in MemSQL Password that will be shared across all of the nodes in your cluster.
Optional: If you want to enable High Availability, select
truefrom the drop-down list.
Manage MemSQL with MemSQL Studio
MemSQL Studio has a built-in client that can be used for running queries. In addition to deploying a cluster, the template also installs our management tool, MemSQL Studio, that allows you to immediately interact with your cluster. See the next step on how to start MemSQL Studio.