mysql_graphs_-_configuration [Bijk.com - help - howtoServer Monitoring]

mysql_graphs_-_configuration

Table of Contents

MySQL
- Configuration
- Example graphs

MySQL

Configuration

MySQL

Make your sure MySQL server is running.
Run the mysql console and connect as root (remove -p if you have ~/.my.cnf).
```
# mysql -u root -p
Enter password: *****
mysql>
```

Create user bijk with access from localhost only (change random_p4ssw0rd with random password everywhere).

mysql> CREATE USER 'bijk'@'localhost' IDENTIFIED BY 'random_p4ssw0rd';
mysql> FLUSH PRIVILEGES;
mysql> exit

(Optional) Verify access from localhost.

# mysql -u bijk -p
Enter password: random_p4ssw0rd
mysql> exit

Bijk-node

Edit (or create) file /etc/bijk/plugins.yml and add following (YAML) tree. You should avoid using tabulator.
```
mysql:
    default:
        user: bijk
        pass: random_p4ssw0rd
        host: localhost
```
Restart bijk-node deamon.
```
/etc/init.d/bijk-node restart
```

Bijk.com

Go to Servers tab
Click edit in Graphs → Others column on row with desired server
Check the MySQL checkbox

Example graphs

Reads

Writes

mysql_graphs_-_configuration.txt · Last modified: 2010/09/14 15:59 by woky