Sign inTry Free

MEMSQL-STOP

On this page

Stops a SingleStore node given a SingleStore node ID.

Usage

usage: memsql-ops memsql-stop [--settings-file SETTINGS_FILE] [--async]
                              [--all] [--no-prompt] [--hard-stop]
                              [--timeout TIMEOUT]
                              [memsql_id]

Stop a SingleStore node.

positional arguments:
  memsql_id             The ID of the SingleStore node to stop.

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.
  --async               If this option is true, we will exit without waiting
                        for SingleStore to be fully stopped.
  --all                 Stop all SingleStore nodes in the cluster.
  --no-prompt           Skip interactive prompts if ID is not provided. This
                        should be used for non-interactive scripts and
                        automation.
  --hard-stop           If true, we will kill the SingleStore process instead of
                        stopping it.
  --timeout TIMEOUT     Number of seconds to wait for the SingleStore nodes to
                        stop. The default is 300 seconds.

Notes

When stopping a leaf, you should detach it from the cluster first to avoid possibly losing unreplicated data in asynchronous replication mode on that leaf. See DETACH LEAF for more information on this command.

Stopping the master aggregator will leave your cluster without a master aggregator. A master aggregator is required to handle automatic partition failover and DDL operations. Thus, if you plan on stopping the master aggregator for an extended period of time, you should promote another aggregator to master aggregator to preserve availability of all services. See PROMOTE AGGREGATOR … TO MASTER for more information on this command.

If aggregator_failure_detection is set to ON, stopping half or more of the aggregators will cause the other aggregators to stop. Aggregator failure detection is meant to protect data integrity in case of network partitions and is on by default. However, if you stop half of the aggregators and want to keep the other half online, set the global variable aggregator_failure_detection to OFF before stopping the aggregators, and set it back to ON after restarting the aggregators.

Last modified: April 25, 2023

Was this article helpful?

On this page

Was this article helpful?

Verification instructions

Note: You must install cosign to verify the authenticity of the SingleStore file.

Use the following steps to verify the authenticity of singlestoredb-server, singlestoredb-toolbox, singlestoredb-studio, and singlestore-client SingleStore files that have been downloaded.

You may perform the following steps on any computer that can run cosign, such as the main deployment host of the cluster.

  1. (Optional) Run the following command to view the associated signature files.

    curl undefined

  2. Download the signature file from the SingleStore release server.

    • Option 1: Click the Download Signature button next to the SingleStore file.

    • Option 2: Copy and paste the following URL into the address bar of your browser and save the signature file.

    • Option 3: Run the following command to download the signature file.

      curl -O undefined

  3. After the signature file has been downloaded, run the following command to verify the authenticity of the SingleStore file.

    echo -n undefined |
        cosign verify-blob --certificate-oidc-issuer https://oidc.eks.us-east-1.amazonaws.com/id/CCDCDBA1379A5596AB5B2E46DCA385BC \
          --certificate-identity https://kubernetes.io/namespaces/freya-production/serviceaccounts/job-worker \
          --bundle undefined \
          --new-bundle-format -
    Verified OK