1 Reply Latest reply: Oct 29, 2010 1:36 PM by 524761 RSS

    notification for changed rows in replicated environment

    613525
      Dear experts,

      Is there any way for application (running in replication client side) to be notified
      when some interested rows are changed in replicated environment.

      Thank you in advance.

      KW
        • 1. Re: notification for changed rows in replicated environment
          524761
          Our standard answer to this question is that Berkeley DB has a feature
          called Application Specific Logging and Recovery that can be used to
          do this. You can read about Application Specific Logging and Recovery
          in the Berkeley DB Programmer's Reference Guide.

          Replication works by distributing copies of log records from the
          master's transaction log. The client applies updates by calling the
          recovery functions with the DB_TXN_APPLY op. So, if you had your own
          log record types added to the transactions of interest, then in your
          recovery function, when you saw the DB_TXN_APPLY op you could notify
          the rest of your application.

          This technique is not for the faint of heart.


          Alan Bram
          Oracle