开发者

How do I identify which MySQL slave has responded?

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 met开发者_JAVA百科hod will do.

Thank you in advance.


 SHOW VARIABLES LIKE 'server_id' 

Each host has to have a own server_id. Should be enough to know which one answered the request.

0

上一篇:

下一篇:

精彩评论

暂无评论...
验证码 换一张
取 消

最新问答

问答排行榜