Do you have to worry about named pipes? Regards,
Jerry Schwartz Global Information Incorporated 195 Farmington Ave. Farmington, CT 06032 860.674.8796 / FAX: 860.674.8341 E-mail: je...@gii.co.jp Web site: www.the-infoshop.com >-----Original Message----- >From: Claudio Nanni [mailto:claudio.na...@gmail.com] >Sent: Thursday, March 03, 2011 4:21 PM >To: sstap...@mnsi.net >Cc: mysql@lists.mysql.com >Subject: Re: Get MySQL server IP address in SQL > >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 -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/mysql?unsub=arch...@jab.org
