Skip to main content



Bootstrap a Master Aggregator node on the host by promoting a node to Master Aggregator.

This command must be run from the same host that the node is on.

If --memsql-id is not specified, memsqlctl will check if there is only one untyped node on the local host. and if so, choose that node to be bootstrapped.


  memsqlctl bootstrap-aggregator [flags]

  -h, --help               Help for bootstrap-aggregator
      --host string        The cluster-addressable hostname of the local host
      --license LICENSE    The license to apply to the node before bootstrapping
      --memsql-id string   The node ID

Global Flags:
  -c, --config FILE_PATH                     Path to the memsqctl config file
      --default-install-dir DIRECTORY_PATH   Path to the default install directory
      --insecure-ssl                         Fall back to insecure SSL connections to local SingleStoreDB nodes if memsqlctl is unable to otherwise establish a connection (ADVANCED)
  -j, --json                                 Print output in JSON format
      --node-metadata-file FILE_PATH         Path to the node metadata file
      --parallelism POSITIVE_INTEGER         Maximum amount of operations to be run in parallel
      --ssl-ca FILE_PATH                     The path to the CA certificate file (in PEM format) to authenticate the database certificate
      --timeout duration                     Maximum time for operation to complete (e.g., 30s, 10m, 1.5h)
      --verbose-json                         Print output in JSON format, include some warnings and user messages
  -v, --verbosity count                      Increase logging verbosity
  -y, --yes                                  Enable non-interactive mode and assume the user would like to move forward with the proposed actions by default


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

  • The memsqlctl bootstrap-aggregator command is equivalent to the sdb-admin bootstrap-aggregator command.


The following is the standard output for the bootstrap-aggregator command.

sudo memsqlctl bootstrap-aggregator --host "" --license <license>
memsqlctl will perform the following actions on the local node on port 3306:

Would you like to continue? [y/N]: y
✓ Bootstrapped node with MemSQL ID 179062CAEEBCBDA755B75297BF6D9B2AE4C98FB7