MySQL Bugs: #40787: Provide hostname, datadir, socket, to server Meta Information

Bug #40787	Provide hostname, datadir, socket, to server Meta Information
Submitted:	17 Nov 2008 14:32	Modified:	20 Jul 2009 12:57
Reporter:	Simon Mudd (OCA)	Email Updates:
Status:	Closed	Impact on me:	None
Category:	MySQL Enterprise Monitor: Web	Severity:	S4 (Feature request)
Version:	2.0.0.7088	OS:	Any
Assigned to:	Eric Herman	CPU Architecture:	Any
Tags:	windmill

Description:
The server Meta Info shown on the right hand side of the screen doesn't show the hostname, datadir, socket and port.

While this may normally coincide with my.server.name:3306 shown in the window this title is configurable.
Also on servers running multiple servers on different ip addresses (rather than different ports) you can not distinguish the instances easily.

How to repeat:
Install 2 mysql servers bound to different ip addresses. They both by default appear identified by hostname:port (both the same). This makes distinguishing the 2 instances really difficult.

Suggested fix:
Add to the server meta information:
- hostname (so it's always known even if you change the display name associated with the server
- socket (local socket bound to this instance). This path will ALWAYS be different for different instances
- datadir which will also be different for each instance

It would be nice to add the port that the server is bound to but the mysqld can't be queried for this information. It can be implied from the connection information used by the agent.

We now show the server UUID (the same one that's in mysql.inventory) in the "Manage Server" tab's pop-ups that are used for renaming servers.

What we're struggling with in adding the information you request in the UI is that technically, an agent is not required for returning information about a mysqld or the host it's on, so it's not as straightforward as just putting this information in the "meta" page, we'd more than likely want to have a "Transports" section that shows all of the various sources of information about the mysqld.

Perhaps adding the list of databases available on the instance would also help distinguish instances running on the same host

Perhaps adding the list of databases available on the instance would also help distinguish instances running on the same host

The uuid is not human friendly or "DBA-obvious" so I'd prefer to avoid something like that.
I think you've now seen how we have our boxes setup so understand the problem I'm having.

Therefore showing the hostname/datadir/socket/bound_ip should help distinguish different instances.

Thank you for a reasonable feature request.

ensure that datadir is collected, and add to UI.

An additional request would be to show the database list held by the relevant instance as often this helps distinguish between once system and another one.

patch queued:
Added hostname, datadir, socket, port to server detail on main page
Added port, datadir to manage servers table
Added socket, datadir to edit server popup (host, port already there)

Keith Russell writes: 
Patch applied in versions => 2.1.0.1074.

Marcos Palacios writes: 
Verified fixed in build 2.1.0.1074.

For the part about "additional request would be to show the database list held by the relevant instance as often this helps distinguish between once system and another one", a new feature request was entered: http://bugs.mysql.com/bug.php?id=46021.

An entry has been added to the 2.1.0 changelog:

In the Enterprise Monitor, the Monitor page did not have detailed server meta information. For example, the hostname, datadir, socket and port information were not displayed.

The interface has now been changed to include the following. Hostname, datadir, socket, and port information has been added to the server meta information on the monitor page. The port and datadir information has been added to the Settings, Manage Servers page. Socket and datadir information has been added to the edit server popup.