README.md
In INWT/MariaDB_Monitor: Monitor for MariaDB or MySQL

MariaDB_Monitor

Shiny App: MariaDB Monitor

devtools::install_github("INWT/MariaDB_Monitor")

To run the app, the cnf.file configuration file should be customized. The database user of the app must have sufficient privileges to retrieve performance data (e.g., performance_schema). The following create-script is a possibility, but should be adapted from the point of view of security:

CREATE USER 'MariaDBstat'@'%' IDENTIFIED BY 'abc';
GRANT SELECT, PROCESS  ON *.* TO 'MariaDBstat'@'%';
GRANT SELECT  ON `information\_schema`.* TO 'MariaDBstat'@'%';
GRANT SELECT  ON `mysql`.* TO 'MariaDBstat'@'%';
GRANT SELECT  ON `performance\_schema`.* TO 'MariaDBstat'@'%';
FLUSH PRIVILEGES;

The username, password, database host and database port must be entered into the cnf.file file, located in ~/.INWTdbMonitor/cnf.file. Specifying a database is optional. Instead of manually entering the data a configuration wizard can be used by runnung the function promptCnfData().

[client]
user=
password=
database=
host=
port=

In addition, it is necessary that the following entry is set under [mysqld] in the my.cnf of the MariaDB server. It ensures that the server's performance data is collected.