MemSQL Logo

Installation Instructions

To install MemSQL 7.0 Beta 3 on a single server, connected to the internet, starting with a clean Linux installation, do the following.

Using MemSQL Tools

  1. Install our deployment tool, memsql-deploy by following the instructions at https://docs.memsql.com/guides/latest/install-memsql/on-premises/multi-host/comprehensive/step-2/.

  2. Deploy a master aggregator and a single leaf node using:

    memsql-deploy cluster-in-a-box --version dev:6edcec8f-43bb-4533-81e4-d0cf11eaa9eb --license $LICENSE
    

    Replace $LICENSE with your existing MemSQL license key. If you don't already have a license, visit our portal, create an account if you don't have one, create a free license, and use that.

  3. (Optional) MemSQL Studio is also installed as part of step 1. To use it, follow the instructions at: https://docs.memsql.com/guides/latest/install-memsql/on-premises/multi-host/comprehensive/step-4/

For a custom installation, on any number of nodes, follow the instructions at https://docs.memsql.com/guides/latest/install-memsql. However, be sure to use the --version dev:6edcec8f-43bb-4533-81e4-d0cf11eaa9eb option wherever applicable so you get the 7.0 Beta 3 version. This will be required when using memsql-deploy cluster-in-a-box, memsql-deploy setup-cluster, or memsql-deploy install.

Using MemSQL Ops

  1. Download and install the latest MemSQL Ops tarball.

    wget http://download.memsql.com/memsql-ops-6.8.0/memsql-ops-6.8.0.tar.gz
    tar zxvf memsql-ops-6.8.0.tar.gz
    cd memsql-ops-6.8.0
    sudo ./install.sh -n
    
  2. Deploy a master aggregator first. Replace $LICENSE with your existing MemSQL Enterprise license key or use the --developer-edition flag if you do not have an Enterprise license.

    memsql-ops memsql-deploy --role master --port 3306 --version-hash 438fbe8195426ef9dfac3b03a12ede89f0335ca5 --license $LICENSE
    
  3. Deploy a single leaf node.

    memsql-ops memsql-deploy --role leaf --port 3307 --version-hash 438fbe8195426ef9dfac3b03a12ede89f0335ca5
    

For additional installation options, follow the instructions at https://docs.memsql.com/latest/tools/memsql-ops/full-installation-guide. Note: Because you are installing a specific build of MemSQL, you must install it using the command-line install path, rather than through the MemSQL Ops UI, as shown above.

Notes

  • Upgrades to MemSQL 7.0 Beta 3 are not supported; however you can upgrade from this version to future versions of MemSQL.
  • If you are running MySQL on the same machine you want to use to run MemSQL 7.0 Beta 3, you may need to run a custom installation rather than the cluster-in-a-box deployment because MySQL may occupy port 3306. You can specify the desired ports for your nodes explicitly during a custom installation.