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.


MemSQL Ops has been deprecated

Please follow this guide to learn how to migrate to SingleStore tools.


SingleStore Managed Service does not support this command.

Deletes all data for a SingleStore node. This operation is not reversible and may lead to data loss. Users who want to perform this operation are prompted to explicitly type ‘DELETE’ to be sure of their decision.

This will completely delete the SingleStore node running on <host>:<port>, along with all of its data
The target SingleStore node has role  <MEMSQL ROLE>
If you want to delete this node, please type the word DELETE:


usage: memsql-ops memsql-delete [--settings-file SETTINGS_FILE] [--async]
                                [--all] [--no-prompt] [--force]

Delete a SingleStore node and all of its data.

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

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 the SingleStore node to be fully deleted.
  --all                 Delete 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
  --force               If this is true, we will remove this SingleStore node from
                        the system even if we cannot delete its directory or
                        if its collocated MemSQL Ops agent is offline.
                        If this is true, we will attempt to delete this SingleStore DB
                        node without prompting for confirmation.