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.6, see Upgrade to SingleStore DB 7.6.
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
With SingleStore DB Studio running, go to
http://localhost:8080on 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.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 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
With SingleStore DB Studio running, go to
http://localhost:8080on 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.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.