MariaDB Enterprise ColumnStore Setting a Node to Maintenance Mode

Overview

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

Set the Server State in MaxScale

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

  • Use MaxCtrl 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:

$ maxctrl set server \
   mcs3 \
   maintenance

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:

$ maxctrl set server \
   mcs3 \
   maintenance \
   --force

Confirm Maintenance Mode is Set with MaxScale

Confirm the state of the server object in MaxScale using MaxScale's REST API:

For example:

$ maxctrl list servers

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

Perform Maintenance

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

While the server is in maintenance mode:

  • MaxScale will not route traffic to the node

  • MaxScale will not 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 MaxScale's REST API:

  • Use MaxCtrl 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 as the state

For example:

$ maxctrl clear server \
   mcs3 \
   maintenance

Confirm Maintenance Mode is Cleared with MaxScale

Confirm the state of the server object in MaxScale using MaxScale's REST API:

For example:

$ maxctrl list servers

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