README.md

MariaDB_Monitor

Shiny App: MariaDB Monitor

Installation

devtools::install_github("INWT/MariaDB_Monitor")

Configuration

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.

performance_schema = on

Further Information

Further information and explanations can be found in our blog article:

The App is tested on MariaDB-Server 10.1 with Performance Schema Version 5.6.35.



INWT/MariaDB_Monitor documentation built on March 6, 2020, 7:12 p.m.