Setting a Node to Maintenance Mode

To set a node to maintenance mode with Enterprise ColumnStore, perform the following procedure.

Setting the Server State in MaxScale

The server object for the node can be set to maintenance mode in MaxScale using :

• Use or another supported REST client.

• Set the server object to maintenance mode using the set server command.

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

• As the second argument, provide maintenance as the state.

For example:

If the specified server is a primary server, then MaxScale will allow open transactions to complete before closing any connections.

If you would like MaxScale to immediately close all connections, the --force option can be provided as a third argument:

Confirming Maintenance Mode is Set with MaxScale

Confirm the state of the server object in MaxScale using :

• List the servers using the list servers command, like this:

If the node is properly in maintenance mode, then the State column will show Maintenance as one of the states.

Performing Maintenance

Now that the server is in maintenance mode in MaxScale, you can perform your maintenance.

While the server is in maintenance mode:

• MaxScale doesn't route traffic to the node.

• MaxScale doesn't select the node to be primary during failover.

• The node can be rebooted.

• The node's services can be restarted.

Clear the Server State in MaxScale

Maintenance mode for the server object for the node can be cleared in MaxScale using :

• Use or another supported REST client.

• Clear the server object's state using the clear server command.

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

• As the second argument, provide maintenance

For example:

Confirming Maintenance Mode is Cleared with MaxScale

Confirm the state of the server object in MaxScale using :

• List the servers using the list servers command, like this:

If the node is no longer in maintenance mode, the State column no longer shows Maintenance as one of the states.