How can I replay from a specific message ID?
My main purpose is to be able to replay from a specific message. I want to be able to keep track of which was the last message that was successfully processed, so that I wont have to replay from the start or replay the whole day's worth of message. I think that in order to do this, I would need to be able to find out how to find out what was the last successfully processed message ID.
But then comes another thought: are the generated message IDs in HA groups/replication groups sequential/incremental? I would like to be able to replay from the message that was directly after the last successfully processed message. For example - if the last successfully read message id is: rmid1:236f8-31b0b535515-00000000-a24b7e32, would the next message have an increment of one in a specific part of the message id?
I have reviewed this article, but it did not contain the information I am looking for.