Product Solutions Support
Try MemSQL

Node Requirements for MemSQL Commands

MemSQL commands must be run on the appropriate type(s) of node in a MemSQL cluster.

MemSQL Command Master Aggregator Child Aggregator Leaf
ADD LEAF X X X
AGGREGATOR SET AS MASTER X
ALTER TABLE X P
ATTACH LEAF X
ATTACH PARTITION X
BACKUP X P
BEGIN X X P
COMMIT X X P
CONTINUE REPLICATING P P P
COPY PARTITION X
CREATE DATABASE X P
CREATE INDEX X P
CREATE PARTITION X
CREATE TABLE X P
DELETE X X P
DESCRIBE X X X
DETACH LEAF X
DETACH PARTITION X
DROP DATABASE X P
DROP INDEX X P
DROP PARTITION X
DROP TABLE X P
DROP USER X X X
DROP … FROM PLANCACHE X X P
EXPLAIN X X X
EXPLAIN REBALANCE PARTITIONS X
FLUSH TABLES X X P
GRANT X X X
INSERT X X P
KILL CONNECTION X X P
KILLALL QUERIES X X P
LOAD DATA X X P
LOCK TABLES X X P
OPTIMIZE TABLE X X
PAUSE REPLICATING P P P
PROMOTE PARTITION X
REBALANCE PARTITIONS X
REMOVE LEAF X
REPAIR DATABASE X X X
REPLACE X X P
REPLICATE DATABASE P P P
RESTORE X
RESTORE REDUNDANCY X
ROLLBACK X X P
SELECT X X P
SET GLOBAL X X P
SHOW AGGREGATORS X X
SHOW COLUMNS X X
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 LEAVES X X
SHOW PARTITIONS X X
SHOW PLANCACHE X X X
SHOW PROCESSLIST X X X
SHOW REBALANCE STATUS 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 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
STOP REPLICATING X X X
UNLOCK TABLES X X
UPDATE X X P
USE X X P
Was this article useful?