Node Requirements for SingleStoreDB Cloud Commands

SingleStoreDB Cloud commands must be run on the appropriate type(s) of node in a SingleStoreDB Cloud workspace.

When sync_permissions and enable_query_forwarding are set to ON, all Data Definition Language (DDL) commands can be forwarded from child aggregator to master. This list of requirements reflects this behavior.

X = recommended to run on this type of node
P = possible (but not recommended) to run on this type of node
blank = cannot run on this type of node

SingleStoreDB Cloud Command	Master Aggregator	Child Aggregator	Leaf
ANALYZE	X	X
ALTER DATABASE	X	X
ALTER RESOURCE POOL	X	X
ALTER TABLE	X	X	P
ALTER VIEW	X	X	P
ALTER USER	X	X
ALTER PIPELINE	X	X
BACKUP DATABASE	X	X
BEGIN	X	X	P
COMMIT	X	X	P
CREATE AGGREGATE	X	X
CREATE DATABASE	X	X	P
CREATE FUNCTION	X	X
CREATE GROUP	X	X
CREATE INDEX	X	X	P
CREATE PIPELINE	X	X
CREATE PROCEDURE	X	X
CREATE RESOURCE POOL	X	X
CREATE ROLE	X	X
CREATE TABLE	X	X	P
CREATE USER	X	X
CREATE VIEW	X	X
DELETE	X	X	P
DESCRIBE	X	X	X
DROP AGGREGATE	X	X
DROP DATABASE	X	X	P
DROP FUNCTION	X	X
DROP GROUP	X	X
DROP INDEX	X	X	P
DROP PIPELINE	X	X
DROP PROCEDURE	X	X
DROP RESOURCE POOL	X	X
DROP ROLE	X	X
DROP TABLE	X	X	P
DROP USER	X	X	X
DROP VIEW	X	X	P
DROP … FROM PLANCACHE	X	X	P
EXPLAIN	X	X	X
FLUSH TABLES	X		P
GRANT	X	X	X
GRANT GROUP	X	X	X
GRANT ROLE	X	X	X
INSERT	X	X	P
KILL CONNECTION	X	X	P
KILLALL QUERIES	X	X	P
LOAD DATA	X	X	P
OPTIMIZE TABLE	X	X	P
PROFILE PIPELINE	X	X
REPAIR DATABASE	X	X	X
REPLACE	X	X	P
RESTORE DATABASE	X	X
ROLLBACK	X	X	P
REVOKE	X	X
REVOKE GROUP	X	X
REVOKE ROLE	X	X
SELECT	X	X	P
SHOW COLUMNS	X	X
SHOW CREATE TABLE	X	X	P
SHOW DATABASES	X	X	P
SHOW GRANTS	X	X	X
SHOW INDEX	X	X	P
SHOW INDEXES	X	X	P
SHOW KEYS	X	X
SHOW PLANCACHE	X	X	X
SHOW PROCESSLIST	X	X	X
SHOW REPLICATION STATUS	X	X	X
SHOW SCHEMAS	X	X	P
SHOW GLOBAL STATUS	X	X	X
SHOW GLOBAL VARIABLES	X	X	X
SHOW RESOURCE POOLS	X	X	P
SHOW SESSION STATUS	X	X	X
SHOW SESSION VARIABLES	X	X	X
SHOW STATUS EXTENDED	X	X	X
SHOW TABLE STATUS	X	X	X
SHOW TABLES	X	X	X
SHOW VARIABLES	X	X	X
SHOW WARNINGS	X	X	X
SHOW ERRORS	X	X	X
START PIPELINE	X	X
STOP PIPELINE	X	X
TRUNCATE	X	X
UNLOCK TABLES	X
UPDATE	X	X	P
USE	X	X	P

Node Requirements for SingleStoreDB Cloud Commands

Was this article helpful?

Was this article helpful?