Allow pinloki failover to be performed by the monitor

Currently pinloki will switch to a new primary if the current one goes down. This is not correct in the case where the failover is initiated via maxscale (i.e. the old primary does not go down, but becomes a replica).