List:General Discussion« Previous MessageNext Message »
From:Dave Juntgen Date:November 13 2009 3:07pm
Subject:MySQL Bin Log Position C API
View as plain text  
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
  
  


Thread
MySQL Bin Log Position C APIDave Juntgen13 Nov