Perform a manual failover

Command

CLUSTER FAILOVER

What it does

When run on a replica, starts a controlled failover by promoting that replica to master.

When to use it

When you want to hand the master role over to a replica before maintenance.

Caution

This command must be run on the target replica, not on the master itself.