The CMON database is the persistent store for all monitoring data collected from the managed nodes, as well as all ClusterControl metadata (e.g. what jobs there are in the queue, backup schedules, backup statuses, etc.). The CMON Controller requires a MySQL database running on mysql_hostname as defined in the CMON configuration file. The database name and the user is ‘cmon’ and is immutable. The CMON database dump files are shipped together with the CMON Controller package and can be found under /usr/share/cmon once it is installed.
MySQL user ‘cmon’ needs to have proper access to the CMON database by performing the following grant:
Grant all privileges to ‘cmon’ at hostname value (as defined in CMON configuration file) on ClusterControl host:
GRANT ALL PRIVILEGES ON *.* TO 'cmon'@'{hostname}' IDENTIFIED BY '{mysql_password}' WITH GRANT OPTION;Grant all privileges for ‘cmon’ at 127.0.0.1 on ClusterControl host:
GRANT ALL PRIVILEGES ON *.* TO 'cmon'@'127.0.0.1' IDENTIFIED BY '{mysql_password}' WITH GRANT OPTION;On every managed database server, grant all privileges to cmon at the controller’s hostname value (as defined in CMON configuration file) on each of the managed database host:
GRANT ALL PRIVILEGES ON *.* TO 'cmon'@'{hostname}' IDENTIFIED BY '{mysql_password}' WITH GRANT OPTION;If one deploys a cluster using ClusterControl deployment wizard, the above GRANTs will be configured automatically.