||Advanced MySQL Replication Techniques|
Response to: Consistency problem?
You are right.
Please be aware that my article is just a proof of concept. It is not an example of what you should do in production, because of this problem.
Currently, you can't detect the master log position using only SQL routines. You should use external applications for that.
At the moment, the technology available in MySQL stored routines is not able to handle such information unassisted.
Hear us Roar