Is there a way to get the last bin pos of a write using the C API?
I'm wanting to use this for MASTER / SLAVE load balancing check.
M = Master
S = Slave
W = Write
Q = Query
W->M (get write bin pos).
Now right after insert go query that rec and try using S servers:
if S:binpos > M:binpos
Q->S // Slave has executed master bin pos and can be queried.
Q->M // fallback
David W. Juntgen
Medical Informatics Engineering Inc.
6302 Constitution Drive
Fort Wayne, IN 46804
|• MySQL Bin Log Position C API||Dave Juntgen||13 Nov|