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
