what happens to connection when failover happens from active to standby

reddev12 This is a fairly loaded question because of the different configuration pieces you can have for HA but the short answer is most likely the connections will timeout and drop. If you have an environment that you are concerned about I would recommend scheduling failover testing and then perform a failover event to see what happens and how long it takes to recover from it. Most people never test failover so they have no clue what to expect or even if failover will happen correctly.