For MPX migration the failover node, you need to set the failover mode. This is done while connected to the coordinator and server name is one of the reader nodes. Syntax for this is:
ALTER MULTIPLEX SERVER servername ASSIGN AS FAILOVER SERVER
