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

  1. 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>>';
    
  2. Navigate to the MySQLCollector.conf file.

  3. The default location is /opt/netuitive-agent/conf/collectors/MySQLCollector.conf.

  4. Change the enabled setting to True.

  5. Change the hosts setting to the proper credentials:

  6. 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.