MariaDB Enterprise ColumnStore Switching Over to a New Primary Node

Perform 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

Check 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

For example:

$ maxctrl list servers

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