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

    Typical value for heartbeat monitor and send

    857786
      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

      DB_REP_HEARTBEAT_MONITOR
      DB_REP_HEARTBEAT_SEND

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

      DB_REP_HEARTBEAT_MONITOR=1sec
      DB_REP_HEARTBEAT_SEND=0.5sec
      or
      DB_REP_HEARTBEAT_MONITOR=2sec
      DB_REP_HEARTBEAT_SEND=1sec


      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
          Oracle