MySQL Bugs: #40461: Implement hierarchical service manager

Bug #40461	Implement hierarchical service manager
Submitted:	31 Oct 2008 16:58
Reporter:	Axel Schwenke	Email Updates:
Status:	Verified	Impact on me:	None
Category:	MySQL Enterprise Monitor	Severity:	S4 (Feature request)
Version:	1.x, 2.0, 2.1	OS:	Any
Assigned to:	Mark Matthews	CPU Architecture:	Any
Tags:	windmill

Description:
Currently there can be only one service manager in a MEM installation. With very many MySQL servers and/or MySQL servers in multiple data centers, this is far from perfect:

- scalability problems with >100 servers
- with one global service manager and multiple data centers, there is agent traffic between data centers
- with one service manager per data center, there is no overview for all servers

How to repeat:
n/a

Suggested fix:
It should be possible to configure service managers in a hierarchical fashion. MySQL servers would report to their (lowest level) service manager. Service managers would report consolidated data to higher level service managers.

Agent traffic would be local and data centers would be independent but there would still be an overview available.