1 Reply Latest reply: Aug 9, 2011 4:13 PM by Paula B-Oracle RSS

    Typical value for heartbeat monitor and send

      Hello forum readers

      We wants to use repmgr version 5.1.19 and we didn't see any recommendation from Oracle about value to set for


      we knows that "Monitor" value should be greater than the "Send", but do you know if setting those values to


      are good value to detect rapidly a failure in Master, I read in previous thread that someone complain that to small values can degrade the performance of the replication data

      Thanks in advance
        • 1. Re: Typical value for heartbeat monitor and send
          Paula B-Oracle
          The best values for DB_REP_HEARTBEAT_MONITOR and DB_REP_HEARTBEAT_SEND are highly dependent on your particular environment. You need to have some idea of how long it could potentially take for a message to travel from the master to a client and make sure your MONITOR value is significantly longer than that.

          It is certainly safe for the MONITOR value to be double the SEND value.

          If the heartbeat monitor expires on a replication client, the client concludes that it has lost its connection to the master and calls an election to find a new master. If the connection disruption is brief and the connection to the master is restored in time, the election stops when the client again finds the original master. If the disruption takes a longer time, the client's election could progress enough to elect another master and the resulting duplicate master situation could take a while to resolve.

          It is not a good idea to risk frequent heartbeat monitor timeouts by setting the MONITOR value small enough that timeouts are easily triggered by the expected communications speed of your environment.

          Paula Bingham