User Tools

Site Tools


mysql_graphs_-_configuration

This is an old revision of the document!


Table of Contents

MySQL

Configuration

MySQL

  1. Make your sure MySQL server is running.
  2. Run the mysql console and connect as root (remove -p if you have ~/.my.cnf).
    # mysql -u root -p
    Enter password: *****
    mysql>
  3. 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
  4. (Optional) Verify access from localhost.
    # mysql -u bijk -p
    Enter password: random_p4ssw0rd
    mysql> exit

Bijk-node

  1. 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
  2. Restart bijk-node deamon.
    /etc/init.d/bijk-node restart

Bijk.com

  1. Login to your Bijk.com account.
  2. Click on Servers tab.
  3. Click on ON button under Graphs → MySQL column for one of your servers.
  4. Wait for connection from client (immediately) / periodic download (0 - 10 min)

Example graphs

  • Reads

  • Writes

mysql_graphs_-_configuration.1281103089.txt.gz · Last modified: 2010/08/06 15:58 by woky