How do I identify which MySQL slave has responded?
- by Kynth
I have a MySql Master server replicating to three Slaves.
A legacy website is performing load-balanced Reads from the Slaves.
Is there a method of identifying from the website which of the Slaves is serving a Read request?
I'd prefer a function that I can use to return a server name or ip address as part of the SELECT, but any reasonable method will do.
Thank you in advance.