Outdated Version
You are viewing an older version of this section. View current production version.
MEMSQL-DELETE
MemSQL Ops has been deprecated
Please follow this guide to learn how to migrate to SingleStore tools.
Info
MemSQL Helios does not support this command.
Deletes all data for a MemSQL 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 MemSQL node running on <host>:<port>, along with all of its data
The target MemSQL node has role <MEMSQL ROLE>
If you want to delete this node, please type the word DELETE:
Usage
usage: memsql-ops memsql-delete [--settings-file SETTINGS_FILE] [--async]
[--all] [--no-prompt] [--force]
[--delete-without-prompting]
[memsql_id]
Delete a MemSQL node and all of its data.
positional arguments:
memsql_id The ID of the MemSQL 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 MemSQL node to be fully deleted.
--all Delete all MemSQL nodes in the cluster.
--no-prompt Skip interactive prompts if ID is not provided. This
should be used for non-interactive scripts and
automation.
--force If this is true, we will remove this MemSQL node from
the system even if we cannot delete its directory or
if its collocated MemSQL Ops agent is offline.
--delete-without-prompting
If this is true, we will attempt to delete this MemSQL
node without prompting for confirmation.