Description:
It would be great if there could be a mysqlproxy object that can see into the SHOW SLAVE STATUS. More specifically, that could see the difference in position between the master log file and the current exec position in the relay log file.
Basically it would be great if proxy could send reads elsewhere if replication does not work or is "far behind" on a server.
"far behind" is complex (what with different log files, etc), so a good first approximation is whether or not both the SQL and IO threads are running.
(although this could be the start of a truly robust and accurate slave status check -- check the current exec position in the relay log file on the slave, check the current master position on the master (ie, not what the slave thinks!), and use that to extract how far behind the slave is).
How to repeat:
no repeat; feature request.
