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: 260.459.6270 
Fax:   260.459.6271 
www.mieweb.com
  
  



--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe:    http://lists.mysql.com/mysql?unsub=arch...@jab.org

Reply via email to