Watch the 7.3 Webinar On-Demand
This new release brings updates to Universal Storage, query optimization, and usability that you won’t want to miss.



SingleStore Managed Service does not support this command.

Add the node as a child aggregator to the cluster.


Add the node as a child aggregator to the cluster.

This command will add the specified node as a child aggregator. It requires a
running master aggregator.

A cluster node can be specified by using the --memsql-id flag. The command will
find the host and port of the specified node and provide those as arguments to
the master aggregator.


    memsql-admin add-aggregator --memsql-id 0123ABCDEF

    memsql-admin add-aggregator --host memsql-01 --port 3306

  memsql-admin add-aggregator [flags]

  -h, --help                 Help for add-aggregator
      --host string          The cluster-addressable hostname for the aggregator
      --memsql-id MemsqlID   The MemSQL ID of the node to be added as an aggregator
  -p, --password STRING      The user's password for connecting to MemSQL
      --port PORT            The cluster-addressable port for the aggregator
      --user string          The MemSQL database user (default "root")

Global Flags:
      --backup-cache FILE_PATH              File path for the backup cache
      --cache-file FILE_PATH                File path for the Toolbox node cache
  -c, --config FILE_PATH                    Toolbox configuration file path
      --disable-spinner                     Disable the progress spinner, which some terminal sessions/environments may have issues with
  -j, --json                                Enable JSON output
      --parallelism POSITIVE_INTEGER        Maximum number of operations to run in parallel
      --runtime-dir DIRECTORY_PATH          Where to store Toolbox runtime data
      --ssh-max-sessions POSITIVE_INTEGER   Maximum number of SSH sessions to open per host, must be at least 3
      --state-file FILE_PATH                Toolbox state file path
  -v, --verbosity count                     Increase logging verbosity: valid values are 1, 2, 3. Usage -v=count or --verbosity=count
  -y, --yes                                 Enable non-interactive mode and assume the user would like to move forward with the proposed actions by default


When using this command, you should use --memsql-id rather than --host and/or --port.

This command is interactive unless you use either the --yes or --json flags to override interactive behavior.