SingleStore DB

Start SingleStore DB Studio

Now that SingleStore DB is running in Docker, open a browser to http://localhost:8080 to launch SingleStore DB Studio. Click on the local cluster, enter a username of root, leave the password blank, and log in.

On this main dashboard screen, you can see the health of the cluster. Note that this is a two-node cluster. Clicking on Nodes on the left, you see one node is a leaf node, one is an aggregator node, and they’re both running in the same container. In production, you would want more machines running together to support production-level workloads and to provide high availability.

Click on the SQL Editor page. Copy and paste the following set of commands into the Query window. Then, highlight each individual command and click the Execute button in the top-right to run it. Continue to highlight and execute each command until all commands have been executed.

CREATE DATABASE mytest;

USE mytest;

CREATE TABLE test (
  message text NOT NULL
);

INSERT INTO test (message) VALUES ('this is a sample message');

SELECT * FROM test;

For more details on SingleStore DB Studio, check out the documentation.