MySQL Bin Log Position C API

[Dave Juntgen]

Hello everyone,

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.

For example:

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:

Q->S 

if S:binpos > M:binpos
then 
  Q->S // Slave has executed master bin pos and can be queried.
Else
  Q->M // fallback
fi

Thanks!

--Dave

David W. Juntgen 
Medical Informatics Engineering Inc. 
6302 Constitution Drive
Fort Wayne, IN 46804
Phone: [phone] 
Fax:   [phone] 
www.mieweb.com