pingdom2stats

README

What

Pulls data from Pingdom's API and pushes them to a mysql table.

How to use

A database is needed with the appropriate rights.

• On first run, the user must create the table. They can do that manually or by running: pingdom2mysql --inittable --mysqlurl="username:password@(address)/dbname" in order to create the table (and check the DB connection)

• For every check that it's added, run with --addcheck in order to add the appropriate columns to the table. Attention! For very big tables this might take some time. pingdom2mysql --addcheck --checkid=$YOUR_CHECK_ID --mysqlurl="username:password@(address)/dbname" Two new columns will be created with the name of the check and the check result fields. So your table will look like this:

mysql> describe summary_performances;
+-----------------------------+----------+------+-----+---------+-------+
| Field                       | Type     | Null | Key | Default | Extra |
+-----------------------------+----------+------+-----+---------+-------+
| timestamp                   | datetime | NO   | PRI | NULL    |       |
| $Name_of_check_avgresponse  | int(11)  | YES  |     | NULL    |       |
| $Name_of_check_downtime     | int(11)  | YES  |     | NULL    |       |
+-----------------------------+----------+------+-----+---------+-------+
7 rows in set (0.00 sec)

The program will use $checkid and pull the name of the check witch will use for naming the columns(checkname.go). Run the --addcheck multiple times to add multiple checks.

• Add it to a job scheduler like cron or chronos. I prefer to run it every 20 hours (it pulls the last 24 hours' statistics). Note that if the timestamp exists the program will just update the values. No double timestamps are possible.

• The program should be used like this:

 pingdom2mysql --appkey=$YOURAPPKEY --checkid=$CHECKID --email=$ACCOUNDMAIL --pass=ACCOUNDPASSWORD  --mysqlurl="$DBUSER:$DBPASS@($DBIP:$DBPORT)/$DBNAME" --output="mysql"

You might want to use --output="console" first to see the data that will end up in your database.

Pulling the historical data from Pingdom

In order to pull the historical data and write it in the data store, you need to run fetch_history $UNIX_TIMESTAMP_OF_CHECK_CREATION. You would need to add the configuration variables, lines 4-9 of fetch_history.

Usage information

./pingdom2mysql --help
Using Pingdom's API as described in: https://www.pingdom.com/resources/api
Version: v0.2.1
Usage: pingdom2mysql [options]
All options are required (but some have defaults):
  --addcheck
        Add new check into the mysql table, requires --mysqlurl, --checkid
  --appkey string
        Appkey for pingdom's API
  --checkid string
        ID of the check, aka the domain are we checking.
  --email string
        Pingdom's API configured e-mail account
  --from value
        from which (Unix)time we are asking, default 24 hours ago which is  (default 1500398470)
  --inittable
        Initialize the table, requires --mysqlurl
  --mysqlurl string
        mysql connection in DSN, like: username:password@(address)/dbname
  --output string
        Output destination (console, mysql) (default "console")
  --pass string
        password for pingdom's API
  --to value
        until which (Unix)time we are asking, default now which is  (default 1500484870)