openark forge

Open source utilities
 

Quick startup guide

mycheckpoint is becoming larger and loaded with features. This page will help the new comer answering these questions:

How do I start using mycheckpoint and what are the most interesting functionalities?

This short page will describe how to set up mycheckpoint and quickly view HTML reports with interactive charting.

The steps you will follow are:

  1. Install mycheckpoint.
  2. Create a monitoring user and schema.
  3. Setup monitoring for your database via crontab.
  4. View charts using mycheckpoint HTTP server.

Install mycheckpoint

You’ll need to install MySQL-Python: the python driver for MySQL. You can easily do so with apt-get or yum or up2date.

After that, proceed to install mycheckpoint.

Follow these short or detailed instructions.

Create a monitoring user and schema

You’ll need a schema (via CREATE DATABASE) for each server you wish to monitor. You’ll need to create a user with privileges on this schema.

Follow these short or detailed onstructions.

Setup monitoring for your database via crontab

In your crontab, issue something like this:

*/5 * * * * mycheckpoint --user=my_user --password=my_password --host=my_host --socket=/path/to/mysql.sock

Of course, you must replace option values with your own data. But the idea is to have mycheckpoint run every 5 minutes. Try one execution outside crontab to see that it works. Depending on your OS/distro, you may wish to specify full path for the mycheckpoint binary (e.g. /usr/local/bin/mycheckpoint) within crontab.

Later on, you may wish to create a defaults file, and avoid passing the options on command line.

View charts using mycheckpoint HTTP server

Wait for some time. There is no point in looking at charts when you’ve only taken a few samples. Actually, the charts won’t even show within the first hour. Things become interesting after several hours have passed.

Invoke mycheckpoint from the command line with the http argument (regardless of your crontab setup):

mycheckpoint --user=... --password=... --host=... --socket=... http

This starts mycheckpoint as HTTP service, by default listening on port 12306. Point your browser at:

http://host_running_mycheckpoint_server:12306/

And start browsing through HTML reports!

What’s next?

You may want to look at human reports; create alert conditions; generate custom queries. Read the complete documentation.

 
Powered by Wordpress and MySQL. Theme by openark.org