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 SingleStore 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 SingleStore nodes in the cluster.
optional arguments:
--settings-file SETTINGS_FILE
A path to a MemSQL Ops settings.conf file. If not set,
we will use the file in the same directory as the
MemSQL Ops binary.
-q, --quiet Only display SingleStore ids.
-j, --json Print output as JSON.
-r {leaf,aggregator,master} [{leaf,aggregator,master} ...], --memsql-role {leaf,aggregator,master} [{leaf,aggregator,master} ...]
Only list SingleStore nodes with the specified role.
--availability-group {1,2}
Only show leaves in the specified availability group.
--agent-id AGENT_ID Only list SingleStore nodes that are collocated with the
specified agent.
--local Only list SingleStore nodes which are on the local MemSQL
Ops agent.
--include-unmonitored
Include nodes that we have unmonitored.
Last modified: April 25, 2023