MemSQL Studio Installation Guide

Info

MemSQL Studio is designed to work with MemSQL 6.5 or later and is only supported on Chrome and Firefox browsers at this time.

Installing MemSQL Studio can be done easily through the popular package managers on Debian and Red Hat-based distributions. This allows you to utilize existing workflows when installing and upgrading your Studio package.

Installing on Red Hat-based distributions

  1. Add the MemSQL repository to your repository list. MemSQL packages are signed to ensure integrity, so the signing key will be added to this machine.

    sudo yum-config-manager \
    --add-repo https://release.memsql.com/production/rpm/x86_64/repodata/memsql.repo
    
  2. Verify that the MemSQL repo information is listed under repolist.

    sudo yum repolist
    
  3. Run yum install memsql-studio to install the latest Studio package.

    Note: If your Debian-based OS does not have apt-transport-https installed, you will have to install it before running apt update.

    sudo yum install memsql-studio
    

    You have now successfully installed MemSQL Studio on this machine!

  4. Start the memsql-studio systemd service using the systemctl start command.

    sudo systemctl start memsql-studio
    

    If your Linux distribution does not use systemd, you can run MemSQL Studio directly.

    sudo memsql-studio &
    

    MemSQL Studio will now run the Studio web server on port 8080.

  5. Go to http://localhost:8080 on your local machine and click Add New Cluster to begin using Studio.

To run Studio on a different port, add port = <port_name> to /etc/memsql/memsql-studio.hcl and restart Studio with systemctl restart memsql-studio.

Installing on Debian-based distributions

  1. MemSQL packages are signed to ensure integrity, so the GPG key needs to be added to this machine. When done, verify that the MemSQL signing key has been added using apt-key list.

    wget -O - 'https://release.memsql.com/release-aug2018.gpg'  2>/dev/null | sudo apt-key add - && apt-key list
    
  2. Verify you have apt-transport-https installed.

    apt-cache policy apt-transport-https
    

    If apt-transport-https is not installed, you must install it before proceding.

    sudo apt -y install apt-transport-https
    
  3. Add the MemSQL repository to retrieve its packages.

    echo "deb https://release.memsql.com/production/debian memsql main" | sudo tee /etc/apt/sources.list.d/memsql.list
    
  4. After verifying the MemSQL repo information is listed in the output, install the latest Studio package.

    sudo apt update && sudo apt -y install memsql-studio
    

    You have now successfully installed MemSQL Studio on this machine!

  5. Start the memsql-studio systemd service using the systemctl start command.

    sudo systemctl start memsql-studio
    

    If your Linux distribution does not use systemd, you can run MemSQL Studio by calling it directly.

    sudo memsql-studio &
    

    MemSQL Studio will now run the Studio web server on port 8080.

  6. Go to http://localhost:8080 on your local machine and click Add New Cluster to begin using Studio.

To run Studio on a different port, add port = <port_name> to /etc/memsql/memsql-studio.hcl and restart Studio with systemctl restart memsql-studio.

Was this article useful?