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