cluster-in-a-box image contains two nodes: A master aggregator node that runs SQL queries and aggregates the results, and a single leaf node, which is responsible for storing and processing data. These two nodes form the most basic MemSQL cluster.
Start the Container
Export your license key into an environment variable named
LICENSE_KEY. If your license key is not shown in the code block below, you can copy it from the MemSQL Customer Portal.
export LICENSE_KEY=[YOUR LICENSE KEY]
$env:LICENSE_KEY = "[YOUR LICENSE KEY]"
Initialize the cluster using
docker run. Note: If you want to preserve data across an upgrade of the Docker container, put
memsql/cluster-in-a-boxin the command below.
docker run -i --init \ --name memsql-ciab \ -e LICENSE_KEY=$LICENSE_KEY \ -p 3306:3306 -p 8080:8080 \ memsql/cluster-in-a-box
docker run -i --init ` --name memsql-ciab ` -e LICENSE_KEY=$env:LICENSE_KEY ` -p 3306:3306 -p 8080:8080 ` memsql/cluster-in-a-box
If initialization fails, you will need to remove the container before retrying.
docker rm memsql-ciab
Start the container.
docker start memsql-ciab
Now that you have MemSQL up and running, learn how to connect to your cluster in the next step.