Sort:  

makes sense. I was looking at "triggers" for the fail over and also talking to @petertag to have a proper fail over tool. So this is one of the conditions that can help. Right now I am manually doing failover between the primary and secondary.