Uninstalling SingleStore DB min read


Info

This topic does not apply to SingleStore Managed Service.

Select a method to uninstall SingleStore DB

  • If your cluster was installed using MemSQL Ops, and is currently managed by MemSQL Ops, select “Uninstall using MemSQL Ops.”

  • If you cluster was installed using MemSQL Ops and was later migrated to using SingleStore Tools, and/or is currently managed by SingleStore Tools, select “Uninstall using SingleStore Tools.”

  1. Use MemSQL Ops to list all running nodes.

    memsql-ops memsql-list
    ****
     ID       Agent Id  Process State  Cluster State  Role        Host        Port  Version 
     44CDE71  A0c8a89   RUNNING        CONNECTED      MASTER      10.0.0.98   3306  x.x
     3FD3FCF  Aa5eab9   RUNNING        CONNECTED      AGGREGATOR  10.0.0.133  3306  x.x
     9C0841F  A04f65f   RUNNING        CONNECTED      LEAF        10.0.0.236  3306  x.x
     9A551DA  A5f0572   RUNNING        CONNECTED      LEAF        10.0.0.136  3306  x.x
    
  2. Use MemSQL Ops to stop monitoring each SingleStore node.

    Use the IDs from the ID column in the MemSQL Ops output.

    Note: Do not remove the leaf nodes if prompted.

    Master Aggregator

    memsql-ops memsql-unmonitor 44CDE71
    ****
    2019-07-02 16:30:23: J9fe705 [INFO] Stopping monitoring for SingleStore node ABECB9CFBB84C5369982BE10A85EC050D20486B0
    2019-07-02 16:30:23: J9fe705 [INFO] No longer monitoring SingleStore node ABECB9CFBB84C5369982BE10A85EC050D20486B0
    

    Child Aggregator

    memsql-ops memsql-unmonitor 3FD3FCF
    ****
    2019-07-02 16:30:54: J6fb0f3 [INFO] Stopping monitoring for SingleStore node 4DF1BC43819C21D33B6D6AAE02C8851F40709FDF
    2019-07-02 16:30:54: J6fb0f3 [INFO] No longer monitoring SingleStore node 4DF1BC43819C21D33B6D6AAE02C8851F40709FDF
    

    Leaf 1

    memsql-ops memsql-unmonitor 9C0841F
    ****
    Would you additionally like to remove the leaf node from the cluster? (You can specify this behavior with --remove-leaf.) [y/n] n
    2019-07-02 16:31:22: J2eae2d [INFO] Stopping monitoring for SingleStore node AF1C3A169BFE4FD792163909BDB592C65D0E37AF
    2019-07-02 16:31:22: J2eae2d [INFO] No longer monitoring SingleStore node AF1C3A169BFE4FD792163909BDB592C65D0E37AF
    

    Note: If a leaf is removed unintentionally, connect to the database and run ADD LEAF to add it back to the cluster: For example, on the Master Aggregator: memsql> ADD LEAF 'root'@'<leaf-node-host-IP>':3307

    Leaf 2

    memsql-ops memsql-unmonitor 9A551DA
    ****
    Would you additionally like to remove the leaf node from the cluster? (You can specify this behavior with --remove-leaf.) [y/n] n
    2019-07-02 16:32:01: J52843c [INFO] Stopping monitoring for SingleStore node 143B60B39072A9E9C16D2D8ACC16E6997286079E
    2019-07-02 16:32:01: J52843c [INFO] No longer monitoring SingleStore node 143B60B39072A9E9C16D2D8ACC16E6997286079E
    

    Note: If a leaf is removed unintentionally, connect to the database and run ADD LEAF to add it back to the cluster: For example, on the Master Aggregator: memsql> ADD LEAF 'root'@'<leaf-node-host-IP>':3307

  3. Use MemSQL Ops to confirm that all SingleStore nodes are no longer monitored.

    memsql-ops memsql-list
    ****
    No SingleStore nodes were found.
    
  4. Remove MemSQL Ops.

    sudo memsql-ops agent-uninstall --uninstall-ops-only --all
    ****
    This will completely delete all MemSQL Ops agents in the cluster, including this one. This operation will delete all MemSQL Ops data in the cluster and cannot be undone.
    If you want to delete all MemSQL Ops agents, please type the word DELETE: DELETE
    2019-09-06 13:58:23: J91ad35 [INFO] Deleting MemSQL Ops agent Ae9f037643ccf4b5fb3b0c03f2dd0da58
    2019-09-06 13:58:23: J4cc070 [INFO] Deleting MemSQL Ops agent Ae2838b5fd2164d3a8691ad71227beee3
    2019-09-06 13:58:23: Jfb011f [INFO] Deleting MemSQL Ops agent Afea25a7c3e184241acdf5296f429298d
    2019-09-06 13:58:27: J4cc070 [INFO] Successfully deleted MemSQL Ops agent Ae2838b5fd2164d3a8691ad71227beee3
    2019-09-06 13:58:27: Jfb011f [INFO] Successfully deleted MemSQL Ops agent Afea25a7c3e184241acdf5296f429298d
    2019-09-06 13:58:27: J91ad35 [INFO] Successfully deleted MemSQL Ops agent Ae9f037643ccf4b5fb3b0c03f2dd0da58
    WARNING: An unmonitored SingleStore node may still exist on this machine.  It had host 172.16.212.165 and port 3306 the last time MemSQL Ops connected to it.
    Stopping MemSQL Ops
    Waiting up to 60 seconds for a clean exit.
    Done.
    Successfully uninstalled MemSQL Ops
    

Depending on which version of SingleStore Tools you use to manage your cluster, you may remove the existing cluster either by a single command, or via sequence of commands.

Removing an existing cluster can be useful for deploying a new cluster in its place, or after moving the existing cluster to another set of hosts.

Using either method, the SingleStore Tools-related binaries (SingleStore client, SingleStore DB Toolbox, and SingleStore DB Studio) can safely be deleted once the cluster has been removed. If you plan to deploy a new cluster, there is no need to delete these binaries.

SingleStore DB Toolbox 1.6.4 and later

As of SingleStore DB Toolbox 1.6.4, you may use a single command to remove a cluster. The command will delete all data, delete all SingleStore nodes, and unregister all hosts.

Alert

Removing a cluster with this command is irreversible.

Run the following command on the Master Aggregator and follow the prompts to remove the cluster.

sdb-deploy destroy-cluster

Refer to sdb-deploy destroy-cluster for more information.

SingleStore DB Toolbox 1.6.3 and earlier

If you’re using SingleStore DB Toolbox 1.6.3 or earlier to manage your cluster, run the following commands in the following sequence to remove a cluster.

  1. Stop all SingleStore nodes and delete them.

    sdb-admin delete-node --all --stop
    
  2. Uninstall all versions of SingleStore DB.

    sdb-deploy uninstall --all --all-versions
    
  3. Unregister all SingleStore DB hosts.

    sdb-toolbox-config unregister-host --all
    
  4. Confirm that SingleStore DB has been uninstalled.

    sdb-toolbox-config list-hosts