Quick Start on Azure 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 Microsoft Azure Store is simple and fast.

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.

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.

../../_images/azure-store-01.png

1: Choose region, Azure subscription, and credentials

On the first screen, enter the Unix account name and password (or SSH key). This user cannot be an existing account like “root”. Azure accounts may have multiple subscriptions, each with their own payment details and quotas. Make sure the one chosen is correct. On this screen you can also choose which Azure region (eg East US, West US) to launch into.

../../_images/azure-store-02.png

2: Choose an instance size

There are a large number of virtual machine sizes to choose from. The D13 offers good price / performance, as does the premium storage version, the DS13. Click here for more information on Azure instances.

../../_images/azure-store-03.png

Note

MemSQL requires at least 4 CPU cores and 8GB of RAM to function. See Hardware Requirements for more details.

3: Configure optional settings

On this screen you can change optional network, storage, and monitoring settings.

../../_images/azure-store-04.png

4: Confirm and launch

On these screens you can review and confirm your settings.

../../_images/azure-store-05.png

Click “Buy” and then click “Create”.

../../_images/azure-store-06.png

Your MemSQL instance will launch. By default it will have an icon on your Azure startboard.

../../_images/azure-store-07.png

5: Connect

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 on port 9000. 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>:9000

user: memsql
password: <instance-id>

Note

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