SingleStore DB

Access the Built-in SingleStore Tools

Every singlestore/cluster-in-a-box container also contains the SingleStore Tools needed to perform cluster operations.

To access these tools, you must connect directly to a running container using docker exec as shown below:

docker exec -it singlestore-ciab /bin/bash

Once connected, you can run any of the SingleStore Tools; however, because the Master Aggregator and leaf node share the same container (and thus the same host machine), memsqlctl was used to setup and configure the cluster. If the deployment was across multiple host machines, then the higher-level tools such as sdb-admin and sdb-deploy would have been used instead.

The following will show you how to retrieve all of the nodes in the container:

memsqlctl list-nodes
****
+------------+--------+------+---------------+--------------+---------+----------------+--------------------+
| MemSQL ID  |  Role  | Port | Process State | Connectable? | Version | Recovery State | Availability Group |
+------------+--------+------+---------------+--------------+---------+----------------+--------------------+
| F7C4D853E0 | Master | 3306 | Running       | True         | 6.7.1   | Online         |                    |
| 77BCA7CC40 | Leaf   | 3307 | Running       | True         | 6.7.1   | Online         | 1                  |
+------------+--------+------+---------------+--------------+---------+----------------+--------------------+