Table of Contents

Recording Stats at VHS

VHS has an InfluxDB/Grafana instance to record and graph datapoints in the cloud.

InfluxDB

InfluxDB is a time-series database. What that means, is that it stores data with respect to time.

Consider a MySQL database. Except instead of sending a new value and overwriting the previous data, InfluxDB keeps track of both, along with the time they were sent (unless you specify a different time).

You can also specify “retention policies” that phase out old datapoints, basic arithmetic and soon, some native analytics.

Some use-cases are current temperature, price of Bitcoin, or common “open” times for isvhsopen.com

A Dataset Example

<WRAP center round box 60%>

{

"results": [
    {
        "series": [
            {
                "name": "cpu_load_short",
                "columns": [
                    "time",
                    "value"
                ],
                "values": [
                    [
                        "2015-01-29T21:55:43.702900257Z",
                        0.55
                    ],
                    [
                        "2015-01-29T21:55:43.702900257Z",
                        23422
                    ],
                    [
                        "2015-06-11T20:46:02Z",
                        0.64
                    ]
                ]
            }
        ]
    }
]

}

</WRAP>

A sample exploration

Login to the InfluxDB interface (linked below)

Select the “api” database in top right

<WRAP center round box 60%> SHOW SERIES

SHOW MEASUREMENTS

SHOW TAG KEYS FROM “api”

SHOW TAG VALUES FROM “api” WITH KEY = “name” </WRAP>

Grafana

Grafana takes those datapoints and makes pretty graphs out of them.