Skip to Main Content

GoldenGate

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

Determining the RBA for MySQL Binlog

Noah SSep 9 2024

Hi,

I'm looking for how GoldenGate is determining the RBA (Relative Byte Address) for the changes in MySQL's Binlog (MySQL Version 8.0.32). We are needing this information to implement our observability tool that will be independent of GG. It appears that the RBA for any event in the binlog is close to that of the “Log position” + “Event Size” but that has not lined up with the RBA we're seeing on our end for latter part of the pos field. We know the former part ("sequence number") is the binlog file's numeric suffix. But not the latter “RBA” part.

If the “Log position” and “Event Size” don't constitute the pos ‘s RBA value then may I know what it does consist of and how we could use the MySQL binlog to calculate it (if it’s not explicitly listed in the binlog)?

Thank you,

    Noah
Comments
Post Details
Added on Sep 9 2024
0 comments
47 views