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 :

• Use 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 .

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

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

For example:

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:

Checking the Replication Status with MaxScale

MaxScale is capable of checking the status of using :

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

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