Switchover of the Primary Node

To switchover to a new primary node with Enterprise ColumnStore, perform the following procedure.

Performing Switchover in MaxScale

The primary node can be switched in MaxScale using MaxScale's REST API:

• Use MaxCtrl or another supported REST client.

• Call a module command using the call command command.

• As the first argument, provide the name for the module, which is mariadbmon.

• As the second argument, provide the module command, which is switchover .

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

For example:

maxctrl call command \
   mariadbmon \
   switchover \
   mcs_monitor

With the above syntax, MaxScale will choose the most up-to-date replica to be the new primary.

If you want to manually select a new primary, provide the server name of the new primary as the fourth argument:

maxctrl call command \
   mariadbmon \
   switchover \
   mcs_monitor \
   mcs2

Checking the Replication Status with MaxScale

MaxScale is capable of checking the status of MariaDB Replication using MaxScale's REST API:

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

maxctrl list servers

If switchover was properly performed, the State column of the new primary shows Master, Running.

_{This page is: Copyright © 2025 MariaDB. All rights reserved.}