The "\!" command is specific to the mysql client and executes locally,
making it useless for this purpose.
If you don't have access to 5.0.41+ and the database you are querying is a
replicated slave, you can use the 'server_id' variable to tie the server
to an actual hostname (SHOW VARIABLES LIKE 'server_id') as it is unique.
Ben - just curious, why is heartbeat tied in with the server IP? Is it
monitoring the server instead of the mysql daemon to check if it's up? :)
Cheers,
Atle
On Wed, 13 Jun 2007, Scott Tanner wrote:
> There's a 'report-host' option that can be set in the conf file to
> mask the host name. Sounds like this may be set.
>
> If you want to get the server's actual host name from within mysql,
> how about running a system command:
> mysql> \! hostname;
>
> or
>
> mysql> \! cat /etc/hostnames; (debian)
> mysql> \! cat /etc/hosts; (CentOS/rhel)
>
>
>
> Regards,
> Scott
>
>
>
> On Wed, 2007-06-13 at 17:46 +0100, Ben Clewett wrote:
> > What I know is that:
> >
> > Heartbeat with MySQL uses two IP's. That of the server, and that of the
> > resource MySql. The former is fixed, the latter moves with MySQL when
> > it's moved to another server.
> >
> > The one I need is the hostname of the physical server, not the resource.
> >
> > I've installed 5.0.41 and have found that the 'hostname' variable does
> > report the hostname of the physical server. I have no idea how it does
> > it :)
> >
> > I have my solution, thanks for the help,
> >
> > Ben Clewett.
> >
> >
> >
> > Baron Schwartz wrote:
> > > Gerald L. Clark wrote:
> > >> Baron Schwartz wrote:
> > >>> Gerald L. Clark wrote:
> > >>>
> > >>>> Ben Clewett wrote:
> > >>>>
> > >>>>> Dear MySQL,
> > >>>>>
> > >>>>> I'm running 5.0.26 through Heartbeat. Which seems to work
> well,
> > >>>>> even as a replication slave and Heartbeat continously
> stopping and
> > >>>>> starting the server.
> > >>>>>
> > >>>>> The Heartbeat moves MySQL around from server to server when
> a
> > >>>>> failure occures. I am trying to find a way for MySQL to
> report the
> > >>>>> server host name on which it's currently sitting. Without
> any luck.
> > >>>>>
> > >>>>> Would any kind members know of a way of getting this
> information
> > >>>>> from MySQL?
> > >>>>>
> > >>>>> Many thanks,
> > >>>>>
> > >>>>> Ben
> > >>>>>
> > >>>>>
> > >>>> Heartbeat moves the IP address around as well as the services.
> > >>>> Your hostname should not change.
> > >>>
> > >>>
> > >>> DNS won't change, but the server's /etc/hostname will, right?
> > >>>
> > >>> Disclaimer: I'm no expert on this... I didn't even know the IP
> > >>> address moved too. I should read about Heartbeat.
> > >>>
> > >>> Baron
> > >> Do you actually have /etc/hostname?
> > >> RHEL and Centos do not.
> > >> They do have an entry in /etc/sysconfig/network
> > >
> > > Debian and Gentoo have /etc/hostname and /etc/conf.d/hostname,
> > > respectively. I would think this is what /usr/bin/hostname uses, and
> > > probably where the hostname server variable gets set from in MySQL 5.0.41.
> > >
> > > Baron
> > >
> >
> >
>
>
>
