MemSQL Studio allows you to easily monitor, debug, and interact with all of your MemSQL clusters. This step shows you how to set up Studio on an existing host in your cluster.
Stand-alone installation and usage instructions for MemSQL Studio can also be found here.
Start MemSQL Studio
MemSQL Studio is only supported on Chrome and Firefox browsers at this time.
SSH into your main deployment host and run the following:
sudo systemctl start memsql-studio
If your Linux distribution does not use
systemd, you can run MemSQL Studio directly instead.
sudo memsql-studio &
SSH into your main deployment host and perform the following:
Change to the
memsql-studio-<version>directory where you unpacked MemSQL Studio.
Start MemSQL Studio from the command line. Use
memsql-studiofrom terminating when you close your terminal session.
nohup ./memsql-studio > studio.stdout 2> studio.stderr < /dev/null &
Add A New Cluster to MemSQL Studio
With MemSQL Studio running, go to
http://<main_deployment_host>:8080and click Add New Cluster to set up a cluster.
To run Studio on a different port, add
port = <port_name>to
/etc/memsql/memsql-studio.hcland restart Studio.
Paste the main deployment host IP address into Hostname.
Set Port to
rootas the Username and leave Password empty.
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.