Chevron Left Icon
Bars Icon
Product
Managed Service
Cloud Database-as-a-service
Database Software
Deploy SingleStore anywhere
Stream Icon
Ingest Data
Tools Icon
Tools and Monitoring
Lock Icon
Security
Sync Icon
Replace MySQL
Solutions
Use Cases
How SingleStore is used
Customers
Learn who uses SingleStore
Briefcase Icon
Professional Services
Industry Icon
Industries
Sitemap Icon
Architectures
Check Icon
Comparisons
Docs
Documentation
Set up and use SingleStore's products and tools
How SingleStore Works
A concise overview of SingleStore
Life Ring Icon
Support
Comments Icon
Forums
List Icon
Release Notes
Learn
Developer Hub
Begin building faster data applications
Resources
Whitepapers, ebooks, videos and more
Calendar Icon
Events
Rss Icon
Blog
Newspaper Icon
News
Presentation Icon
Training
Video Icon
Product Demo
Pricing
Envelope Icon
Envelope Icon
User Circle Icon
Laptop Icon
Portal
Access Managed Service & Licenses
Comments Icon
Forums
Ask the Community
Users Class Icon
Training
Self-Paced Learning
Life Ring Icon
Enterprise Support
Submit a Ticket
Start Free
Bars Icon
Chevron Left Icon
Bars Icon
Database Icon
Product
Analytics Icon
Solutions
Code Icon
Docs
Book Icon
Learn
Dollar Sign Icon
Pricing
User Circle Icon
Sign In
Arrow Right Icon
Start Free
Cloud Icon
Managed Service
Cloud Database-as-a-service
Database Icon
Database Software
Deploy SingleStore anywhere
Stream Icon
Ingest Data
Tools Icon
Tools and Monitoring
Lock Icon
Security
Sync Icon
Replace MySQL
Lightbulb Icon
Use Cases
How SingleStore is used
Users Icon
Customers
Learn who uses SingleStore
Briefcase Icon
Professional Services
Industry Icon
Industries
Sitemap Icon
Architectures
Check Icon
Comparisons
Book Icon
Documentation
Set up and use SingleStore's products and tools
Database Icon
How SingleStore Works
A concise overview of SingleStore
Life Ring Icon
Support
Comments Icon
Forums
List Icon
Release Notes
Laptop Icon
Developer Hub
Begin building faster data applications
File Download Icon
Resources
Whitepapers, ebooks, videos and more
Calendar Icon
Events
Rss Icon
Blog
Newspaper Icon
News
Presentation Icon
Training
Video Icon
Product Demo
Laptop Icon
Portal
Access Managed Service & Licenses
Comments Icon
Forums
Ask the Community
Users Class Icon
Training
Self-Paced Learning
Life Ring Icon
Enterprise Support
Submit a Ticket
Contact Us
Back
Latest
v7.1
v7.0
v6.8
v6.7
v6.5
v6.0
v5.8
v5.7
v5.5
v5.1
v5.0
Introduction
Documentation Overview
How MemSQL Works
FAQs
MemSQL FAQ
Support FAQ
Guides
Overview
Deploy MemSQL
Data Ingest
Development
Cluster Management
Client and Application
Concepts
Concepts Overview
Aggregator
Code Generation
Columnstore
Database
Data Skew
Distributed Architecture
Distributed SQL
Geospatial Guide
Indexes
Information Schema
JSON Guide
Leaf
Master Aggregator
Memory Management
MySQL Features Unsupported in MemSQL
Prepared Statements
Partitions
Persistent Computed Columns
Queries
System Status
System Variables
Table
Window Functions Guide
Workload Management
Pipelines
Pipelines Overview
Extractors
Transforms
Pipelines System Variables
Pipelines Information Schema Tables
Kafka Pipelines Overview
Kafka Pipelines Quickstart
S3 Pipelines Overview
S3 Pipelines Quickstart
Tools
MemSQL Ops
MemSQL Ops Overview
MemSQL Ops Architecture
MemSQL Ops Command Line Interface
Status Page
Cluster Page
Schema Explorer Page
Query Explorer Page
Data Import Page
Speed Test
Pipelines Management
Reference
Configuration Reference
memsql.cnf (MemSQL Configuration)
settings.conf (MemSQL Ops Configuration)
MemSQL Ops CLI Reference
Overview
Local MemSQL Ops Agent Management
Overview
UNFOLLOW
STATUS
STOP
SSL-SET-CERT
SSL-DISABLE
AGENT-ID
VERSION
UNINSTALL
START
FOLLOW
RESTART
CLUSTER-MANUAL-CONTROL
MemSQL Backup Management
Overview
DATABASE-BACKUP
AGENT-BACKUP
BACKUP-LIST
AGENT-RESTORE
DATABASE-RESTORE
BACKUP-DELETE
MemSQL License Management
Overview
LICENSE-LIST
LICENSE-ADD
MemSQL Node and Cluster Management
Overview
MEMSQL-ENABLE-HIGH-AVAILABILITY
MEMSQL-LIST
MEMSQL-OPTIMIZE
MEMSQL-PATH
MEMSQL-DEPLOY
MEMSQL-STOP
MEMSQL-UPGRADE
MEMSQL-UPDATE-ROOT-PASSWORD
MEMSQL-UPDATE-CONFIG
MEMSQL-DELETE
MEMSQL-MONITOR
MEMSQL-RESTART
MEMSQL-UNMONITOR
MEMSQL-START
MemSQL Ops File Management
Overview
FILE-DELETE
FILE-ADD
FILE-LIST
MemSQL Ops Job Management
Overview
JOB-INFO
JOB-LOGS
JOB-CANCEL
JOB-WAIT
JOB-LIST
MemSQL Ops Superuser Management
Overview
SUPERUSER-LIST
SUPERUSER-ADD
SUPERUSER-DELETE
MemSQL Ops Tools
Overview
REPORT
Remote MemSQL Ops Agent Management
Overview
AGENT-UPGRADE
AGENT-START
AGENT-UNINSTALL
AGENT-LIST
AGENT-SET-CREDENTIAL
AGENT-DEPLOY
AGENT-PUT
AGENT-SSH
AGENT-GET
AGENT-STOP
AGENT-MOVE-MEMSQL-INSTALLS-DIR
Spark Management
Overview
SPARK-PIPELINE-EXPORT
SPARK-DISCONNECT
SPARK-DEPLOY
SPARK-SHELL
SPARK-COMPONENT-START
SPARK-COMPONENT-LIST
PIP
SPARK-COMPONENT-MONITOR
SPARK-PIPELINE-IMPORT
SPARK-CONNECT
SPARK-UPGRADE
INTERFACE-SET-JAR
SPARK-COMPONENT-UNMONITOR
SPARK-COMPONENT-STOP
SPARK-UNINSTALL
SQL Reference
Overview
Data Types
Aggregate Functions
Overview
VAR_SAMP
MAX
GROUP_CONCAT
VARIANCE
MIN
COUNT
AVG
STDDEV_SAMP
APPROX_COUNT_DISTINCT
SUM
STD
Cluster Management Commands
Overview
SHOW REBALANCE STATUS
DROP PARTITION
SHOW AGGREGATORS
ATTACH PARTITION
Node Requirements for MemSQL Commands
CREATE PARTITION
REBALANCE PARTITIONS
DETACH PARTITION
SHOW CLUSTER STATUS
ATTACH LEAF ALL
EXPLAIN REBALANCE PARTITIONS
PROMOTE PARTITION
COPY PARTITION
AGGREGATOR SET AS MASTER
ADD LEAF
DETACH LEAF
RESTORE REDUNDANCY
ATTACH LEAF
REMOVE LEAF
SHOW LEAVES
SHOW PARTITIONS
Conditional Functions
Overview
ISNULL
IFNULL
COALESCE
GREATEST
IF
SLEEP
LEAST
CASE
NULLIF
ELT
CONVERT
Data Definition Language (DDL)
Overview
LOCK TABLES
DROP DATABASE
UNLOCK TABLES
DROP TABLE
DROP VIEW
ALTER TABLE
CREATE DATABASE
CREATE INDEX
CREATE TABLE
DESCRIBE
DROP INDEX
FLUSH TABLES
ALTER VIEW
DROP ... FROM PLANCACHE
CREATE VIEW
Data Manipulation Language (DML)
Overview
USE
ROLLBACK
COMMIT
BEGIN
SELECT
TRUNCATE
INSERT
DELETE
UNION
EXPLAIN
UPDATE
LOAD DATA
WITH (Common Table Expressions)
REPLACE
PROFILE
Date and Time Functions
Overview
UNIX_TIMESTAMP
TIMESTAMP
WEEKDAY
YEAR
DAYNAME
LOCALTIMESTAMP
TIME_TO_SEC
MINUTE
DATEDIFF
UTC_TIMESTAMP
FROM_DAYS
TIME
SEC_TO_TIME
FROM_UNIXTIME
CURRENT_TIMESTAMP
MONTHNAME
CURRENT_DATE
HOUR
DAY
DATE
CURRENT_TIME
UTC_DATE
LAST_DAY
MONTH
UTC_TIME
QUARTER
SECOND
DAYOFWEEK
DAYOFYEAR
DATE_ADD
DATE_FORMAT
DATE_SUB
GET_FORMAT
TO_SECONDS
TIMESTAMPADD
EXTRACT
TIMESTAMPDIFF
ADDTIME
STR_TO_DATE
WEEK
CONVERT_TZ
TIMEDIFF
TO_DAYS
TIME_FORMAT
DATE_TRUNC
Geospatial Functions
Overview
GEOGRAPHY_LONGITUDE
GEOGRAPHY_LATITUDE
GEOGRAPHY_AREA
GEOGRAPHY_POINT
GEOGRAPHY_LENGTH
APPROX_GEOGRAPHY_INTERSECTS
GEOGRAPHY_DISTANCE
GEOGRAPHY_CONTAINS
GEOGRAPHY_INTERSECTS
GEOGRAPHY_WITHIN_DISTANCE
JSON Functions
Overview
JSON_SET_<type>
JSON_ARRAY_PUSH_<type>
JSON_DELETE_KEY
JSON_GET_TYPE
JSON Keypaths
JSON_ARRAY_CONTAINS_<type>
JSON_LENGTH
JSON_EXTRACT_<type>
JSON_SPLICE_<type>
Numeric Functions
Overview
CEIL
SIN
ATAN2, ATAN
DEGREES
ASIN
ROUND
TRUNCATE
ACOS
COT
BIT_COUNT
bitwise AND (&)
LAST_INSERT_ID
TAN
bitwise OR (|)
PI
COS
ABS
SQRT
bitwise XOR (^)
LOG
ATAN
POW
bitwise left shift (<<)
bitwise NOT (~)
bitwise right shift (>>)
RADIANS
FLOOR
RAND
Operational Commands
Overview
PAUSE REPLICATING
KILLALL QUERIES
BACKUP
RESTORE
KILL CONNECTION
SELECT GLOBAL
SET GLOBAL
SHOW REPLICATION STATUS
ANALYZE
REPAIR DATABASE
CONTINUE REPLICATING
SNAPSHOT DATABASE
REPLICATE DATABASE
STOP REPLICATING
Pipelines Commands
Overview
CREATE PIPELINE
START PIPELINE
STOP PIPELINE
TEST PIPELINE
ALTER PIPELINE
DROP PIPELINE
Security Management Commands
Overview
SHOW GROUPS
SHOW GROUPS FOR ROLE
DROP USER
SHOW ROLES FOR GROUP
DROP ROLE
SHOW GRANTS
SHOW ROLES
GRANT GROUP
GRANT ROLE
CREATE GROUP
CREATE ROLE
REVOKE GROUP
REVOKE ROLE
DROP GROUP
SET PASSWORD
SHOW ROLES FOR USER
SHOW USERS
CURRENT_USER
SHOW USERS FOR ROLE
SHOW USERS FOR GROUP
GRANT
SHOW GROUPS FOR USER
REVOKE
Permissions Matrix
Default Mode Permissions Changes
Strict Mode Permissions
SHOW Commands
Overview
SHOW SCHEMAS
SHOW WARNINGS
SHOW PLANCACHE
SHOW STATUS EXTENDED
SHOW KEYS
SHOW SESSION STATUS
SHOW TABLES
SHOW VARIABLES
SHOW INDEXES
SHOW INDEX
SHOW COLUMNS
SHOW TABLE STATUS
SHOW PROCESSLIST
SHOW GLOBAL VARIABLES
SHOW SESSION VARIABLES
SHOW GLOBAL STATUS
SHOW DATABASES
SHOW PIPELINES
SHOW CREATE PIPELINE
String Functions
Overview
LENGTH
RIGHT
LPAD
TO_BASE64
LCASE
LEFT
UCASE
UNHEX
FORMAT
CONCAT
FIELD
LTRIM
SHA1
SUBSTRING_INDEX
AES_DECRYPT
CONCAT_WS
FROM_BASE64
BINARY
HEX
SHA2
MD5
CHARACTER_LENGTH
LOCATE
INET_ATON
INET_NTOA
TRIM
RPAD
SUBSTRING
INSTR
ASCII
AES_ENCRYPT
RLIKE
BIN
RTRIM
Window Functions
Overview
RANK
LAG
LEAD
NTILE
DENSE_RANK
PERCENT_RANK
ROW_NUMBER
Troubleshooting Reference
Overview
Capacity Limit Error
Memory Errors
MemSQL Tools Issues
Network Errors
Operations Errors
Query Errors
Release Notes
MemSQL
7.0 Release Notes
6.8 Release Notes
6.7 Release Notes
6.5 Release Notes
6.0 Release Notes
5.8 Release Notes
5.7 Release Notes
5.5 Release Notes
5.1 Release Notes
5.0 Release Notes
4.1 Release Notes
4.0 Release Notes
3.2 Release Notes
3.1 Release Notes
MemSQL Ops
Outdated Version
You are viewing an older version of this section.
View current production version.
/
Deploy MemSQL
/
Deployment: Select one
Deployment: Self-Managed
/
Guide: Select one
Guide: MemSQL Ops
Guide: Cluster Configuration
Select a deployment guide
MemSQL Ops
10-30 min read
Deploy a MemSQL cluster using first-party tools directly.
Start Guide
Cluster Machine Configuration
10 min read
Learn how to configure the host machines in your MemSQL cluster.
Start Guide
Was this Article Helpful?
Thanks For Your Feedback!
Need help
or have suggestions
? Go to SingleStore Forums
Was this Article Helpful?
Thanks For Your Feedback!
Sorry About That
Can you give us a little more context about what we didn’t answer for you? We’ll get back to you as soon as we can.
Question or Feedback
Please enter a valid message
Email
(if you'd like us to respond to you)
Please enter a valid email
Submit
Server error. Please try again.
Sorry About That
Can you give us a little more context about what we didn’t answer for you? We’ll get back to you as soon as we can.
Question or Feedback
Please enter a valid message
Email
(if you'd like us to respond to you)
Please enter a valid email
Submit
Server error. Please try again.