MySQL Bin Log Position C API

Hello everyone,

Is there a way to get the last bin pos of a write using the C API? =20

I'm wanting to use this for MASTER / SLAVE load balancing check.

For example:

M =3D Master
S =3D Slave
W =3D Write
Q =3D Query

W->M (get write bin pos).

Now right after insert go query that rec and try using S servers:

Q->S=20

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

Thanks!

--Dave

David W. Juntgen=20
Medical Informatics Engineering Inc.=20
6302 Constitution Drive
Fort Wayne, IN 46804
Phone: 260.459.6270=20
Fax:=A0 =A0260.459.6271=20
www.mieweb.com
 
 



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/mysql?unsub=3Dgcdmg-mysql-2@m.gmane.o rg