search

vitessio / vitess

Vitess is a database clustering system for horizontal scaling of MySQL.
http://vitess.io
Apache License 2.0
18.7k stars 2.1k forks source link

Question: Way to know which vtgate I am connected to #17246

Closed serhatcetinkaya closed 1 day ago

serhatcetinkaya commented 3 days ago

Question

Hello, we are using multiple vtgate's behind a load balancer and our application connects to vtgate through it. While debugging issues sometimes it is useful for us to know which client is connected to which vtgate host.

I checked open issues and vtgate documentation but couldn't see anything useful.

Is there some way to get this information from the client side? Something like select @@hostname; would be great.

shlomi-noach commented 3 days ago

@serhatcetinkaya thank you for your question. Would you mind taking this to the Vitess Slack channel? This would give a better opportunity for more visibility and perhaps also answers by the community 🙏

serhatcetinkaya commented 3 days ago

@shlomi-noach thanks for the quick reply! it looks like I am not a member in Slack Community and for some reason it doesn't allow me to sign in. maybe there is some intermittent issue, I will try again later and update here

edit: joined to the channel, it was my bad

systay commented 1 day ago

I think we can close this now, right?