SingleStore DB

Interact with your Cluster

Start Studio

On your main deployment host, run the following command to use SingleStore DB Studio to monitor and interact with your cluster.

Package-based Deployments

Enable the SingleStore DB Studio service to start SingleStore DB Studio at system boot (recommended).

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

SSH into your main deployment host and run the following:

sudo systemctl start singlestoredb-studio

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

sudo singlestoredb-studio &

Tarball-based Deployments

  1. Change to the directory where the SingleStore DB Toolbox was uncompressed.

  2. Start SingleStore DB Studio. Use nohup to prevent Studio from terminating when you close your terminal session.

    nohup ./singlestoredb-studio > studio.stdout 2> studio.stderr < /dev/null &

Access Studio

The Studio Web server will now be running on port 8080, which can be accessed via Web browser at http://<main-deployment-host>:8080.

Add A New Cluster to SingleStore DB Studio
  1. With SingleStore DB Studio running, go to http://<main_deployment_host>:8080 and click Add New Cluster to set up 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 main deployment host IP address into Hostname.

  3. Set Port to 3306.

  4. Specify root as the Username.

  5. In the Password field, provide the Superuser password that was set during cluster deployment via sdb-deploy ui.

  6. Click Create Cluster Profile and set Type as Development.

  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.