Quick Start on Azure Marketplace¶
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.
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.
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.
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.
4: Confirm and launch¶
On these screens you can review and confirm your settings.
Click “Buy” and then click “Create”.
Your MemSQL instance will launch. By default it will have an icon on your Azure startboard.
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>
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.