Hi Steve, Thanks for your tip.
It's not a cluster, I am building a tool to monitor mysql performances and this information(*IP*) is required in a stored procedure on the mysql-agents installations. Being it possible to have multiple mysql instances on the same server the only unique identifier would be the couple [IP-PORT], the port you can get it easily, the IP I did not find it. I dont trust the [hostname] since is slightly more subject to be changed, while the ip on eth0(:0) is a bit more unlikely to be changed. I would like this information when then you collect data in the same vault. Also the IP has some risky values: *IP*: 127.0.0.1, 192.x.x.x, 10.x.x.x While the hostname risky/not unique values would be: *HOSTNAME*: any non official DNS name While IP/HOSTNAME should be unique on any two systems in the "world", the PORT is used to distinguish instances on the same host. Thanks Claudio 2011/3/3 Steve Staples <sstap...@mnsi.net> > On Thu, 2011-03-03 at 13:43 -0600, Chris W wrote: > > > > On 3/2/2011 5:59 PM, Reindl Harald wrote: > > > Am 03.03.2011 00:31, schrieb Claudio Nanni: > > >> Anyone knows how to get the server* IP address* thru SQL? > > > no, because it is nonsense and has nothing to do with a db-server > > > > > > if you connect via tcp you know the ip > > > > > > > Isn't that kind of like going to someones home, knocking on their door, > > and asking, "Where do you live?" > > > > Chris W > > > > What if this is a "load balanced" cluster? Doesn't that setup query > "serverA", and in turn, "serverA" finds the least busiest server in the > "cluster", which could be "serverY", therefore you would have no idea > which server the query was run on? > > But, as far as I can tell, you could only get the "server_id" (which > would have to be unique anyway in the cluster), so you could just add > this to the query: > SELECT @@global.server_id > > Then you can figure out elsewhere what 'server_id' corresponds to what > server ip address. > > Just trying to think of other solutions on why the OP would want this > data... > > Steve > > > > > -- > MySQL General Mailing List > For list archives: http://lists.mysql.com/mysql > To unsubscribe: > http://lists.mysql.com/mysql?unsub=claudio.na...@gmail.com > > -- Claudio
