MySQL
Introduction
The MySQL probe collects information about a MySQL server.
Deployment
The MySQL probe can easily be deployed using our appliance manager.
Probe configuration
Make sure your MySQL server is accessible
You can edit the files in /etc/mysql/ to configure the basic settings – log file, port number, etc. For example, to configure MySQL to listen for connections from network hosts, in the file /etc/mysql/mysql.conf.d/mysqld.cnf, change the bind-address directive to the server’s IP address:
bind-address = 0.0.0.0
Create an infrasonar user and provide the required privileges:
CREATE USER 'infrasonar' IDENTIFIED BY '<MY_SECRET_PASSWORD>';
GRANT SELECT, PROCESS, REFERENCES on *.* TO 'infrasonar';
Add the username and password to your configuration file (INFRASONAR_CONF yaml):
mysql:
config:
username: infrasonar
password: <MY_SECRET_PASSWORD>