SingleStoreDB Studio Upgrade
Important
Studio is designed to work with MemSQL 6.5 or later and is only supported on Chrome and Firefox browsers at this time.
Upgrading Studio can be done through the package manager on the computer, instance, or container where Studio is installed.
Important
Note that upgrading Studio does not automatically upgrade the database engine. To upgrade the database engine, see Upgrade SingleStoreDB.
To upgrade the database engine to version 7.3, see Upgrade to SingleStoreDB 7.3.
To update the singlestoredb-studio package with YUM, run the following:
sudo yum update singlestoredb-studio
Set up SingleStoreDB Studio
Start 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 Studio service to start 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 Studio directly.
sudo singlestoredb-studio &
Studio will now run the Studio web server on port 8080.
Add a New Cluster to Studio
With Studio running, go to
http://localhost:8080on your local machine and click Add New Cluster to setup a cluster.Important
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 Master Aggregator host machine IP address into Hostname.
Set Port to the master aggregator database port for your cluster. The default is
3306.Specify a valid database user in Username.
Enter the Password for your database user.
Click Create Cluster Profile and set Type to describe your cluster: Development, Staging, or Production.
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.
To update the
singlestoredb-studiopackage 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
Update the
singlestoredb-studiopackage.sudo apt install singlestoredb-studio
Set up SingleStoreDB Studio
Start 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 Studio service to start 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 Studio directly.
sudo singlestoredb-studio &
Studio will now run the Studio web server on port 8080.
Add a New Cluster to Studio
With Studio running, go to
http://localhost:8080on your local machine and click Add New Cluster to setup a cluster.Important
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 Master Aggregator host machine IP address into Hostname.
Set Port to the master aggregator database port for your cluster. The default is
3306.Specify a valid database user in Username.
Enter the Password for your database user.
Click Create Cluster Profile and set Type to describe your cluster: Development, Staging, or Production.
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.