Removing a Node

To remove a node from Enterprise ColumnStore, perform the following procedure.

Unlinking from Service in MaxScale

The server object for the node must be unlinked from the service using :

• Unlink the server object from the service using the unlink service command.

• As the first argument, provide the name of the service.

• As the second argument, provide the name of the server.

Checking the Service in MaxScale

To confirm that the server object was properly unlinked from the service, the service should be checked using :

• Show the services using the show services command, like this:

Unlinking from Monitor in MaxScale

The server object for the node must be unlinked from the monitor using :

• Unlink a server object from the monitor using the unlink monitor command.

• As the first argument, provide the name of the monitor.

• As the second argument, provide the name of the server.

Checking the Monitor in MaxScale

To confirm that the server object was properly unlinked from the monitor, the monitor should be checked using :

• Show the monitors using the show monitors command, like this:

Removing the Server from MaxScale

The server object for the node must also be removed from MaxScale using :

• Use or another supported REST client.

• Remove the server object using the destroy server command.

• As the first argument, provide the name for the server.

For example:

Checking the Server in MaxScale

To confirm that the server object was properly removed, the server objects should be checked using :

• Show the server objects using the show servers command, like this:

Stopping the Enterprise ColumnStore Services

The Enterprise Server. Enterprise ColumnStore, and CMAPI services can be stopped using the systemctl command.

Perform the following procedure on the node:

1. Stop the MariaDB Enterprise Server service:

2. Stop the MariaDB Enterprise ColumnStore service:

3. Stop the CMAPI service:

Removing the Node from Enterprise ColumnStore

The node must be removed from Enterprise ColumnStore using :

• Remove the node using the endpoint path.

• Use a , such as curl .

• Format the JSON output using jq for enhanced readability.

For example, if the primary node's host name is mcs1 and the IP address for the node to remove is 192.0.2.3:

• In ES 10.5.10-7 and later:

• In ES 10.5.9-6 and earlier:

Example output:

Checking the Enterprise ColumnStore Status

To confirm that the node was properly removed, the status of Enterprise ColumnStore should be checked using :

• Check the status using the endpoint path.

For example, if the primary node's host name is mcs1:

Example output: