MultiNode PM installation with replication, can I give "hint" to columnstore to prefer one PM over other's as a dbroot backup
Is there a way to give columnstore a hint on which server to prefer for recovering from a node failure?
I've got nodes set up in sort of a buddy-system where pm's 1 and 2 can replicate each other's dbroot and pm's 3 and 4 can do the same. So I'd like to give a hint to columnstore that if pm 1 goes down and pm2 is alive to re-assign dbroot1 to pm2 and vice-versa. Similarly for pm's 3 and 4.
Is there any way to do this?