Details
-
New Feature
-
Status: Open (View Workflow)
-
Major
-
Resolution: Unresolved
-
None
-
None
-
None
Description
This is an Enterprise feature. As MaxScale monitors the MariaDB Servers in a cluster and also has data on "itself", this feature is a request to report this somehow. The data to be reported would be, for example, SHOW GLOBAL STATUS, SHOW GLOBAL VARIABLES, SHOW ENGINE INNODB STATUS and possibly even USERSTATS if enabled. The output would be, as I see it, in three ways:
- Through the GUI as a tool to inspect the current cluster configuration. Also, one could add some features to ensure that the configuration is correct, i.e. that all servers in a Galera cluster are configured with the same cache etc.
- As a tool for support, i.e. today we have the user run a script we provide to gather data for us, using MaxScale to do this has some advantages and doing it in JSON makes it nicely structured. There are a few things that the script does that is not available this way, like OS statistics. But this is still a nice and easy way to gather what is likely the most important data, although obviously it doesn't replace the script as not all users run MaxScale and MaxScale can not at this time gather all the necessary data (but maybe we could have a MariaDB Enterprise plugin for that?).
- As a way to actually provide the data to an outside party, like support. This is similar to the point above but the integration is better. I.e. you just supply a support ticket to the MaxScale GUI (or maxctrl) and an email will be sent to MariaDB Support and added to the ticket "automagically".