Quick Start on AWS Marketplace

Warning

This documentation does not reflect the latest version of MemSQL.
This page refers to MemSQL 4.0.

For the latest MemSQL product documentation, visit http://docs.memsql.com/latest.

Launching a single-instance cluster on Amazon AWS Marketplace is simple and fast.

1: Choose Community or Enterprise Edition

There are two editions available on the marketplace: Community and Enterprise. Both are “cluster in a box” configurations, including all the components of a MemSQL cluster on a single virtual machine.

MemSQL Community Edition has no software charges and comes with community support. Enterprise Edition is priced by system RAM, on an hourly basis, and comes with enterprise features such as replication for high availability, and phone and email support.

2: Launch with 1-Click

You can go immediately from here to “1-Click” launching with the default settings. By default MemSQL will launch on an m3.2xlarge instance (4 CPU cores and 15GB of RAM), with access to ports 22 (ssh) and 80 (MemSQL Ops UI) open, and the first SSH key on your list. It will launch into your default AWS region, for example “US East (N. Virgina)”.

Once the instance is provisioned, you can access the MemSQL Ops UI in your browser, using the IP address or public DNS name of your instance. The Ops UI user is “memsql” and the password is the AWS instance ID. You can find the instance ID in your EC2 console.

http://<your-instance-ip>

user: memsql
password: <instance-id>

Note

The default port for MemSQL Ops is 9000. However, in the AWS marketplace image of MemSQL, it is configured to listen on port 80, the default HTTP port.

To connect to the MemSQL database with a MySQL-compatible client from a different machine, make sure to open port 3306 in your Security Group. The default MemSQL user is “root”, and the password is the AWS instance ID. You can find the instance ID in your EC2 console. See also How to Connect to MemSQL.

Optional Settings

Below are instructions for changing the default settings on your instance via the Marketplace.

Choose Region and Instance Type

AWS has several regions throughout the world. The instance types available vary by region. We recommmend the m3 or m4.2xlarge instance for good price/performance. For larger RAM capacity, the R series has a higher ratio of RAM to CPUs. For columnar workloads, the I and D series come with ample disk storage.

Note

Some newer instance types such as the m4 series are not available under “EC2 Classic” networking, and require a virtual private cloud (VPC) and subnet to launch into.

Choose Security Group

By default MemSQL launches with port 22 (ssh) and 80 (MemSQL Ops) open. The MySQL protocol port 3306 is not publicly accessible. You can choose one of your own security groups, or manually edit the default settings.

Choose a Keypair

By default, your marketplace image will launch into your first keypair in the region, sorted alphabetically. You can choose a new keypair to use from the dropdown list. Make sure you have the private key, otherwise you will not be able to access your image via SSH.

Launch Instance

Click the “Launch with 1-Click” button. Once the instance is provisioned, you can access the MemSQL Ops UI in your browser, using the IP address or public DNS name of your instance. The Ops UI user is “memsql” and the password is the AWS instance ID. You can find the instance ID in your EC2 console.

http://<your-instance-ip>

user: memsql
password: <instance-id>

Note

The default port for MemSQL Ops is 9000. However, in the AWS marketplace image of MemSQL, it is configured to listen on port 80, the default HTTP port.

To connect to the MemSQL database with a MySQL-compatible client from a different machine, make sure to open port 3306 in your Security Group. The default MemSQL user is “root” and the password is the AWS instance ID. See also How to Connect to MemSQL.