MemSQL Logo

Installation Instructions

To install MemSQL 7.0 Beta 2 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:7e98bd86-f9a9-4f41-86a2-bd76d583394b --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:7e98bd86-f9a9-4f41-86a2-bd76d583394b option wherever applicable so you get the 7.0 Beta 2 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 MemSQL Ops tarball.

    wget http://download.memsql.com/memsql-ops-6.7.8/memsql-ops-6.7.8.tar.gz
    tar zxvf memsql-ops-6.7.8.tar.gz
    cd memsql-ops-6.7.8
    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 6b319cdd26b21045067b2d6f3657a8712714bdbe --license $LICENSE
    
  3. Deploy a single leaf node.

    memsql-ops memsql-deploy --role leaf --port 3307 --version-hash 6b319cdd26b21045067b2d6f3657a8712714bdbe
    

For additional installation options, follow the instructions at https://docs.memsql.com/memsql-ops/v6.7/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 and from MemSQL 7.0 Beta 2 are not supported.
  • If you are running MySQL on the same machine you want to use to run MemSQL 7.0 Beta 2, 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.