SingleStore DB

SingleStore DB Studio Upgrade

Important

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

Upgrading SingleStore DB Studio can be done through the package manager on the computer, instance, or container where SingleStore DB Studio is installed.

Important

Note that upgrading SingleStore DB Studio does not automatically upgrade the database engine. To upgrade the database engine, see Upgrade SingleStore DB.

To upgrade the database engine to version 7.5, see ???.

To update the singlestoredb-studio package with YUM, run the following:

sudo yum update singlestoredb-studio
Set up SingleStore DB Studio
Start SingleStore DB Studio

Now that you have Studio installed, start the singlestoredb-studio systemd service using the systemctl start command.

sudo systemctl start singlestoredb-studio

Recommended: Enable the SingleStore DB Studio service to start SingleStore DB Studio at system boot.

sudo systemctl enable singlestoredb-studio.service
****
Created symlink /etc/systemd/system/multi-user.target.wants/memsql-studio.service → /lib/systemd/system/memsql-studio.service.

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

sudo singlestoredb-studio &

SingleStore DB Studio will now run the Studio web server on port 8080.

Add a New Cluster to SingleStore DB Studio
  1. With SingleStore DB Studio running, go to http://localhost:8080 on your local machine and click Add New Cluster to setup a cluster.

    Important

    SingleStore DB Studio is only supported on Chrome and Firefox browsers at this time.

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

  2. Paste the Master Aggregator host machine IP address into Hostname.

  3. Set Port to the master aggregator database port for your cluster. The default is 3306.

  4. Specify a valid database user in Username.

  5. Enter the Password for your database user.

  6. Click Create Cluster Profile and set Type to describe your cluster: Development, Staging, or Production.

  7. Fill in Cluster Name and Description to your preference.

After you have successfully logged in, you will see the dashboard for your cluster. To run a query against your cluster, navigate to the SQL Editor through the navigation in the left pane.

  1. To update the singlestoredb-studio package with APT, update the package lists for packages that need upgrading, as well as new packages that have just come to the repositories.

    sudo apt update
  2. Update the singlestoredb-studio package.

    sudo apt install singlestoredb-studio
Set up SingleStore DB Studio
Start SingleStore DB Studio

Now that you have Studio installed, start the singlestoredb-studio systemd service using the systemctl start command.

sudo systemctl start singlestoredb-studio

Recommended: Enable the SingleStore DB Studio service to start SingleStore DB Studio at system boot.

sudo systemctl enable singlestoredb-studio.service
****
Created symlink /etc/systemd/system/multi-user.target.wants/memsql-studio.service → /lib/systemd/system/memsql-studio.service.

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

sudo singlestoredb-studio &

SingleStore DB Studio will now run the Studio web server on port 8080.

Add a New Cluster to SingleStore DB Studio
  1. With SingleStore DB Studio running, go to http://localhost:8080 on your local machine and click Add New Cluster to setup a cluster.

    Important

    SingleStore DB Studio is only supported on Chrome and Firefox browsers at this time.

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

  2. Paste the Master Aggregator host machine IP address into Hostname.

  3. Set Port to the master aggregator database port for your cluster. The default is 3306.

  4. Specify a valid database user in Username.

  5. Enter the Password for your database user.

  6. Click Create Cluster Profile and set Type to describe your cluster: Development, Staging, or Production.

  7. Fill in Cluster Name and Description to your preference.

After you have successfully logged in, you will see the dashboard for your cluster. To run a query against your cluster, navigate to the SQL Editor through the navigation in the left pane.