MySQL
MySQL is an open source relational database management system that uses the Structured Query Language to navigate its stores. CloudWisdom can help monitor the performance and throughput of your MySQL database.
Tip
MariaDB can be integrated into CloudWisdom following the same steps as described below.
Prerequisites
The Linux Agent must be setup before you proceed with the MySQL integration.
Configure
Open the interface for the database you want to monitor and enter one of the following commands:
For Normal Usage:
GRANT REPLICATION CLIENT on *.* TO '<<username>>'@'<<host>>' IDENTIFIED BY '<<password>>';
If you're having permission issues with the above command, try this one instead:
GRANT ALL PRIVILEGES ON * . * TO '<<username>>'@'<<host>>';
For Innodb Engine Status:
GRANT SUPER ON *.* TO '<<username>>'@'<<host>>' IDENTIFIED BY '<<password>>';
For Innodb Engine Status on MySQL Versions 5.1.24 and greater:
GRANT PROCESS ON *.* TO '<<username>>'@'<<host>>' IDENTIFIED BY ''<<password>>';
Navigate to the MySQLCollector.conf file.
The default location is
/opt/netuitive-agent/conf/collectors/MySQLCollector.conf
.Change the enabled setting to
True
.Change the hosts setting to the proper credentials:
Save the file, and restart the Linux Agent.
Collector Options
Option | Default | Description |
---|---|---|
enabled | FALSE | Enable collecting MySQL metrics. |
hosts | username:password@127.0.1.1:3306/mysql, | List of hosts to collect from. Use db “None” to avoid connecting to a particular database. The format is username:password@host:port/db[/nickname] |
master | TRUE | Enable collecting SHOW MASTER STATUS. |
metrics_blacklist | “^Ssl_ | ^Innodb_ |
byte_unit | Default numeric output(s). | |
innodb | Enable collecting SHOW ENGINE INNODB STATUS. | |
measure_collector_time | Measure the collector’s run time in milliseconds. | |
metrics_whitelist | Regex list to match metrics to transmit. Mutually exclusive with metrics_blacklist option. | |
publish | Which SHOW GLOBAL STATUS rows you would like to publish, or leave blank to publish all rows. | |
slave | Enable collecting SHOW SLAVE STATUS. |