MEMSQL-LIST
On this page
List information about all MemSQL Ops nodes in the cluster.
This command can be used in conjunction with other memsql-ops
commands to achieve more robust functionality.
memsql-ops memsql-list --agent-id Ad916a -q | xargs -n 1 memsql-ops memsql-restart --no-prompt
This command will restart all SingleStoreDB nodes running in a particular agent with ID prefixed by Ad916a.
Usage
usage: memsql-ops memsql-list [--settings-file SETTINGS_FILE] [-q] [-j][-r {leaf,aggregator,master} [{leaf,aggregator,master} ...]| --availability-group {1,2}][--agent-id AGENT_ID | --local][--include-unmonitored]List SingleStoreDB nodes in the cluster.optional arguments:--settings-file SETTINGS_FILEA path to a MemSQL Ops settings.conf file. If not set,we will use the file in the same directory as theMemSQL Ops binary.-q, --quiet Only display SingleStoreDB ids.-j, --json Print output as JSON.-r {leaf,aggregator,master} [{leaf,aggregator,master} ...], --memsql-role {leaf,aggregator,master} [{leaf,aggregator,master} ...]Only list SingleStoreDB nodes with the specified role.--availability-group {1,2}Only show leaves in the specified availability group.--agent-id AGENT_ID Only list SingleStoreDB nodes that are collocated with thespecified agent.--local Only list SingleStoreDB nodes which are on the local MemSQLOps agent.--include-unmonitoredInclude nodes that we have unmonitored.
Last modified: April 25, 2023