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
--
MySQL General Mailing List
For list archives: http://lists.mysql.com/mysql
To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
