MemSQL Cluster Installation without sudo access

Help
3

Hello Madhu! Sorry you have hit this issue. We are actively building out a full installation guide which will address your needs for installation without sudo.

In the meantime, using toolbox with memsql-server without sudo is actually not too hard. Follow these steps to get started:

  1. Download the MemSQL Server tarball for the latest release. You can lookup the relative path on our release server at the following URL: https://release.memsql.com/production/index/memsqlserver/latest.json
    • look for the section memsql-server-tar in that document and append the Path attribute to the url release.memsql.com/ to download the latest tarball.
  2. Unpack the tarball on every host in your cluster wherever you want to install MemSQL
    • Make sure that the user you will SSH into the node owns the unpacked installation directory
    • It’s easiest if you unpack memsql-server into the same location on every host
  3. Create a directory on each host where you want MemSQL data to live, inside this directory add two files:
Name the first file "memsqlctl.hcl" with contents:
version = 1
user = "LINUX USER WHO SHOULD RUN MEMSQL"
defaultInstallDir = "PATH TO THIS DIRECTORY"

Name the second file "nodes.hcl" with contents:
version = 1
  1. Install toolbox on your command + control host. If you need to install toolbox without sudo you can get the latest tarball from a similar release url: https://release.memsql.com/production/index/memsqltoolbox/latest.json
  2. Register each host using memsql-toolbox-config register-host
    • IMPORTANT: specify the additional flags --memsqlctl-path and --memsqlctl-config-path
    • --memsqlctl-path should be an absolute path to the memsqlctl binary which was unpacked when you unpacked the memsql-server tarball
    • --memsqlctl-config-path should be an absolute path to the memsqlctl.hcl file you created on each host
  3. At this point you can run any memsql-admin command to operationalize your MemSQL Cluster.
    • some starting commands are create-node, add-leaf, bootstrap-aggregator, and add-aggregator
    • check memsql-admin --help for more
  4. NOTE: memsql-deploy commands currently will not work with this setup - we are making tarball installations first class as we speak which should be released in the next month or so. In the meantime this more manual installation process is the best option for running without sudo privileges.

Let us know if you run into any issues. We are working hard to make this particular experience much better.

Memsql Installation on different Port