List:General Discussion« Previous MessageNext Message »
From:Scott Tanner Date:June 13 2007 6:07pm
Subject:Re: MySql Host through Heartbeat
View as plain text  
  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
> > 
> 
> 

Thread
MySql Host through HeartbeatBen Clewett12 Jun
  • Re: MySql Host through HeartbeatBaron Schwartz12 Jun
    • Re: MySql Host through HeartbeatBen Clewett12 Jun
  • Re: MySql Host through HeartbeatGerald L. Clark12 Jun
    • Re: MySql Host through HeartbeatBaron Schwartz12 Jun
      • Re: MySql Host through HeartbeatGerald L. Clark12 Jun
        • Re: MySql Host through HeartbeatBaron Schwartz12 Jun
          • Re: MySql Host through HeartbeatBen Clewett13 Jun
            • Re: MySql Host through HeartbeatScott Tanner13 Jun
              • Re: MySql Host through HeartbeatAtle Veka14 Jun