Hi Jerry, let's say that support for agents on windows I leave it for later versions. Seriously, apart from the certification books I never encountered one windows installation based on named pipes in 9 years. I would consider quite safe non supporting windows named pipes at this stage.
thanks for your contribution, Claudio 2011/3/3 Jerry Schwartz <je...@gii.co.jp> > 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 > > > > -- Claudio