MariaDB Enterprise ColumnStore Switching Over to a New Primary Node

Overview

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

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:

For example:

$ maxctrl list servers

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