# SingleStore Tools

**URL:** https://www.singlestore.com/forum/c/toolbox/17.md

[Latest](https://www.singlestore.com/forum/latest.md) · [Categories](https://www.singlestore.com/forum/categories.md) · [Tags](https://www.singlestore.com/forum/tags.md)

---

## [About the SingleStore Tools category](https://www.singlestore.com/forum/t/about-the-singlestore-tools-category/46)

<div class="topic-metadata">

**Author:** [@memsqlpubs](https://www.singlestore.com/forum/u/memsqlpubs)\
**Replies:** 3\
**Last updated:** [June 7, 2022, 7:44am UTC](https://www.singlestore.com/forum/t/about-the-singlestore-tools-category/46 "2022-06-07T07:44:37Z")

</div>

Interested in learning more about our SingleStore DB Toolbox package? (sdb-toolbox-config, sdb-deploy, sdb-admin, sdb-report or memsqlctl). This category is for discussing 1st-party cluster management tools. Ask questi…

---

## [Kubernetes SingleStore Operator: Leaf nodes stuck in "not part of cluster" loop, can't join](https://www.singlestore.com/forum/t/kubernetes-singlestore-operator-leaf-nodes-stuck-in-not-part-of-cluster-loop-cant-join/8360)

<div class="topic-metadata">

**Author:** [@twu](https://www.singlestore.com/forum/u/twu)\
**Replies:** 1\
**Last updated:** [August 26, 2025, 8:58am UTC](https://www.singlestore.com/forum/t/kubernetes-singlestore-operator-leaf-nodes-stuck-in-not-part-of-cluster-loop-cant-join/8360 "2025-08-26T08:58:25Z")

</div>

I’m deploying SingleStore on GKE using the Kubernetes operator, but leaf nodes are stuck in a bootstrap loop and won’t join the cluster. The master aggregator starts successfully, but leaves fail to join and keep showing…

---

## [Deploying SingleStore via CLI](https://www.singlestore.com/forum/t/deploying-singlestore-via-cli/7628)

<div class="topic-metadata">

**Author:** [@heychazza](https://www.singlestore.com/forum/u/heychazza)\
**Replies:** 3\
**Last updated:** [February 2, 2025, 11:40am UTC](https://www.singlestore.com/forum/t/deploying-singlestore-via-cli/7628 "2025-02-02T11:40:46Z")

</div>

Hey folks, I’ve been working on a deployment script both for internal use, and as a public project to help folks installing SingleStore. Currently I’ve gone through the setup of installing it through the UI, but I’d li…

---

## [View Monitoring Data from Multiple Clusters on Grafana dashboard](https://www.singlestore.com/forum/t/view-monitoring-data-from-multiple-clusters-on-grafana-dashboard/7858)

<div class="topic-metadata">

**Author:** [@thanh.nguyen](https://www.singlestore.com/forum/u/thanh.nguyen)\
**Replies:** 2\
**Last updated:** [August 15, 2024, 4:11am UTC](https://www.singlestore.com/forum/t/view-monitoring-data-from-multiple-clusters-on-grafana-dashboard/7858 "2024-08-15T04:11:52Z")

</div>

I set up metrics database with multiple monitored source. According to this Connect Data Visualization Tools · SingleStore Documentation I can: Name each Source cluster to allow Grafana to identify the cluster. For mor…

---

## [Pipeline DDL and Dynamic Filename as input](https://www.singlestore.com/forum/t/pipeline-ddl-and-dynamic-filename-as-input/6455)

<div class="topic-metadata">

**Author:** [@prathap\_26](https://www.singlestore.com/forum/u/prathap_26)\
**Replies:** 6\
**Last updated:** [July 24, 2024, 6:22pm UTC](https://www.singlestore.com/forum/t/pipeline-ddl-and-dynamic-filename-as-input/6455 "2024-07-24T18:22:59Z")

</div>

Hi Team, Whenever we need to add a new column or modify the column in the pipeline, we have to Open the PIPELINE DDL, do the required changes Drop the pipeline or replace the pipeline with create or replace command We…

---

## [Average\_Roundtrip\_Latency\_ms going to very high value in 1 sec](https://www.singlestore.com/forum/t/average-roundtrip-latency-ms-going-to-very-high-value-in-1-sec/7562)

<div class="topic-metadata">

**Author:** [@ann.minnu](https://www.singlestore.com/forum/u/ann.minnu)\
**Replies:** 4\
**Last updated:** [June 24, 2024, 7:00pm UTC](https://www.singlestore.com/forum/t/average-roundtrip-latency-ms-going-to-very-high-value-in-1-sec/7562 "2024-06-24T19:00:52Z")

</div>

The Average\_Roundtrip\_Latency\_ms in show leaves output is going to a 13 digit value in just 1 second gap. memsql version : 8.1.7 There is no latency observed between the servers , ie, master aggregator and leaf nodes. …

---

## [Change / alter studio.log location](https://www.singlestore.com/forum/t/change-alter-studio-log-location/7690)

<div class="topic-metadata">

**Author:** [@muhammadosama.hassan](https://www.singlestore.com/forum/u/muhammadosama.hassan)\
**Replies:** 0\
**Last updated:** [May 14, 2024, 9:21am UTC](https://www.singlestore.com/forum/t/change-alter-studio-log-location/7690 "2024-05-14T09:21:34Z")

</div>

stop the studio services and locate the file " singlestoredb-studio.hcl " and change the log path variable to desired location. create a file with touch command in that directory and make sure the permission of the files…

---

## [Can I use an external storage as primary storage for SingleStore](https://www.singlestore.com/forum/t/can-i-use-an-external-storage-as-primary-storage-for-singlestore/7591)

<div class="topic-metadata">

**Author:** [@developer](https://www.singlestore.com/forum/u/developer)\
**Replies:** 2\
**Last updated:** [April 29, 2024, 10:36am UTC](https://www.singlestore.com/forum/t/can-i-use-an-external-storage-as-primary-storage-for-singlestore/7591 "2024-04-29T10:36:41Z")

</div>

As per docs: There’s unlimited storage access available for SingleStore in Standard edition. How can this be used? When I try to attach an unlimited storage, it asks me to get premium license.

---

## [Create cluster nodes concurrently using sdb-toolbox FAILS](https://www.singlestore.com/forum/t/create-cluster-nodes-concurrently-using-sdb-toolbox-fails/6745)

<div class="topic-metadata">

**Author:** [@wissem](https://www.singlestore.com/forum/u/wissem)\
**Replies:** 1\
**Last updated:** [April 12, 2024, 5:39pm UTC](https://www.singlestore.com/forum/t/create-cluster-nodes-concurrently-using-sdb-toolbox-fails/6745 "2024-04-12T17:39:56Z")

</div>

Hi All, I’ve build an automation to deploy SingleStore clsuter on 2 steps 1 - create nodes 2 - add nodes to cluster the automation is event driven, and creating nodes is done concurrently however this is causing a tr…

---

## [After upgrade from 7.2 to 8.2 we get Slave packet read (332) failed with error 104 (Connection reset by peer) while in state x\_streaming](https://www.singlestore.com/forum/t/after-upgrade-from-7-2-to-8-2-we-get-slave-packet-read-332-failed-with-error-104-connection-reset-by-peer-while-in-state-x-streaming/7213)

<div class="topic-metadata">

**Author:** [@moralez.rodrigo](https://www.singlestore.com/forum/u/moralez.rodrigo)\
**Replies:** 1\
**Last updated:** [April 10, 2024, 4:21pm UTC](https://www.singlestore.com/forum/t/after-upgrade-from-7-2-to-8-2-we-get-slave-packet-read-332-failed-with-error-104-connection-reset-by-peer-while-in-state-x-streaming/7213 "2024-04-10T16:21:53Z")

</div>

after upgrade from 7.2 to 8.2 we get Slave packet read (332) failed with error 104 (Connection reset by peer) while in state x\_streaming And the master aggregator enters to recovering every 5 minutes and kiils all the c…

---

## [Hide or invisible column](https://www.singlestore.com/forum/t/hide-or-invisible-column/6418)

<div class="topic-metadata">

**Author:** [@prathap\_26](https://www.singlestore.com/forum/u/prathap_26)\
**Replies:** 4\
**Last updated:** [August 5, 2023, 2:12am UTC](https://www.singlestore.com/forum/t/hide-or-invisible-column/6418 "2023-08-05T02:12:23Z")

</div>

Hi Team, We have the requirement to create table with one of the columns in HIDDEN/INVISIBLE state. I am not able to create table by specifing HIDDEN/INVISIBLE. CREATE TABLE T1) ID INT, FNAME VARCHAR(55), SSN VARCH…

---

## [Tool or function to convert rowstore DDL to Columnstore and Vice Versa](https://www.singlestore.com/forum/t/tool-or-function-to-convert-rowstore-ddl-to-columnstore-and-vice-versa/4397)

<div class="topic-metadata">

**Author:** [@vasanth.ramu](https://www.singlestore.com/forum/u/vasanth.ramu)\
**Replies:** 4\
**Last updated:** [August 2, 2023, 12:19am UTC](https://www.singlestore.com/forum/t/tool-or-function-to-convert-rowstore-ddl-to-columnstore-and-vice-versa/4397 "2023-08-02T00:19:56Z")

</div>

Is there any tool that can convert a rowstore DDL to columnstore DDL and vice versa. If we get a function to convert the DDL and migrate the data as well, it would be great.

---

## [Flyway Support for SingleStoreDB](https://www.singlestore.com/forum/t/flyway-support-for-singlestoredb/4409)

<div class="topic-metadata">

**Author:** [@shushu](https://www.singlestore.com/forum/u/shushu)\
**Replies:** 3\
**Last updated:** [February 24, 2023, 3:04pm UTC](https://www.singlestore.com/forum/t/flyway-support-for-singlestoredb/4409 "2023-02-24T15:04:57Z")

</div>

Hi, We are currently migrating from mysqldb to singlestore. We are using flyway in order to have versioned automated db migrations. Flyway does not work out of the box with singlestore/memsql, but it does support addi…

---

## [Could not perform remote backup or restore. MissingAuthenticationToken: Request is missing Authentication Token](https://www.singlestore.com/forum/t/could-not-perform-remote-backup-or-restore-missingauthenticationtoken-request-is-missing-authentication-token/6524)

<div class="topic-metadata">

**Author:** [@santo](https://www.singlestore.com/forum/u/santo)\
**Replies:** 0\
**Last updated:** [February 13, 2023, 4:18pm UTC](https://www.singlestore.com/forum/t/could-not-perform-remote-backup-or-restore-missingauthenticationtoken-request-is-missing-authentication-token/6524 "2023-02-13T16:18:02Z")

</div>

Hi guys, we are trying to perform backups to S3 following your documentation and having some troubles to achieve it. The error we are getting is: Could not perform remote backup or restore. MissingAuthenticationToken…

---

## [Single SingleStore Studio to manage Mutiple instance](https://www.singlestore.com/forum/t/single-singlestore-studio-to-manage-mutiple-instance/6176)

<div class="topic-metadata">

**Author:** [@timothy.yu](https://www.singlestore.com/forum/u/timothy.yu)\
**Replies:** 0\
**Last updated:** [November 11, 2022, 1:12am UTC](https://www.singlestore.com/forum/t/single-singlestore-studio-to-manage-mutiple-instance/6176 "2022-11-11T01:12:16Z")

</div>

hi All Can I use Single SingleStore Studio (Web portal) to manage Mutiple instance? Thanks Note: They are not in cluster

---

## [Memsql-ops agent-ssh equivalent](https://www.singlestore.com/forum/t/memsql-ops-agent-ssh-equivalent/5855)

<div class="topic-metadata">

**Author:** [@thanh.nguyen](https://www.singlestore.com/forum/u/thanh.nguyen)\
**Replies:** 4\
**Last updated:** [October 18, 2022, 8:48pm UTC](https://www.singlestore.com/forum/t/memsql-ops-agent-ssh-equivalent/5855 "2022-10-18T20:48:05Z")

</div>

Do we have anything equivalent to memsql-ops agent-ssh in sdb-admin or tools ? So I can execute a command on each of the node in the cluster ?

---

## [Studio Container Image?](https://www.singlestore.com/forum/t/studio-container-image/4888)

<div class="topic-metadata">

**Author:** [@SteveClementJax](https://www.singlestore.com/forum/u/SteveClementJax)\
**Replies:** 2\
**Last updated:** [August 23, 2022, 12:33am UTC](https://www.singlestore.com/forum/t/studio-container-image/4888 "2022-08-23T00:33:33Z")

</div>

Is there any info about a container image for Studio? Last I saw was a comment from two years ago indicating it was on the roadmap, and seeing a couple of unofficial docker images on the Hub. Just wondering if there’s an…

---

## [Import CSV from local](https://www.singlestore.com/forum/t/import-csv-from-local/1232)

<div class="topic-metadata">

**Author:** [@rtpsr](https://www.singlestore.com/forum/u/rtpsr)\
**Replies:** 4\
**Last updated:** [February 22, 2021, 4:03pm UTC](https://www.singlestore.com/forum/t/import-csv-from-local/1232 "2021-02-22T16:03:11Z")

</div>

Hi, I am new to memsql and trying to import local csv from Windows computer using memsql studio. My setup: Spun up a test cluster on AWS with 1 master node and 1 leaf node using the default cloudformation template. Ha…

---

## [Schedule Routine Tasks in Singlestore](https://www.singlestore.com/forum/t/schedule-routine-tasks-in-singlestore/4813)

<div class="topic-metadata">

**Author:** [@michael.zimberg](https://www.singlestore.com/forum/u/michael.zimberg)\
**Replies:** 1\
**Last updated:** [August 1, 2022, 2:05pm UTC](https://www.singlestore.com/forum/t/schedule-routine-tasks-in-singlestore/4813 "2022-08-01T14:05:39Z")

</div>

Hi, We currently pay for an ec2 instance to run routine scheduled maintenance on our database, using cron and shell. I am wondering if we can use a pipeline instead? Then all the logic will be available in Singlestore …

---

## [Memory usage in OPS source](https://www.singlestore.com/forum/t/memory-usage-in-ops-source/4783)

<div class="topic-metadata">

**Author:** [@ira](https://www.singlestore.com/forum/u/ira)\
**Replies:** 7\
**Last updated:** [July 26, 2022, 2:30pm UTC](https://www.singlestore.com/forum/t/memory-usage-in-ops-source/4783 "2022-07-26T14:30:34Z")

</div>

I want receive allerts when memory or other resources usage is close to limit (e.g., 85% from total). See Dashboard Cluster Usage panel contains TOTAL MEMORY USAGE. There 3 values: Used Reserved Total - just as I re…

---

## [Anyone else have SingleStore Studio crash after looking at Active Queries?](https://www.singlestore.com/forum/t/anyone-else-have-singlestore-studio-crash-after-looking-at-active-queries/4670)

<div class="topic-metadata">

**Author:** [@alau](https://www.singlestore.com/forum/u/alau)\
**Replies:** 8\
**Last updated:** [June 14, 2022, 4:58pm UTC](https://www.singlestore.com/forum/t/anyone-else-have-singlestore-studio-crash-after-looking-at-active-queries/4670 "2022-06-14T16:58:45Z")

</div>

So here are 2 scenarios that is causing SingleStore Studio to crash. I had SingleStore studio on my local Docker Desktop and thought it was the issue whenever I when to look at an active queries It would crash. I t…

---

## [Automation for deploying the Memsql DB objects](https://www.singlestore.com/forum/t/automation-for-deploying-the-memsql-db-objects/1386)

<div class="topic-metadata">

**Author:** [@Shivakumarfk](https://www.singlestore.com/forum/u/Shivakumarfk)\
**Replies:** 8\
**Last updated:** [April 13, 2022, 11:35am UTC](https://www.singlestore.com/forum/t/automation-for-deploying-the-memsql-db-objects/1386 "2022-04-13T11:35:20Z")

</div>

Hi Team, we are looking for automating the deployment of creation table/index etc. in the Memsql. Do we have any tools to suggest ? if no tools , is there any suggestions for approach ?

---

## [Studio extremely slow when managing a large number of databases](https://www.singlestore.com/forum/t/studio-extremely-slow-when-managing-a-large-number-of-databases/3296)

<div class="topic-metadata">

**Author:** [@celer-tech](https://www.singlestore.com/forum/u/celer-tech)\
**Replies:** 11\
**Last updated:** [March 10, 2022, 8:35pm UTC](https://www.singlestore.com/forum/t/studio-extremely-slow-when-managing-a-large-number-of-databases/3296 "2022-03-10T20:35:04Z")

</div>

We have 50+ databases in our cluster and Studio is extremely slow to use. Any refresh of the database list or drill down to the tables / columns of a database makes it freeze for several seconds. We are now moving away …

---

## [SingleStore DB how to set the table name case sensitivity to OFF](https://www.singlestore.com/forum/t/singlestore-db-how-to-set-the-table-name-case-sensitivity-to-off/4127)

<div class="topic-metadata">

**Author:** [@chrisgrasp](https://www.singlestore.com/forum/u/chrisgrasp)\
**Replies:** 3\
**Last updated:** [March 8, 2022, 8:47pm UTC](https://www.singlestore.com/forum/t/singlestore-db-how-to-set-the-table-name-case-sensitivity-to-off/4127 "2022-03-08T20:47:22Z")

</div>

Within SingleStore DB 7.6.12 (non-managed), I can’t seem to figure out how to set table\_name\_case\_sensitivity=OFF properly. I’ve tried running this in SS studio “SET GLOBAL table\_name\_case\_sensitivity=OFF” which gives m…

---

## [Does SingleStore Replicate support character set conversion?](https://www.singlestore.com/forum/t/does-singlestore-replicate-support-character-set-conversion/3757)

<div class="topic-metadata">

**Author:** [@kyoungho.kum](https://www.singlestore.com/forum/u/kyoungho.kum)\
**Replies:** 0\
**Last updated:** [January 19, 2022, 2:31am UTC](https://www.singlestore.com/forum/t/does-singlestore-replicate-support-character-set-conversion/3757 "2022-01-19T02:31:25Z")

</div>

Hi, Does SingleStore Replicate support character set conversion? (e.g. convert “euc-kr” to utf-8) Best regards.

---

## [Where can i find the memsql ops download link?](https://www.singlestore.com/forum/t/where-can-i-find-the-memsql-ops-download-link/3722)

<div class="topic-metadata">

**Author:** [@logan](https://www.singlestore.com/forum/u/logan)\
**Replies:** 0\
**Last updated:** [January 12, 2022, 9:39am UTC](https://www.singlestore.com/forum/t/where-can-i-find-the-memsql-ops-download-link/3722 "2022-01-12T09:39:54Z")

</div>

where can i find the memsql ops download link?

---

## [Columnstore is consuming memory constantly](https://www.singlestore.com/forum/t/columnstore-is-consuming-memory-constantly/3644)

<div class="topic-metadata">

**Author:** [@moralez.rodrigo](https://www.singlestore.com/forum/u/moralez.rodrigo)\
**Replies:** 6\
**Last updated:** [January 10, 2022, 12:45pm UTC](https://www.singlestore.com/forum/t/columnstore-is-consuming-memory-constantly/3644 "2022-01-10T12:45:30Z")

</div>

We are constantly reaching a "has reached the ‘maximum\_memory’ " error when we run queries. In order to save memory we moved all the tables into columnstore (not ideal, but we don’t know what else to do) I cannot detec…

---

## [Unknow files in Memsql leaf folder](https://www.singlestore.com/forum/t/unknow-files-in-memsql-leaf-folder/3255)

<div class="topic-metadata">

**Author:** [@srikar](https://www.singlestore.com/forum/u/srikar)\
**Replies:** 4\
**Last updated:** [November 12, 2021, 6:30pm UTC](https://www.singlestore.com/forum/t/unknow-files-in-memsql-leaf-folder/3255 "2021-11-12T18:30:07Z")

</div>

Dear Team, I Am srikar , new to Memsql and mysql , my server is running out of space so i want to remove unwanted files from my db server and i found the below files in the following path memsql/memsql-installs/leaf-33…

---

## [Kubernetes: Create user permission](https://www.singlestore.com/forum/t/kubernetes-create-user-permission/959)

<div class="topic-metadata">

**Author:** [@vkruoso](https://www.singlestore.com/forum/u/vkruoso)\
**Replies:** 5\
**Last updated:** [November 13, 2021, 10:08am UTC](https://www.singlestore.com/forum/t/kubernetes-create-user-permission/959 "2021-11-13T10:08:58Z")

</div>

Hi! Im running the Kubernetes operator and the default admin user does not have CREATE USER privilegies. How to manage users with k8s operator? Thanks, Vinicius

---

## [Open the studio page and report an error](https://www.singlestore.com/forum/t/open-the-studio-page-and-report-an-error/939)

<div class="topic-metadata">

**Author:** [@zhouzx](https://www.singlestore.com/forum/u/zhouzx)\
**Replies:** 6\
**Last updated:** [November 5, 2021, 4:42pm UTC](https://www.singlestore.com/forum/t/open-the-studio-page-and-report-an-error/939 "2021-11-05T16:42:43Z")

</div>

I installed memsql studio with memsql-studio-1.6.3-1c01a23387.x86\_64.rpm. After opening the page, I get an error : net::ERR\_CONTENT\_LENGTH\_MISMATCH

[Next page](https://www.singlestore.com/forum/c/toolbox/17.md?page=1)
