Setup SingleStore DB Studio
SingleStore DB Studio allows you to easily monitor, debug, and interact with all of your clusters. This step shows you how to setup Studio on an existing host in your cluster.
Standalone installation and usage instructions for SingleStore DB Studio can also be found here.
Start SingleStore DB Studio
Because you downloaded and installed SingleStore DB Studio with the other SingleStore packages, you only need to start it.
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.
sudo singlestoredb-studio &
Add A New Cluster to SingleStore DB Studio
With SingleStore DB Studio running, go to
http://<main_deployment_host>:8080and click Add New Cluster to setup a cluster.Info
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.hcland restart Studio.
Paste the main deployment host IP address into Hostname.
Set Port to
rootas the Username.
Enter the Password you set for the master aggregator.
Click Create Cluster Profile and set Type as Development.
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.