We are using a master/slave replication system where we perform writes on
master and use replication to offload reads.
However, sometimes we have a replication lag of a few seconds and as a
result, after the update, the change is not yet available on the replica.
Is there a way to get XLOG position to which specific update query will be
written? That way we can check if our replica caught up with changes and it
is safe to read it from. Can it be done using SQL functions? Can I get that
information from query protocol?
Thank you!
--
Oleg,
Software Engineer at Slapdash