The user that deploys MemSQL via MemSQL Toolbox must be able to SSH to each host in the cluster. When memsql-server is installed via an RPM or Debian package when deploying MemSQL, a memsql user and group are also created on each host in the cluster.
This memsql user does not have a shell, and attempting to log in or SSH as this user will fail. The user that deploys MemSQL is added to the memsql group. This group allows most Toolbox commands to run without sudo privileges, and members of this group can perform many Toolbox operations without the need to escalate to sudo. Users who desire to run MemSQL Toolbox commands must be added to the memsql group on each host in the cluster. They must also be able to SSH to each host.
Manually creating a memsql user and group is only recommended in a sudo-less environment when performing a tarball-baed deployment of MemSQL. In order to run MemSQL Toolbox commands against a cluster, this manually-created memsql user must be configured so that it can SSH to each host in the cluster.
Now you can deploy your MemSQL cluster on a single machine using the memsql-deploy cluster-in-a-box command. This command will create 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.
If you wish to deploy a cluster with more nodes, follow the steps in the multi-host installation guides.
memsql-deploy cluster-in-a-box --license <license> \
--version 6.7 --password <secure-password>
Note: If your license key is not shown in the code block above, you can retrieve it from the MemSQL Customer Portal.
If your host machine does not have the which command available, you will need to specify the correct package through the --force-package-format {rpm|deb} flag when running the cluster-in-a-box command.
If you are deploying in an environment with no Internet access, you must specify the absolute path to the memsql-server RPM or Debian package you downloaded in the previous step.
memsql-deploy cluster-in-a-box --license <license> \
--file-path <memsql-server-package> \
--password <secure-password>
Once your MemSQL cluster is up and running, you can connect to it using the memsql client application. Refer to memsql-client for more information.
In addition, you can use MemSQL Studio to easily monitor, debug, and interact with all of your MemSQL clusters. See the next step for how to connect and use MemSQL Studio.
